{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","1~`!@#$%^&()_-+={}|;\"'<,>.£¹÷¦°","chart-not-imported","E09904.2","gradientFill"],"not_rendered":{"charts":2,"external_links":1,"defined_names":5,"comments":2},"unopened":[{"sheet":"chart-not-imported","index":2,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":204,"n_cols":4,"rows_kept":204,"merged":[[41,0,42,0],[182,0,182,1]]}
[{"$f":"1/0","v":{"$error":"#DIV/0!"}},"Error"]
[true,"Boolean (true)"]
[false,"Boolean (false)"]
[1337,"integer"]
[{"v":1338,"d":"1338.00"},"integer with higher-precision number formatting"]
["2015-02-11","default date format"]
["2015-02-12","Different built-in date format"]
["2015-02-13","custom date format"]
["character","character"]
["comment","comment with formatting"]
[{"v":100,"d":"£100.00"},"Currency format"]
[{"v":0.2,"d":"20%"},"Percent format"]
[{"v":1.1,"d":"1.10E+00"},"Scientific format"]
[{"$f":"1=1","v":true},"formula evaluating to logical"]
[{"$f":"A4+1","v":1338},"formula evaluating to a number"]
[{"$f":"DATE(2017,1,18)","v":"2017-01-18"},"formula evaluating to date"]
[{"$f":"\"Hello, World!\"","v":"Hello, World!"},"formula evaluating to a string"]
[1,"some formulas that are stored in groups"]
[{"$f":"$A$18+1","v":2},{"$f":"A18+2","v":3}]
[{"$f":"$A$18+1","v":2},{"$f":"A19+2","v":4}]
[2,4]
[{"$f":"SUM(A19:A21*B19:B21)","v":22},"single-cell array formula"]
[{"$f":"A19:A20*B19:B20","v":6},"multi-cell array formula"]
[8,"multi-cell array formula"]
[{"$f":"[1]Sheet1!$A$1","v":"normal"},"formula that refers to another file"]
["normal","normal' style but 'normal' has been modified from Excel's default to use Arial font"]
["italic","'normal' style but with local italics applied to this cell."]
["normal","'normal' style but with local bold applied to this cell."]
["normal","'normal' style but with local underline applied to this cell."]
["normal","'normal' style but with local double underline applied to this cell."]
["bad","'bad' style applied to this cell"]
["badboldrightupindent","'bad' style modified with bold font, right-and-up-aligned with an indent."]
["1900-03-01","custom style with custom date format"]
["auto-font","Automatic font colour"]
["standardred","'indexed' or standard red text"]
["themeblue","Blue text from the theme"]
["bluepattern","Pattern but no background, blue from theme"]
["stylealign","Custom style 'stylealign' where the style is aligned to the centre."]
["in-cellbolditalicunderlineunderlinedoublesingleaccountingdoubleaccountingstrikethroughsubscriptsuperscriptredthemetintsizearialUTF8Stéphane\nmultilinecustomheight","in-cellbolditalicunderlineunderlinedoublesingleaccountingdoubleaccountingstrikethroughsuperscriptsubscriptredthemeaccentsizearial\nmultilinecustomheight"]
["yellowfillunderline12arialstrikethroughsuperscript","More fancy inline-string formatting"]
["bottomborderslant","Slanted text"]
["merged","Cell merged into cell below"]
[]
["unprotected","A cell that is not 'protected'"]
["unhidden","A cell that is not 'hidden'"]
["locked","A cell that is 'locked'"]
["themebackground1","Text is formatted the colour 'Background1' from the theme, i.e. white."]
["in-cell-bold-not-bold","Bold applied in inline string (not at cell level)"]
["in-cell-bold-not-bold","Bold applied at cell level"]
["diagonal-up","Diagonal-up border"]
["diagonal-down","Diagonal-down border"]
["thin","various combinations of borders in adacent cells"]
["thin","no border in adjacent cell"]
["thin","medium border"]
["thin","dashed border"]
["thin","dashDot"]
["text1","text1 theme colour"]
["background2","background2 theme colour"]
["text2","text2 theme colour"]
["accent1","accent1 theme colour"]
["accent2","accent2 theme colour"]
["accent3","accent3 theme colour"]
["accent4","accent4 theme colour"]
["accent5","accent5 theme colour"]
["accent6","accent6 theme colour"]
["hyperlink","hyperlink style"]
["folhyperlink","followed hyperlink style"]
["text1-lighter50","text1-lighter50 theme colour"]
[null,"Fill Highlight automatic"]
[null,"Fill Solid"]
[null,"Fill 75% Gray"]
[null,"Fill 50% Gray"]
[null,"Fill 25% Gray"]
[null,"Fill 12.5% Gray"]
[null,"Fill 6.25% Gray"]
[null,"Fill Horizontal Stripe"]
[null,"Fill Vertical Stripe"]
[null,"Fill Reverse Diagonal Stripe"]
[null,"Fill Diagonal Stripe"]
[null,"Fill Diagonal Crosshatch"]
[null,"Fill Thick Diagonal Crosshatch"]
[null,"Fill Thin Horizontal Stripe"]
[null,"Fill Thin Vertical Stripe"]
[null,"Fill Thin Reverse Diagonal Stripe"]
[null,"Fill Thin Diagonal Stripe"]
[null,"Fill Thin Horizontal Crosshatch"]
[null,"Fill Thin Diagonal Crosshatch"]
[null,"Fill Horizontal Stripe"]
[null,"Fill vertical"]
[null,"Fill diagonal up"]
[null,"Fill diagonal down"]
[null,"Fill from corner"]
[null,"Fill from center"]
["¯\\_(ツ)_/¯","unicode shrug"]
[{"v":-1,"d":"-$1.00"},"custom number format with 'd' in [Red] to confuse date detection heuristic"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},"ref error by deleting the reference"]
[{"$f":"C1&\"C1\"\"\"","v":"C1\""},"Test formula parser with =C1&\"C1\"\"\""]
[{"$f":"C2&\"C1\"\"\"","v":"C1\""}]
["C1\""]
[{"$f":"LOG10","v":0},"Test formula parser with =LOG10"]
[{"$f":"LOG11","v":0}]
[0]
[{"$f":"LOG10(1)","v":0},"Test formula parser with =LOG10(1)"]
[{"$f":"LOG10(1)","v":0}]
[0]
[0,"Data validation, whole number, between, allow blank, show message title body, show error title body"]
[0.1,"Data validation, decimal, not between, disallow blank, don't show message error"]
["Data validation, list, in-cell dropdown, warning symbol","Data validation, list, in-cell dropdown, warning symbol"]
["Data validation, list, in-cell dropdown, warning symbol","Data validation, list, no in-cell dropdown, information symbol"]
["2017-01-01","Data validation, datetime, between"]
["08:30:00","Data validation, time, between"]
["some text","Data validation, text length, between"]
[10,"Data validation, custom"]
[-1,"Data validation, not between"]
[0,"Data validation, equal to, non-contiguous reference (A115,A121:A122)"]
[null,"Data validation, not equal to"]
[null,"Data validation, greater than"]
[null,"Data validation, less than"]
[null,"Data validation, greater than or equal to"]
[null,"Data validation, less than or equal to"]
[null,"Data validation, equal to, non-contiguous reference (A115,A121:A122)"]
[0,"Data validation, equal to, non-contiguous reference (A115,A121:A122)"]
[{"$f":"A1A","v":{"$error":"#NAME?"}},"Test formula parser with =A1A"]
[{"$f":"A1A","v":{"$error":"#NAME?"}}]
[{"$error":"#NAME?"}]
[{"$f":"E09904.2!A1","v":0},"Test formula parser with =E09904.2!A1"]
[{"$f":"E09904.2!A2","v":0}]
[{"$f":"E09904.2!A3","v":0}]
[0,"Named range"]
[{"$f":"named_global_formula","v":-1},"Named global formula"]
[{"$f":"named_local_formula","v":1},"Named local formula"]
["in-cell format with cell-level defaults","in-cell format with cell-level defaults"]
["underline single accounting","underline single accounting"]
["underline double accounting","underline double accounting"]
["strikethrough","strikethrough"]
["superscript","superscript"]
["subscript","subscript"]
["tint","tint"]
[null,"Two-colour fill"]
[null,"Fill Horizontal Variant 2"]
[null,"Fill Horizontal Variant 3"]
[null,"Fill vertical variant 2"]
[null,"Fill vertical variant 3"]
[null,"Fill diagonal up variant 2"]
[null,"Fill diagonal up variant 3"]
[null,"Fill diagonal down variant 2"]
[null,"Fill diagonal down variant 3"]
[null,"Fill from corner variant 2"]
[null,"Fill from corner variant 3"]
[null,"Fill from corner variant 4"]
["hair","hair"]
["dotted","dotted"]
["dashDotDot","dashDotDot"]
["dashDot","dashDot"]
["dashed","dashed"]
["thin","thin"]
["mediumDashDotDot","mediumDashDotDot"]
["slantDashDot","slantDashDot"]
["mediumDashDot","mediumDashDot"]
["mediumDashed","mediumDashed"]
["medium","medium"]
["thick","thick"]
["double","double"]
["diagonalUp","diagonalUp"]
["diagonalDown","diagonalDown"]
["both diagonals (will always be the same style)","both diagonals (will always be the same style)"]
["horizontal align general","horizontal align general"]
["horizontal align left","horizontal align left"]
["horizontal align center","horizontal align center"]
["horizontal align right","horizontal align right"]
["horizontal align fill","horizontal align fill"]
["horizontal align justify","horizontal align justify"]
["horizontal align center across selection",null,null,"horizontal align center across selection"]
["horizontal align distributed","horizontal align distributed"]
["vertical align top","vertical align top"]
["vertical align center","vertical align center"]
["vertical align bottom","vertical align bottom"]
["vertical align justify","vertical align justify"]
["vertical align distributed","vertical align distributed"]
["indent","indent"]
["wrap text","wrap text"]
["shrink to fit","shrink to fit"]
["merge cells"]
["reading order context","reading order context"]
["reading order left to right","reading order left to right"]
["reading order right to left","reading order right to left"]
["text rotation","text rotation"]
["hidden","a cell that is 'hidden'"]
["background1","background1 theme colour"]
["text1 lighter 50%","text1 lighter 50%"]
["text1 lighter 35%","text1 lighter 35%"]
["text1 lighter 25%","text1 lighter 25%"]
["text1 lighter 15%","text1 lighter 15%"]
["text1 lighter 5%","text1 lighter 5%"]
["standard dark red","standard dark red"]
["standard red","standared red"]
["standard orange","standard orange"]
["standard yellow","standared yellow"]
["standard light green","standard light green"]
["standard green","standard green"]
["standard light blue","standard light blue"]
["standard blue","standard blue"]
["standard dark blue","standard dark blue"]
["standard purple","standard purple"]

{"sheet":"1~`!@#$%^&()_-+={}|;\"'<,>.£¹÷¦°","index":1,"n_rows":6,"n_cols":2,"rows_kept":6}
[]
[null,"empty first row and col"]
[]
[]
[]
[null,"This worksheet has a nasty name but can be imported nevertheless"]

{"sheet":"E09904.2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"gradientFill","index":4,"n_rows":25,"n_cols":10,"rows_kept":25}
[null,null,"stop1 positon","stop2 position","type","degree","left","right","top","bottom"]
[]
[null,"Fill Horizontal",0,1,null,90]
[null,"Fill Horizontal Variant 2",0,1,null,270]
[null,"Fill Horizontal Variant 3",0,0.5,null,90]
[]
[null,"Fill vertical",0,1]
[null,"Fill vertical variant 2",0,1,null,180]
[null,"Fill vertical variant 3",0,0.5]
[]
[null,"Fill diagonal up",0,1,null,45]
[null,"Fill diagonal up variant 2",0,1,null,225]
[null,"Fill diagonal up variant 3",0,0.5,null,45]
[]
[null,"Fill diagonal down",0,1,null,135]
[null,"Fill diagonal down variant 2",0,1,null,315]
[null,"Fill diagonal down variant 3",0,0.5,null,135]
[]
[null,"Fill from corner",0,1,"path"]
[null,"Fill from corner variant 2",0,1,"path",null,1,1]
[null,"Fill from corner variant 3",0,1,"path",{"$nulls":3},1,1]
[null,"Fill from corner variant 4",0,1,"path",null,1,1,1,1]
[]
[null,"Fill from center",0,1,"path",null,0.5,0.5,0.5,0.5]
[null,"Two-colour fill",0,1,"path",null,0.5,0.5,0.5,0.5]