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]

There are a few fixes that I need to incorporate (most pressing is a problem with the user-defined formula selection if only one cell is selected - I have the fix, just need to roll it up in a release), plus the order in which formulas are outputted in the html (think this will be relatively easy to apply) and a somewhat more difficult one which deals with range names (mentioned a couple of posts ago in response to Sankar's query). There are probably others too, but these are the ones I will concern myself. I am also going to change the UI so that it doesn't occupy its own spot on the menu bar but is just part of the Tools menu.

Get that done, and I think it will be more or less ready to go on general release (so that people can go to a download location rather than having to PM me to get it).

Oh, and of course I have not made any xl2007 specific UI changes. So that (and 2010) will no doubt be next on the agenda...

 

[drhatmrexcel]

I am interested in your new version of html maker so that I can post to the mrexcel forums.

Thank you,
Dennis

 

[goofy78270]

I just started using this tool and the first thing that comes up is that you do not have the ability to set a range manually other than highlighting it. I would like an ability to edit the range as done in Excel Jeanie HTML 4 .
This would help greatly when users have merged cells that extend past the 12 row or 30 column limit.

In addition, is there a reason for the limit to column and row size?

 

[Richard Schollar]

No it's a totally arbitrary limit meant to prevent ridiculously large posts. It's easy enough to change in the code if you know what you're doing (there are two public constants in the mSettings module which define these limits:

Public Const MAX_ROWS As Long = 30
Public Const MAX_COL As Long = 12

You'd just need to amend these values.

 

[goofy78270]

As there are surely many other settings that be modified through the project, many users may not know how to access them or be timid in changing them, hence the prompt option to edit the range of selected cells.

In addition, I would like to see a user form that allows the user to edit desired setting such as max row or column counts, showing of borders, copying of cell colors, and such.

 

[Sandeep Warrier]

Hi Richard,

Is it possible to include another option for displaying formulae? Something like "Formula from specified cells/1st cell of specified columns"

http://www.mrexcel.com/forum/showthread.php?p=2141335&posted=1#post2141335

In the thread, formula H2, I2 & J2 is the same (with only references changing), but since I wanted to display formula from G2 too, the "First cell in each column" option gave formulae from all the 4 columns resulting in unnecessary usage of space.

 

[Peter_SSs]

Hi Richard,

Is it possible to include another option for displaying formulae? Something like "Formula from specified cells/1st cell of specified columns"

http://www.mrexcel.com/forum/showthread.php?p=2141335&posted=1#post2141335

In the thread, formula H2, I2 & J2 is the same (with only references changing), but since I wanted to display formula from G2 too, the "First cell in each column" option gave formulae from all the 4 columns resulting in unnecessary usage of space.

Can't you use this?
Generate Html (specify option)|User Defined Selection
then selct the cells/ranges you want with Ctrl+click/drag

 

[Sandeep Warrier]

Can't you use this?
Generate Html (specify option)|User Defined Selection
then selct the cells/ranges you want with Ctrl+click/drag

I want to display all info and formulae only from 1st cell in 2 columns. I'm not sure if this is possible through the "User Defined Selection" option.

 

[Peter_SSs]

You can. All cells in row 1 here have a similar formula, but I have just shown 2 of them using the method I described.

 

[Sandeep Warrier]

Ohh, cool!!

I misinterpreted the meaning of user-defined selection.