{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Conditional","Demo","Setup","README"],"not_rendered":{"charts":1,"images":8,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Conditional","index":0,"n_rows":29,"n_cols":28,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,2,27,3],[28,2,28,3]]}
[null,null,null,null,"Empty","Space",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Now","Yesterday","Tomorrow","DIV/0"]
[null,"xlAboveAverageCondition",12,"Above average condition",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,{"$f":"NOW()","v":"2018-12-17T13:26:04.360"},{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())-1)","v":"2018-12-16"},{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())+1)","v":"2018-12-18"},{"$f":"J2/G2","v":{"$error":"#DIV/0!"}}]
[null,"xlBlanksCondition",10,"Blanks condition",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,{"$f":"NOW()","v":"2018-12-17T13:26:04.360"},{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())-1)","v":"2018-12-16"},{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())+1)","v":"2018-12-18"},{"$error":"#DIV/0!"}]
[null,"xlBlanksCondition",10,"No Blanks condition",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlCellValue",1,"Cell value = 0",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlCellValue",2,"Cell value <$C$5",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlCellValue",2,"Value, Between 1 and 10",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlColorScale",3,"Color scale",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlDatabar",4,"Databar",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlErrorsCondition",16,"Errors condition",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlExpression",2,"Expression =E11=D11",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"XlIconSet",6,"Icon set",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlNoBlanksCondition",13,"No blanks condition",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlNoErrorsCondition",17,"No errors condition",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$f":"J14/G14","v":{"$error":"#DIV/0!"}}]
[null,"xlTextString",9,"Text string containing \"1\"",null," ",0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$f":"J15/G15","v":{"$error":"#DIV/0!"}}]
[null,"xlTimePeriod",11,"Today",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlTimePeriod",11,"Yesterday",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlTimePeriod",11,"Tomorrow",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-17T13:26:04.360","2018-12-16","2018-12-18",{"$error":"#DIV/0!"}]
[null,"xlTop10",5,"Top 10 values",null,null,0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"xlTop10",5,"Top 30%",null,null,0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"xlTop10",5,"Bottom 25%",null,null,0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"xlUniqueValues",8,"Unique values",null,null,0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"xlUniqueValues",8,"Duplicate values",null,null,0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Google",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-25]
[null,null,"Change this value to auto-publish",null,4]
[null,null,"Or click this button"]

{"sheet":"Demo","index":1,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,2,2,10],[10,2,10,10],[18,2,18,10],[11,2,13,2],[14,2,16,2],[4,2,8,2],[3,4,3,6],[3,8,3,10],[19,7,22,7],[19,8,22,10],[22,2,22,6],[19,2,19,3],[20,2,20,4],[21,2,21,5],[19,5,20,5],[19,6,21,6]]}
[1,2,3,4,5,6,7,8,9,10,11]
[2]
[3,null,"Borders"]
[4,null,null,null,"Foreground",null,null,null,"Background"]
[5,null,"The 12 standard Excel Borders","red",1,null,2,null,3,null,4]
[6]
[7,null,null,"green",5,null,6,null,7,null,8]
[8]
[9,null,null,"blue",9,null,10,null,11,null,12]
[10]
[11,null,"Aligning"]
[12,null,"Horizontal",null,"General",null,"Left",null,"Centre",null,"Right"]
[13,null,null,"text","100 pixels wide",null,"text",null,"text",null,"25 pixels high"]
[14,null,null,"number",1,null,2,null,3,null,4]
[15,null,"Vertical","Top","Arial",null,"Bold",null,"8 point",null,"32 pixels high"]
[16,null,null,"Middle","Courrier",null,"Italic",null,"12 point",null,"48 pixels high"]
[17,null,null,"Bottom","Times",null,"Underline",null,"14 point",null,"64 pixels high"]
[18]
[19,null,"Spanning"]
[20,null,"2 columns",null,null,"2 rows top","3 rows middle","4 rows bottom","3 columns 4 rows middle centre"]
[21,null,"3 columns"]
[22,null,"4 columns"]
[23,null,"5 columns"]
[24,null,"URL","Google"]

{"sheet":"Setup","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,1,16,2]]}
[]
[null,"Folder where the webpage will be published",null,"E.G. \\\\server\\folder or S:\\FolderX\\SubfolderY without a trailing \"\\\""]
[]
[null,"Leave blank to use the default:",{"$f":"WorkbookPath()","v":"E:\\Reference\\Programming\\ExcelHTMLWriter"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Generated files"]
[null,"Range","Path"]
[null,"_Conditional",{"$f":"HYPERLINK(\"HTMLWriter.Conditional.html\")","v":"HTMLWriter.Conditional.html"}]
[null,"_Demo",{"$f":"HYPERLINK(\"HTMLWriter.Demo.html\")","v":"HTMLWriter.Demo.html"}]

{"sheet":"README","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Purpose"]
[null,null,null,"This workbook allows you to publish data to one or more web pages, which others (subscribers) can view, with updates in real time."]
[]
[null,"Quick Start"]
[null,null,1,"Save this workbook, with a name that will be meaningful to your subscribers"]
[null,null,2,"Add a new worksheet"]
[null,null,4,"Add the data you would like to publish to the worksheet, formatted as you please. All Excel formatting is supported except conditional formats"]
[null,null,5,"Select a rectangle that encompasses all your data"]
[null,null,6,"Make this rectangle an Excel Named Range by typing the name in the range box. This name MUST begin with an underscore (\"_\"). For example, \"_Copper\":"]
[]
[null,null,7,"Change a value in the named area. This will create the HTML file. The named area will blink briefly to remind you what was published"]
[null,null,8,"Switch to the Setup Tab. Click the hyperlink under 'Path' to view the page. Notice how the name of the HTML file is generated from the workbook's name and the named range"]
[null,null,9,"If you want to publish the HTML file somewhere else, type the path to the folder in the yellow box. Repeat steps 2-7 to create additional webpages, if desired"]
[null,null,10,"Share the hyperlink with your subscribers"]