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!

 

[Sandeep Warrier]

Hi Richard,

After including the APIs in the conditional compilation, everything seems to work fine. I tested it in 2003,2007 (with Win XP) and 2010-64b (with Win7-64b)

 

[Richard Schollar]

Excellent - many thanks Sandeep

 

[Sandeep Warrier]

You're welcome

All I need to do now is get the VBHTML Maker to work. Have not yet been able to figure out where the problem lies. I get past the API and come up with an error that says object not supported, but does not give a debug option to take me to the problem area

 

[Richard Schollar]

OK I'm going to look at incorporating Conditional Formatting and Data Validation in the output. It will likely only be for xl versions of 2007 or greater due to me only having xl 2010 on any of my home computers now and imminently due to lose xl 2002 on my works computer.

I will try and make it as fully functional as possible.

Also, something which Alan (al_b_cnu) requested is that when constants (text and numbers) are formatted, their colours are as per they appear in the cell (currently, only whole cell font formatting is applied, so words like "what" will appear as "what"). I will probably look at this last as it will (hopefully) be much easier than doing the CF/Validation.

 

[Sandeep Warrier]

Hi Richard,

I don't think this is a very serious issue, but, on posting the first time all data seems to be in place. But on editing the post, the sheet names go to the center of the page.

See http://www.mrexcel.com/forum/showthread.php?p=2572803&posted=1#post2572803

 

[Richard Schollar]

Hi Sandeep

I think that's a product of the way the Board works rather than an issue with the code generated. I had noticed it before - it's like the board seems to remove some of the html wrapping the sheet name when the post gets edited.

 

[Peter_SSs]

I mostly use Excel jeanie and posts using that also go a bit strange when edited (blanks get replaced with asterisks). Again I believe it is a board issue not an Excel jeanie issue. When you edit a post, your HTML code is generally still on your clipboard and I am just in the habit of pasting over the code again when I am editing a post.

 

[Sandeep Warrier]

Thanks for the reply Richard. I made a post a few days back with a simple VLOOKUP solution, and the formula box spanned most of the page width. I've not seen this happening with others posts and so I'm not sure if its something to do with my Excel version.

 

[Richard Schollar]

The new version (ie newer than July 2009) should not have the formulas spanning over many screens - they should all be contained within the active browser window area. This is in contrast to the old version of the maker. If you do notice this happening with the new one, please provide a link to any posts/threads so I can investigate and - touch wood - resolve. Thank you

 

[Sandeep Warrier]

It is not spanning over several screens.

See http://www.mrexcel.com/forum/showthread.php?t=520650

I thought that the formula box would span the width of the formula, and if the formula crossed a certain length, would wrap the formula to contain it within the screen width. In this case, the formula is just a basic VLOOKUP, but the box still spans most of the screen width.