diff options
author | Jesse Luehrs <doy@tozt.net> | 2013-05-14 16:13:16 -0500 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2013-05-14 16:13:16 -0500 |
commit | becbe194e6c98ef2687886edc8b65f5921501231 (patch) | |
tree | 5f2a3e327ff08f2ef41b042c5b770c613c3b179e | |
parent | 3d6c0f526293626dfc99777938d48d4f58aa5068 (diff) | |
download | spreadsheet-template-becbe194e6c98ef2687886edc8b65f5921501231.tar.gz spreadsheet-template-becbe194e6c98ef2687886edc8b65f5921501231.zip |
add example files
-rw-r--r-- | examples/Test.json | 149 | ||||
-rw-r--r-- | examples/Test.xlsx | bin | 0 -> 35554 bytes |
2 files changed, 149 insertions, 0 deletions
diff --git a/examples/Test.json b/examples/Test.json new file mode 100644 index 0000000..86a2da7 --- /dev/null +++ b/examples/Test.json @@ -0,0 +1,149 @@ +{ + "worksheets" : [ + { + "cells" : [ + [ + { + "format" : { + "color" : "#FFFF00", + "bg_color" : "#9BBB59", + "size" : 12 + }, + "contents" : "Colored Cell", + "type" : "string" + }, + { + "contents" : "Wide Cell (25.00)", + "type" : "string" + }, + { + "format" : { + "border_color" : [ + "#000000", + "#000000", + "#000000", + "#000000" + ], + "text_wrap" : true, + "border" : [ + "thin", + "thin", + "thin", + "thin" + ] + }, + "contents" : "Bordered Cell w/ Text Wrap", + "type" : "string" + }, + { + "format" : { + "valign" : "vcenter" + }, + "contents" : "Middle Valigned", + "type" : "string" + }, + { + "format" : { + "align" : "right", + "text_wrap" : true + }, + "contents" : "Right Aligned and text wrapped", + "type" : "string" + } + ], + [ + {}, + {}, + {}, + {}, + {} + ], + [ + { + "contents" : 10, + "type" : "number" + }, + {}, + {}, + {}, + {} + ], + [ + { + "contents" : 20, + "type" : "number" + }, + {}, + {}, + { + "format" : { + "num_format" : "\"$\"#,##0.00" + }, + "contents" : 2.5, + "type" : "number" + }, + { + "format" : { + "color" : "#4BACC6", + "align" : "center", + "size" : 12 + }, + "contents" : "<< currency cell", + "type" : "string" + } + ], + [ + { + "contents" : 30, + "type" : "number" + }, + {}, + {}, + {}, + {} + ], + [ + { + "formula" : "SUM(A3:A5)", + "contents" : 60, + "type" : "number" + }, + { + "format" : { + "color" : "#F79646", + "align" : "right", + "bg_color" : "#EEECE1", + "size" : 12 + }, + "contents" : "<< formula cell", + "type" : "string" + }, + {}, + {}, + {} + ] + ], + "row_heights" : [ + 45, + 15, + 15, + 15, + 15, + 15 + ], + "name" : "Sheet1", + "selection" : [ + 3, + 4 + ], + "column_widths" : [ + 10.83203125, + 25.83203125, + 10, + 15, + 18.1640625 + ] + } + ], + "selection" : 0 +} diff --git a/examples/Test.xlsx b/examples/Test.xlsx Binary files differnew file mode 100644 index 0000000..7c1f8ad --- /dev/null +++ b/examples/Test.xlsx |