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!

 

[RoryA]

Perhaps you are pasting in a forum that has HTML turned off (like this one) - you can check in the bottom left corner of the page. I pasted that into a new post in the Test forum here and as you can see it works.

 

[jaslake]

Does Html maker work on this Forum? Pasted this from an Excel 2007 worksheet...this is the output.

Excel 2007
	B
9	ram
Sheet2

 

[jaslake]

How do I do this...I don't see the Option to allow HTML...

How do I use this add-in?
Using the HTML Maker to post a "snapshot" of your worksheet on the message board is relatively simple.

1. Make sure you have enabled HTML in your board profile.
   1. Click the "profile" link--which is in the group of text links at the top-right of every page of the board.
   2. In the list of preferences, make sure the option for "Always allow HTML" is set to Yes.
   3. Click the "Submit" button to save any changes to your profile

 

[RoryA]

As I mentioned earlier in the thread, HTML is off in this part of the forum (you can check in the bottom right corner of the page)

 

[jaslake]

Hi RoryA

What does this mean

HTML is off in this part of the forum

If I wish to post a snapshot of Code Results in the Excel Questions Forum...how do I do that. I see other Members do so...am I able to or not? If not, why not...what are the Rules?

 

[jaslake]

Re: HTML maker - testers required!

Hi RoryA

Never mind...I sorted it out...

This is a bit misleading as I see no reference to "preferences" in the Profile Link. It appears HTML must be initiated by wrapping HTML Tags...much the same as Code Tags

How do I use this add-in?
Using the HTML Maker to post a "snapshot" of your worksheet on the message board is relatively simple.

1. Make sure you have enabled HTML in your board profile.
   
   1. Click the "profile" link--which is in the group of text links at the top-right of every page of the board.
   2. In the list of preferences, make sure the option for "Always allow HTML" is set to Yes.
   3. Click the "Submit" button to save any changes to your profile

 

[RoryA]

Re: HTML maker - testers required!

It does appear the instructions are out of date - I'll see about changing them.

 

[DocAElstein]

1 Message Box. 2 Bold Lines

One thing for me that might be nice and not sure what others think, is when you click the Generate html code, is to have a message box or something come up saying that it is copied to the clipboard. But I guess after using it and understanding what happens, this is not necessary.

Only reason I say this, is because I clicked the dang on button like 10 times thinking it was doing nothing and then thought to myself I will try to paste it and voila what do you know it was already copied to the clipboard.

.1 I think as well that would be good (but not essential) idea. I started using the VB HTML Maker (the one that copies code and keeps all color formats etc.) first which has such a box. So then when I started using the HTML I hit my head against a brick wall clicking thinking it had not worked when indeed it had already copied to the clipboard.
.2 By the way the HTML maker I find great and got it to work quite easily despite being a computer novice (Late Starter). One small point:- It does not seem to copy cell boarders (thick, bold lines and the such). So I could not for example use this method to highlight things or particular cells. But the background color is copied so that gives an alternative way to highlight cells.

 

[lmmay]

Is this HTML editor still available?

 

[hiker95]

lmmay,

Is this HTML editor still available?

Yes.


1. MrExcel HTMLMaker20101230

https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Installation instructions here:

http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html#post2545970