MrExcel HTML Maker Update

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
365, 2016
Platform
Windows
Anyway, in very limited testing now, it seems to be working. I have two identical right-click menus though, which is quite confusing. :)
Great - glad the root cause of that issue has been found (thank you, @Dave Patton)! I actually have an updated version on my end which adds some icons to the right-click menu, so it will differentiate between the two. I was holding off on releasing it until we were sure the issues between Forum Tools and this add-in were resolved, which it appears they have.

That being said, here is the updated version with added icons!

Dropbox - MrExcelHTMLMaker20170807.xlam
 

Some videos you may like

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,240
Office Version
365
Platform
Windows
I followed the instructions and posted a response in a thread. All looked good in the Go Advanced preview, but when I submitted the thread some of the fill colours disappeared and the layout of the formula boxes and tables lack colours. Am I doing something wrong?
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,708
Office Version
365, 2010
Platform
Windows, Mobile
but when I submitted the thread some of the fill colours disappeared
@DRSteele, I just done some further testing, were the cells where the colors disappeared from the cells normally filled or by conditional formatting?
I am getting the colors not showing when they are conditionally formatted.

I also have an issue if the cells aren't a solid color (can't remember if that was the same with the old version).

the layout of the formula boxes and tables lack colours.
I used to get this with the old version depending (I think) on the different options used but at the moment I can't replicate the behaviour.
 
Last edited:

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
365, 2016
Platform
Windows
@DRSteele, I just done some further testing, were the cells where the colors disappeared from the cells normally filled or by conditional formatting?
I am getting the colors not showing when they are conditionally formatted.

I also have an issue if the cells aren't a solid color (can't remember if that was the same with the old version).
After doing some testing, I can confirm that it is working as intended for cells which do not have conditional formatting, though I may be able to update it to include cell colors for conditional formatting - we'll see

As for the solid color issue, are you referring to if the cells have a pattern in them? If so, this is because the code converts the cell color into a hex format; it is not aware of cell patterns, and unfortunately likely won't ever really be aware of cell patterns due to no easy way to convert them to HTML (at least to my knowledge). It at least does grab the interior color of any patterned cell.

To the point of colors in formulas, I'm not able to replicate this issue either. Colors are appearing in the formula box as intended. See my test post here

Keep reporting issues as you find them! Thanks all!

Cheers :)
 

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,240
Office Version
365
Platform
Windows
I was not using any conditional formatting; just fill colours. Like this:

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5 " /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5 ;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="color: #E2EFDA;background-color: #000000;;">Green, Accent 6, Lighter 80%</td><td style="background-color: #E2EFDA;;">226, 239, 218</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="color: #FFF2CC;background-color: #000000;;">Gold, Accent 5, Lighter 80%</td><td style="background-color: #FFF2CC;;">255, 242, 204</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="color: #DDEBF7;background-color: #000000;;">Blue, Accent 4, Lighter 80%</td><td style="background-color: #DDEBF7;;">221, 235, 247</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="color: #DDEBF7;background-color: #000000;;">Orange, Accent 2, Lighter 80%</td><td style="background-color: #FCE4D6;;">252, 228, 214</td></tr></tbody></table><p style="width:4.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5 ;color: #161120">Sheet24</p><br /><br />
 

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
365, 2016
Platform
Windows
@DRSteele,

That HTML didn't parse correctly, but in looking at it, that doesn't appear to be code that my updated version generates. Specifically, I note that in the code you pasted, it has "background-color: #FFFFFF ;" in the initial < table> section. In my updated version, it no longer uses that hex value, but instead uses rgb(255,255,255). Are you using another addin which parses excel tables to html?
 

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,240
Office Version
365
Platform
Windows
I don't know what's going on there. I pasted the same thing on your Test page (from post34) and it worked just fine there.

Another problem is that I keep getting a security m,message about enabling macros.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,708
Office Version
365, 2010
Platform
Windows, Mobile
I don't know what's going on there. I pasted the same thing on your Test page (from post34) and it worked just fine there.
The About the board forum doesn't allow HTML code, the Test page does. It tells you in the bottom right of the page what is allowed.
 

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,240
Office Version
365
Platform
Windows
Ah, I see. Thank you.

But the problem persists. No fill colours.

Also, I have two instances of the "Generate HTML..." options in the right-click context sensitive menu. Three of the items are obviously for the old HTML maker which I've completely deleted; when I click on them I get error messages. The other three have icons beside them, and they seem to work for this new version (though clicking on any of the items to set a default does nothing.)

Can someone please help me sort this out?
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,708
Office Version
365, 2010
Platform
Windows, Mobile
MrKwoz, I am not getting the issues DRSteele is getting at the moment (including the set default is changing the default setting fine for me) but I am just wondering if the issues DRSteele has is partly still down to some Hex code being left, as in the code it appears that there is still some Hex code appearing for the background color (please see the red text below).

The below was taken using the all formulas option and produces the results here.

Btw, I am using the version from post number 18 not 31.


<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">bbbb</td><td style="text-align: right;background-color: #00B0F0;;">123</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">vvvv</td><td style="text-align: right;;">456</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">vvvv</td><td style="text-align: right;background-color: #FFFF00;;">789</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">xxxx</td><td style="text-align: right;;">1122</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="background-color: #C00000;;">zzzz</td><td style="text-align: right;;">1455</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">\\\\</td><td style="text-align: right;;">1788</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet4</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G1</th><td style="text-align:left">=A1</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H1</th><td style="text-align:left">=B1</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G2</th><td style="text-align:left">=A2</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H2</th><td style="text-align:left">=B2</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G3</th><td style="text-align:left">=A3</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H3</th><td style="text-align:left">=B3</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G4</th><td style="text-align:left">=A4</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H4</th><td style="text-align:left">=B4</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G5</th><td style="text-align:left">=A5</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H5</th><td style="text-align:left">=B5</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G6</th><td style="text-align:left">=A6</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H6</th><td style="text-align:left">=B6</td></tr></tbody></table></td></tr></table><br />
 

Watch MrExcel Video

Forum statistics

Threads
1,099,992
Messages
5,471,855
Members
406,789
Latest member
gkfcosta

This Week's Hot Topics

Top