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!

 

[schielrn]

That sucks. There doesn't really seem to be anything we can do then. I posted it and then went to edit ti and it was fine, but never tried to do a second preview yet. I have to go now, but I will try to look at it tomorrow when I am back in.

 

[p45cal]

upon further investigation, when the htmlmaker displays in a browser the spaces were already gone. Maybe there is something elsewhere in the code that strips spaces?
When I do the first preview when preparing a message, then add spaces manually either side of the < character, it survives subsequent (multiple) previews and the submit.
I'm not au fait enough with the code to know quickly how to adjust.

 

[p45cal]

Wrong, wrong, wrong. I was using the wrong html maker! It does work.

So the code which appears to work is:

ReplaceChar = Replace(Replace(s, ">", " > "), "<", " < ")

upon further investigation, when the htmlmaker displays in a browser the spaces were already gone. Maybe there is something elsewhere in the code that strips spaces?
When I do the first preview when preparing a message, then add spaces manually either side of the < character, it survives subsequent (multiple) previews and the submit.
I'm not au fait enough with the code to know quickly how to adjust.

 

[schielrn]

Glad that worked for you. I wasn't seeing where it wasn't working and then I looked back at this thread and seeing you said it did work.

 

[Richard Schollar]

Hi All

There is a new version out which principally deals with the problem of the formula boxes extending off the page and being a real pita. Also addressed was:

- a problem of multiple Cell menu items added if you subsequently opened the html maker again.
- Single cell selection when User Defined Selection was chosen resulted in all formulas on the sheet being transcribed into the html
- increase in number of rows/columns in output (up to 100 rows/columns now)
- all cells in generated grid now get formatted (although number of formats available for output hasn't changed yet)
- *potentially* 64bit Excel/Windows problem has been addressed (I haven't tested this yet as I only have 32bit environments)

If anyone wants the update, please drop me a PM with your current email address. I am looking to get it hosted in the near future so you can download it directly rather than having to PM me to get it emailed to you.

Happy New Year!

 

[RoryA]

Yes please.

 

[Richard Schollar]

Rory, have sent to your gmail and gmx addresses.

 

[Sandeep Warrier]

Hi Richard,

I'm using the last version (20090730A) of the HTML Maker on the 64-bit version. Got it to work after making a couple of changes in the API declarations.

The one area I face problems is, if a single cell is selected in the User Defined section, it acts like the "All Formulas" option.

 

[Richard Schollar]

Hi Sandeep

I've sent it across - it will be very interesting to hear if the APIs work under Win64. What I have may only work if Excel 2010 is installed...

 

[RoryA]

You're a gentleman and a Schollar.