I have generated Excel Macros while editing an excel sheet to add colors. Then I save the sheet as HTML. You can compare VBA code and HTML to find the conversion table. For your convenience i am listing them done.
To easily find color in html you can use "computed styles" bookmarklet from https://www.squarefree.com/bookmarklets/webdevel.html PS: If I had some time I should done it in a better way. ie use a VBA macro/POI code to produce excel sheet with color, for colorIndex from 0 to max. Then save the sheet as html. Then put a javascript code to find its RBG value ====== macro ===== Option Explicit Sub Macro1() ' ' Macro1 Macro ' Macro recorded 2009-03-13 by b ' ' Range("A1").Select With Selection.Interior .ColorIndex = 1 .Pattern = xlSolid End With Range("A2").Select With Selection.Interior .ColorIndex = 9 .Pattern = xlSolid End With Range("A3").Select With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid End With Range("A4").Select With Selection.Interior .ColorIndex = 7 .Pattern = xlSolid End With Range("A5").Select With Selection.Interior .ColorIndex = 38 .Pattern = xlSolid End With Range("B1").Select With Selection.Interior .ColorIndex = 53 .Pattern = xlSolid End With Range("B2").Select With Selection.Interior .ColorIndex = 46 .Pattern = xlSolid End With Range("B3").Select With Selection.Interior .ColorIndex = 45 .Pattern = xlSolid End With Range("B4").Select With Selection.Interior .ColorIndex = 44 .Pattern = xlSolid End With Range("B5").Select With Selection.Interior .ColorIndex = 40 .Pattern = xlSolid End With Range("C1").Select With Selection.Interior .ColorIndex = 52 .Pattern = xlSolid End With Range("C2").Select With Selection.Interior .ColorIndex = 12 .Pattern = xlSolid End With Range("C3").Select With Selection.Interior .ColorIndex = 43 .Pattern = xlSolid End With Range("C4").Select With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With Range("C5").Select With Selection.Interior .ColorIndex = 36 .Pattern = xlSolid End With End Sub Sub Macro2() ' ' Macro2 Macro ' Macro recorded 2009-03-13 by b ' ' Range("D1").Select Selection.Interior.ColorIndex = 51 Range("D2").Select With Selection.Interior .ColorIndex = 10 .Pattern = xlSolid End With Range("D3").Select With Selection.Interior .ColorIndex = 50 .Pattern = xlSolid End With Range("D4").Select With Selection.Interior .ColorIndex = 4 .Pattern = xlSolid End With Range("D5").Select With Selection.Interior .ColorIndex = 35 .Pattern = xlSolid End With Range("E1").Select With Selection.Interior .ColorIndex = 49 .Pattern = xlSolid End With Range("E2").Select With Selection.Interior .ColorIndex = 14 .Pattern = xlSolid End With Range("E3").Select With Selection.Interior .ColorIndex = 42 .Pattern = xlSolid End With Range("E4").Select With Selection.Interior .ColorIndex = 8 .Pattern = xlSolid End With Range("E5").Select With Selection.Interior .ColorIndex = 34 .Pattern = xlSolid End With Range("F1").Select With Selection.Interior .ColorIndex = 11 .Pattern = xlSolid End With Range("F2").Select With Selection.Interior .ColorIndex = 5 .Pattern = xlSolid End With Range("F3").Select With Selection.Interior .ColorIndex = 41 .Pattern = xlSolid End With Range("F4").Select With Selection.Interior .ColorIndex = 33 .Pattern = xlSolid End With Range("F5").Select With Selection.Interior .ColorIndex = 37 .Pattern = xlSolid End With Range("G1").Select With Selection.Interior .ColorIndex = 55 .Pattern = xlSolid End With Range("G2").Select With Selection.Interior .ColorIndex = 47 .Pattern = xlSolid End With Range("G3").Select With Selection.Interior .ColorIndex = 13 .Pattern = xlSolid End With Range("G4").Select With Selection.Interior .ColorIndex = 54 .Pattern = xlSolid End With Range("G5").Select With Selection.Interior .ColorIndex = 39 .Pattern = xlSolid End With Range("H1").Select With Selection.Interior .ColorIndex = 56 .Pattern = xlSolid End With Range("H2").Select With Selection.Interior .ColorIndex = 16 .Pattern = xlSolid End With Range("H3").Select With Selection.Interior .ColorIndex = 48 .Pattern = xlSolid End With Range("H4").Select With Selection.Interior .ColorIndex = 15 .Pattern = xlSolid End With Range("H5").Select With Selection.Interior .ColorIndex = 2 .Pattern = xlSolid End With End Sub ====== html ===== <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=windows-1252"> <meta name=ProgId content=Excel.Sheet> <meta name=Generator content="Microsoft Excel 9"> <link rel=File-List href="./ColorPage_files/filelist.xml"> <style id="Book1_3297_Styles"> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} .xl153297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;} .xl223297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:black; mso-pattern:auto none; white-space:nowrap;} .xl233297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:maroon; mso-pattern:auto none; white-space:nowrap;} .xl243297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:red; mso-pattern:auto none; white-space:nowrap;} .xl253297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:fuchsia; mso-pattern:auto none; white-space:nowrap;} .xl263297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#FF99CC; mso-pattern:auto none; white-space:nowrap;} .xl273297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#993300; mso-pattern:auto none; white-space:nowrap;} .xl283297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#FF6600; mso-pattern:auto none; white-space:nowrap;} .xl293297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#FF9900; mso-pattern:auto none; white-space:nowrap;} .xl303297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#FFCC00; mso-pattern:auto none; white-space:nowrap;} .xl313297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#FFCC99; mso-pattern:auto none; white-space:nowrap;} .xl323297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#333300; mso-pattern:auto none; white-space:nowrap;} .xl333297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:olive; mso-pattern:auto none; white-space:nowrap;} .xl343297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#99CC00; mso-pattern:auto none; white-space:nowrap;} .xl353297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:yellow; mso-pattern:auto none; white-space:nowrap;} .xl363297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#FFFF99; mso-pattern:auto none; white-space:nowrap;} .xl373297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#003300; mso-pattern:auto none; white-space:nowrap;} .xl383297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:green; mso-pattern:auto none; white-space:nowrap;} .xl393297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#339966; mso-pattern:auto none; white-space:nowrap;} .xl403297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:lime; mso-pattern:auto none; white-space:nowrap;} .xl413297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#CCFFCC; mso-pattern:auto none; white-space:nowrap;} .xl423297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#003366; mso-pattern:auto none; white-space:nowrap;} .xl433297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:teal; mso-pattern:auto none; white-space:nowrap;} .xl443297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#33CCCC; mso-pattern:auto none; white-space:nowrap;} .xl453297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:aqua; mso-pattern:auto none; white-space:nowrap;} .xl463297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#CCFFFF; mso-pattern:auto none; white-space:nowrap;} .xl473297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:navy; mso-pattern:auto none; white-space:nowrap;} .xl483297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:blue; mso-pattern:auto none; white-space:nowrap;} .xl493297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#3366FF; mso-pattern:auto none; white-space:nowrap;} .xl503297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#00CCFF; mso-pattern:auto none; white-space:nowrap;} .xl513297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#99CCFF; mso-pattern:auto none; white-space:nowrap;} .xl523297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#333399; mso-pattern:auto none; white-space:nowrap;} .xl533297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#666699; mso-pattern:auto none; white-space:nowrap;} .xl543297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:purple; mso-pattern:auto none; white-space:nowrap;} .xl553297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#993366; mso-pattern:auto none; white-space:nowrap;} .xl563297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#CC99FF; mso-pattern:auto none; white-space:nowrap;} .xl573297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#333333; mso-pattern:auto none; white-space:nowrap;} .xl583297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:gray; mso-pattern:auto none; white-space:nowrap;} .xl593297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#969696; mso-pattern:auto none; white-space:nowrap;} .xl603297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:silver; mso-pattern:auto none; white-space:nowrap;} .xl613297 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:white; mso-pattern:auto none; white-space:nowrap;} --> </style> </head> <body> <!--[if !excel]> <![endif]--> <!--The following information was generated by Microsoft Excel's Publish as Web Page wizard.--> <!--If the same item is republished from Excel, all information between the DIV tags will be replaced.--> <!-----------------------------> <!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD --> <!-----------------------------> <div id="Book1_3297" align=center x:publishsource="Excel"> <table x:str border=0 cellpadding=0 cellspacing=0 width=512 style='border-collapse: collapse;table-layout:fixed;width:384pt'> <col width=64 span=8 style='width:48pt'> <tr height=17 style='height:12.75pt'> <td height=17 class=xl223297 width=64 style='height:12.75pt;width:48pt'> </td> <td class=xl273297 width=64 style='width:48pt'> </td> <td class=xl323297 width=64 style='width:48pt'> </td> <td class=xl373297 width=64 style='width:48pt'> </td> <td class=xl423297 width=64 style='width:48pt'> </td> <td class=xl473297 width=64 style='width:48pt'> </td> <td class=xl523297 width=64 style='width:48pt'> </td> <td class=xl573297 width=64 style='width:48pt'> </td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl233297 style='height:12.75pt'> </td> <td class=xl283297> </td> <td class=xl333297> </td> <td class=xl383297> </td> <td class=xl433297> </td> <td class=xl483297> </td> <td class=xl533297> </td> <td class=xl583297> </td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl243297 style='height:12.75pt'> </td> <td class=xl293297> </td> <td class=xl343297> </td> <td class=xl393297> </td> <td class=xl443297> </td> <td class=xl493297> </td> <td class=xl543297> </td> <td class=xl593297> </td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl253297 style='height:12.75pt'> </td> <td class=xl303297> </td> <td class=xl353297> </td> <td class=xl403297> </td> <td class=xl453297> </td> <td class=xl503297> </td> <td class=xl553297> </td> <td class=xl603297> </td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl263297 style='height:12.75pt'> </td> <td class=xl313297> </td> <td class=xl363297> </td> <td class=xl413297> </td> <td class=xl463297> </td> <td class=xl513297> </td> <td class=xl563297> </td> <td class=xl613297> </td> </tr> <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> </tr> <![endif]> </table> </div> <!-----------------------------> <!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD--> <!-----------------------------> </body> </html> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
