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!

 

[InaCell]

Richard

Here is example HTML code as pasted.

[RANGE=cls:xl2bb-100][XR][XH=cs:4]Excel Workbook[/XH][/XR][XR][XH][/XH][XH]O[/XH][XH]P[/XH][XH]Q[/XH][/XR][XR][XH]37[/XH][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]38[/XH][XD][/XD][XD=h:c|fw:b]Full NAME[/XD][XD][/XD][/XR][XR][XH]39[/XH][XD][/XD][XD=h:c|fs:i]Event 1[/XD][XD][/XD][/XR][XR][XH]40[/XH][XD][/XD][XD=h:c|fs:i]Event 2[/XD][XD][/XD][/XR][XR][XH]41[/XH][XD][/XD][XD=h:c|fs:i]Event3[/XD][XD][/XD][/XR][XR][XH]42[/XH][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH=cs:4][RANGE][XR][XD]with dates (2)[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE][B]Excel 2003[/B]

 

[Richard Schollar]

I can't review the css of this site I'm afraid (don't have access to it other than by reviewing the css as downloaded to the browser). I remember suffering a similar problem with borders but that was using Firefox (rendered fine in IE though). I will take a look at what is being output by the code and see if there are any amendments I can make to fix said problem.

Thanks for bringing it to my attention!

 

[Fowmy]

Hi Richard,


I really like your addin so far, very convenient too.

But I have a problem, I am not sure this is because I use Excel 2010, when I right click on an Excel Table, the HTML Maker options are not available in the shortcut menu, I have to reach the ribbon|Add-ins.

Has this been already addressed or is it the HTML Maker not updated for 2010 ?

 

[Richard Schollar]

Are you trying to generate html output for cells which are part of a pivot table? The pivot table takes over the right-click "Cell" menu thus subverting the functionality in the html maker. If not, is there anything else unusual about the excel range eg is it part of an external data range or an Excel Table?

 

[Fowmy]

Its part of an excel table

 

[robgrant]

Richard: One of the other moderators on this board suggested I explore this link before posting for help with various excel problems. I'm not sure what this is all about, but when I try clicking any of the example links mentioned in this post, I'm told that I do not have permission to access the link. Can you please direct me to more information?

 

[bbbuffalo]

Will this also support sorting and filtering? If so I NEED this. How can I get it?

 

[Richard Schollar]

Hi

You can just PM me your email address and I will send it to you.

When you ask will it support sorting and filtering can I ask what you mean? It will ouput a filtered list and just output the visible cells if that's what you meant.

 

[robgrant]

Richard:

You already sent me your program. Apparently it doesn't play nice with the combination of Excel 2007 and Windows 7 64-bit.

 

[Richard Schollar]

Hi Rob

I think the correction i tried to apply last week failed because of an intermediate step using xl2010. I have corrected using xl2002 at work, but I do not have your email address at work so would you mind PMing me your email and I will send the new version on to you?