Html maker - testers required!

[Richard Schollar]

As some of you may be aware, I have been making an add-in to produce html output of selected data in Excel. The output is fairly consistent with that produced by Excel Jeanie as can be seen here:

http://www.mrexcel.com/forum/showpos...&postcount=241

the differences being:

1. the interface is a whole lot simpler
2. you can choose if you want to output all the formulas in selection or only some of them
3. the ouput colour-codes nesting levels in the formulas
4. it only does formulas and data (it doesn't report conditional formatting or data validation applied)
5. it comes as an .xla file rather than an .exe (so doesn't require Admin rights to install!)
6. the code is visible for anyone that wants to laugh (or cry) at it


The generated html should also be considerably simpler as much of the formatting and style elements are now held in a css file applied to the whole Board (Suat Ozgur has created a css class which I link to in the generated html).

It has been tested by me and Jon von der Heyden and feedback from Suat incorporated. What I need now is for some others to test and come back with any comments.

If you would like to see the file and perhaps test it, please Private Message me with your email address and I'll send you the .xla file and a .doc file with guidance notes:

The .xla file is approx 100Kb in size, so it isn't very big. It will work in all versions of Excel since xl2000, although I will be developing a specific xl2007 ribbon interface next.

Thanks!

 

[Richard Schollar]

Ah - I'll fix that right now Colin. Thanks!

 

[Richard Schollar]

I'll send out another build tonight with the correction required for Colin's point above. In the meantime, the correction I have put through is the following:

In module mGenerateGrid in the Generate_Grid sub replace this line:

vGrid(i + 1, j + 1) = Replace(ReplaceSpace(ReplaceChar(ar.Text)), Chr$(160), " ") 'replace < and > and also spaces

with this line:

    If Len(ar.Text) > 0 Then
        vGrid(i + 1, j + 1) = Replace(ReplaceSpace(ReplaceChar(ar.Text)), Chr$(160), " ") 'replace < and > and also spaces
    End If

 

[yytsunamiyy]

Is it a known issue that your html maker is not picking up Formatting of conditionally formatted cells on default settin gin XL07?

see here: http://www.mrexcel.com/forum/showthread.php?p=2003747#post2003747

 

[Richard Schollar]

Yes - I decided to ignore Conditional Formatting (Data Validation too).

 

[Sandeep Warrier]

Is the 12 column limit a temporary or a permanent feature? Cuz it's possible that even sample data may have more than 12 columns

 

[taigovinda]

I'm a total novice and am enjoying using this tool to help me ask my questions

It seems to slow up Excel quite a bit sometimes, though, when I'm trying to exit. I don't know enough to understand why this add-in needs to save itself. I'm wondering, will it hurt anything if I comment out these two lines?

Private Sub Workbook_BeforeClose(Cancel As Boolean)
CleanUp
----->On Error Resume Next  'in case workbook opened read-only
----->ThisWorkbook.Save
End Sub

Thanks,
Tai

 

[Richard Schollar]

I put that in so the default setting was saved when excel was shut down. you can safely remove that sub altogether though with very minimal impact.

 

[TheNoocH]

***EDIT*** not sure why HTML isn't showing properly???

Richard...looks like one of the updates messed up the alignment on numbers...

These are regular numbers entered into the cell (ie looks like right aligned in Excel...NOTE: but i did not choose right aligned)

Excel Workbook
	C
1	1
2	10
3	100
4	1000
5	10000
6	100000
7	100000
Sheet2

Excel 2007


This is the same data but i clicked on center aligned...

Excel Workbook
	A
1	1
2	10
3	100
4	1000
5	10000
6	100000
7	100000
Sheet2

Excel 2007

This is same data selecting right aligned...

Excel Workbook
	E
1	1
2	10
3	100
4	1000
5	10000
6	100000
7	100000
Sheet2

Excel 2007


PS...I tried to go to the Testing link and it says I don't have authority...did something change...I was able to get into it before...

 

[Joe4]

Nooch,

Just wanted to let you know that I moved your last "stand-alone" test to the "Test Here" forum.

 

[TheNoocH]

Joe,
thanks...i was just looking for it and thought i was losing my mind....

Richard...
here is a link to the html in the above post (#58)...once again not sure why didn't show properly above...
http://www.mrexcel.com/forum/showthread.php?t=405525