diff options
| author | Randy Morgan <[email protected]> | 2011-11-21 10:22:29 +0900 |
|---|---|---|
| committer | Randy Morgan <[email protected]> | 2011-11-21 10:22:29 +0900 |
| commit | bfdd6993737f4a7294da00e25d03651cf03add5d (patch) | |
| tree | 3d72dc7f0753bbca517df6cfdf5be6fa42bf7d2d | |
| parent | e70d5d029f486ad4b66e9c25a68de05b077efccc (diff) | |
| download | caxlsx-bfdd6993737f4a7294da00e25d03651cf03add5d.tar.gz caxlsx-bfdd6993737f4a7294da00e25d03651cf03add5d.zip | |
updating docs.
60 files changed, 173 insertions, 99 deletions
diff --git a/.yardoc/checksums b/.yardoc/checksums index 784b549d..47b5312e 100644 --- a/.yardoc/checksums +++ b/.yardoc/checksums @@ -1,49 +1,49 @@ -lib/axlsx/util/constants.rb 3441c292d88c3c1c7ab4c5f15d3ac2a434b3b87b -lib/axlsx/drawing/marker.rb 3507738522c02a3733a01f115d9ef22fae4ea542 -lib/axlsx/stylesheet/color.rb 4927aaebe27dda42d78bb7baf9a44edc1753c77f -lib/axlsx/stylesheet/border_pr.rb 09dcb61ec7b0cf49f2da4c4f8ccba8f7e0df7b07 -lib/axlsx/drawing/pie_3D_chart.rb 9a93a6fcf43122ed41f522f50b9d0d0340be1688 -lib/axlsx/stylesheet/table_style.rb b592135b8b02969a29bd24c28a13282f6af76f30 lib/axlsx/stylesheet/table_styles.rb 04b778652c29d612f63e93080d06c3936e48d765 -lib/axlsx/package.rb eea7499e09e0936eeb8e08d10823f05990722023 -lib/axlsx/drawing/series.rb 76a9b00ab44c4b9553a017aa25f7f504c2b41484 -lib/axlsx/stylesheet/cell_style.rb 46c6ff183bce5c6b1ab6228823257d638007b03c +lib/axlsx/stylesheet/table_style.rb b592135b8b02969a29bd24c28a13282f6af76f30 +lib/axlsx/drawing/pie_3D_chart.rb 9a93a6fcf43122ed41f522f50b9d0d0340be1688 +lib/axlsx/stylesheet/border_pr.rb 09dcb61ec7b0cf49f2da4c4f8ccba8f7e0df7b07 +lib/axlsx/stylesheet/color.rb 4927aaebe27dda42d78bb7baf9a44edc1753c77f +lib/axlsx/drawing/marker.rb 3507738522c02a3733a01f115d9ef22fae4ea542 +lib/axlsx/util/constants.rb 3441c292d88c3c1c7ab4c5f15d3ac2a434b3b87b lib/axlsx/stylesheet/cell_protection.rb ce494f9add6de0a51407ddd9122fffe95759a48a -lib/axlsx/drawing/axis.rb 5316065040d08d4f15e5da2751a2ee90185dad61 -lib/axlsx/drawing/title.rb 7069b1c32bd209addd9808be005dae176819b8e0 -lib/axlsx/content_type/default.rb 8ec0d9d1e6bf261735739823acd460c271e3f5ed +lib/axlsx/stylesheet/cell_style.rb 46c6ff183bce5c6b1ab6228823257d638007b03c +lib/axlsx/drawing/series.rb 76a9b00ab44c4b9553a017aa25f7f504c2b41484 +lib/axlsx/package.rb eea7499e09e0936eeb8e08d10823f05990722023 lib/axlsx/stylesheet/cell_alignment.rb f67f6a0bc16bf13669ed7b18714e4de23825ed94 -lib/axlsx.rb 7d8c589a0bdc16acf8774ae1b77d5177b030a80c -lib/axlsx/rels/relationships.rb 9c741e180796259bb378a789fd484fa1d8f04425 -lib/axlsx/stylesheet/num_fmt.rb dc830c6540465afa824881efa2f1ce4070957c47 -lib/axlsx/content_type/content_type.rb 6c576e1618f99f7163fffa6b6e89e964653dcb5f +lib/axlsx/content_type/default.rb 8ec0d9d1e6bf261735739823acd460c271e3f5ed +lib/axlsx/drawing/title.rb 7069b1c32bd209addd9808be005dae176819b8e0 +lib/axlsx/drawing/axis.rb 5316065040d08d4f15e5da2751a2ee90185dad61 lib/axlsx/stylesheet/table_style_element.rb bee66d743e3113fb14adc7ebdecbeb606bfb49fc -lib/axlsx/drawing/bar_series.rb a8a1648a1bec8d3d4bc07786f2c55c0c0d658e15 -lib/axlsx/drawing/pie_series.rb 76c67a0227e913fb14eb70d756323974718e204a -lib/axlsx/content_type/override.rb 72245683bca868f181d709a515f9152485653229 +lib/axlsx/content_type/content_type.rb 6c576e1618f99f7163fffa6b6e89e964653dcb5f +lib/axlsx/stylesheet/num_fmt.rb dc830c6540465afa824881efa2f1ce4070957c47 +lib/axlsx/rels/relationships.rb 9c741e180796259bb378a789fd484fa1d8f04425 +lib/axlsx.rb 7d8c589a0bdc16acf8774ae1b77d5177b030a80c lib/axlsx/drawing/graphic_frame.rb 5ff7476b8fa3e2101fde200d1c65844084fb42f7 -lib/axlsx/stylesheet/xf.rb e3d6e2e4c3b0b33c91de4c3db16c73aca3db4473 -lib/axlsx/drawing/view_3D.rb aca4d987f0c2cd5d0a653c96ac2bc1df9392583a -lib/axlsx/stylesheet/fill.rb 35966285f5d759d63451005ceae3a5ae5ba2ceca -lib/axlsx/workbook/workbook.rb ec98ed826e6c3ca9c6e3303dbfbe00c0b5fb9aee -lib/axlsx/util/simple_typed_list.rb 2ae647d5305acd9181c3303d5638db46d190b786 -lib/axlsx/workbook/worksheet/row.rb f866a98341ce4e604908e42d00f2af09e58c75d2 +lib/axlsx/content_type/override.rb 72245683bca868f181d709a515f9152485653229 +lib/axlsx/drawing/pie_series.rb 76c67a0227e913fb14eb70d756323974718e204a +lib/axlsx/drawing/bar_series.rb a8a1648a1bec8d3d4bc07786f2c55c0c0d658e15 lib/axlsx/stylesheet/gradient_fill.rb 5fd260ec2b94ab75a970159035528548a9d21cd6 -lib/axlsx/doc_props/app.rb 52f01e985a33253987177798d4e79ed208649b30 -lib/axlsx/util/validators.rb 2320eee50ceee29cc0dbab95721a6c633dc660e1 -lib/axlsx/stylesheet/font.rb 8b002d5fcba2fb0979858517f5254aadf96c7e58 -lib/axlsx/drawing/cat_axis.rb bf9eae6efae39b003a98b44cc437e6e9b4c51985 -lib/axlsx/drawing/val_axis.rb 710e67120c1262ef4cbbb56b632a568731df3215 -lib/axlsx/stylesheet/styles.rb 3679a8fe86270bdef96f02bcf76f2eac27b1c2ef +lib/axlsx/workbook/worksheet/row.rb f866a98341ce4e604908e42d00f2af09e58c75d2 +lib/axlsx/util/simple_typed_list.rb 2ae647d5305acd9181c3303d5638db46d190b786 +lib/axlsx/workbook/workbook.rb ec98ed826e6c3ca9c6e3303dbfbe00c0b5fb9aee +lib/axlsx/stylesheet/fill.rb 35966285f5d759d63451005ceae3a5ae5ba2ceca +lib/axlsx/drawing/view_3D.rb aca4d987f0c2cd5d0a653c96ac2bc1df9392583a +lib/axlsx/stylesheet/xf.rb e3d6e2e4c3b0b33c91de4c3db16c73aca3db4473 lib/axlsx/drawing/two_cell_anchor.rb cc320f580ff9c639daa670f7ba1a1648bf26c157 -lib/axlsx/drawing/chart.rb 41dce85f81b7f5d5df3493597c1560d0f0c50c62 -lib/axlsx/drawing/drawing.rb cdb97d463eb539baf96a105493aca17d7ddf57e5 -lib/axlsx/rels/relationship.rb a160c998acf7fd0ab8195ea6162b1eb2eab4963c -lib/axlsx/stylesheet/border.rb 517bfcb43380919ce7abef494d5d3e50911b7c19 -lib/axlsx/workbook/worksheet/cell.rb 939623ffc2065e9ec26bc56d9e289d9137fe57d3 +lib/axlsx/stylesheet/styles.rb 3679a8fe86270bdef96f02bcf76f2eac27b1c2ef +lib/axlsx/drawing/val_axis.rb 710e67120c1262ef4cbbb56b632a568731df3215 +lib/axlsx/drawing/cat_axis.rb bf9eae6efae39b003a98b44cc437e6e9b4c51985 +lib/axlsx/stylesheet/font.rb 8b002d5fcba2fb0979858517f5254aadf96c7e58 +lib/axlsx/util/validators.rb 2320eee50ceee29cc0dbab95721a6c633dc660e1 +lib/axlsx/doc_props/app.rb 52f01e985a33253987177798d4e79ed208649b30 lib/axlsx/workbook/worksheet/worksheet.rb 1af6b7e4a54b41e770709c26ad7100ed516448b8 -lib/axlsx/doc_props/core.rb 90ebc8086f6606af02275c27068c359a5647faf0 +lib/axlsx/workbook/worksheet/cell.rb 939623ffc2065e9ec26bc56d9e289d9137fe57d3 +lib/axlsx/stylesheet/border.rb 517bfcb43380919ce7abef494d5d3e50911b7c19 +lib/axlsx/rels/relationship.rb a160c998acf7fd0ab8195ea6162b1eb2eab4963c +lib/axlsx/drawing/drawing.rb cdb97d463eb539baf96a105493aca17d7ddf57e5 +lib/axlsx/drawing/chart.rb 41dce85f81b7f5d5df3493597c1560d0f0c50c62 lib/axlsx/stylesheet/gradient_stop.rb de34e289aeccb4abd9a3b7e60e816a0b12ffacff -lib/axlsx/drawing/scaling.rb d3b59eed1897dc2b07bb41b2245c6e4b3e274d7e +lib/axlsx/doc_props/core.rb 90ebc8086f6606af02275c27068c359a5647faf0 lib/axlsx/drawing/bar_3D_chart.rb 68a516574b727bf9fc7e030d13060eaf7e36221e +lib/axlsx/drawing/scaling.rb d3b59eed1897dc2b07bb41b2245c6e4b3e274d7e lib/axlsx/stylesheet/pattern_fill.rb 817cf55beb3db160b2b56edb6c94de1ecf1ecee7 diff --git a/.yardoc/objects/root.dat b/.yardoc/objects/root.dat Binary files differindex 5746b14f..0ed117e7 100644 --- a/.yardoc/objects/root.dat +++ b/.yardoc/objects/root.dat @@ -109,6 +109,7 @@ Cell Specifc Styles end Number and Date formatting + p = Axlsx::Package.new do |package| date = package.workbook.styles.add_style :format_code=>"yyyy-mm-dd", :border => Axlsx::STYLE_THIN_BORDER padded = package.workbook.styles.add_style :format_code=>"00#", :border => Axlsx::STYLE_THIN_BORDER @@ -139,6 +140,7 @@ Changelog - Updated documentation - altered package to accept a filename string for serialization instead of a File object. - Updated specs to conform + Copyright --------- diff --git a/axlsx-1.0.3.gem b/axlsx-1.0.3.gem Binary files differindex 47a93154..c66a4600 100644 --- a/axlsx-1.0.3.gem +++ b/axlsx-1.0.3.gem diff --git a/axlsx-1.0.4.gem b/axlsx-1.0.4.gem Binary files differnew file mode 100644 index 00000000..8e7ad45e --- /dev/null +++ b/axlsx-1.0.4.gem diff --git a/doc/Axlsx.html b/doc/Axlsx.html index db3bf15b..78ff81c7 100644 --- a/doc/Axlsx.html +++ b/doc/Axlsx.html @@ -2434,7 +2434,7 @@ The value validated </div> <div id="footer"> - Generated on Mon Nov 21 08:39:49 2011 by + Generated on Mon Nov 21 10:10:37 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/App.html b/doc/Axlsx/App.html index 1cf634dd..5ccf2477 100644 --- a/doc/Axlsx/App.html +++ b/doc/Axlsx/App.html @@ -2631,7 +2631,7 @@ The document as a string </div> <div id="footer"> - Generated on Mon Nov 21 08:39:54 2011 by + Generated on Mon Nov 21 10:10:44 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Axis.html b/doc/Axlsx/Axis.html index 9dece081..18e077ff 100644 --- a/doc/Axlsx/Axis.html +++ b/doc/Axlsx/Axis.html @@ -1038,7 +1038,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:58 2011 by + Generated on Mon Nov 21 10:10:52 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Bar3DChart.html b/doc/Axlsx/Bar3DChart.html index 68333aa2..087b6b67 100644 --- a/doc/Axlsx/Bar3DChart.html +++ b/doc/Axlsx/Bar3DChart.html @@ -1144,7 +1144,7 @@ Serializes the bar chart </div> <div id="footer"> - Generated on Mon Nov 21 08:39:47 2011 by + Generated on Mon Nov 21 10:10:34 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/BarSeries.html b/doc/Axlsx/BarSeries.html index 04021bf2..916c6c8f 100644 --- a/doc/Axlsx/BarSeries.html +++ b/doc/Axlsx/BarSeries.html @@ -753,7 +753,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:56 2011 by + Generated on Mon Nov 21 10:10:49 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Border.html b/doc/Axlsx/Border.html index 21845aaa..fd1385dc 100644 --- a/doc/Axlsx/Border.html +++ b/doc/Axlsx/Border.html @@ -766,7 +766,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:56 2011 by + Generated on Mon Nov 21 10:10:49 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/BorderPr.html b/doc/Axlsx/BorderPr.html index 12bcf276..ba2a29f6 100644 --- a/doc/Axlsx/BorderPr.html +++ b/doc/Axlsx/BorderPr.html @@ -700,7 +700,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:47 2011 by + Generated on Mon Nov 21 10:10:35 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/CatAxis.html b/doc/Axlsx/CatAxis.html index c1a3907b..3415b79b 100644 --- a/doc/Axlsx/CatAxis.html +++ b/doc/Axlsx/CatAxis.html @@ -757,7 +757,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:40:01 2011 by + Generated on Mon Nov 21 10:10:57 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Cell.html b/doc/Axlsx/Cell.html index e659168b..cc824eec 100644 --- a/doc/Axlsx/Cell.html +++ b/doc/Axlsx/Cell.html @@ -1614,7 +1614,7 @@ xml text for the cell </div> <div id="footer"> - Generated on Mon Nov 21 08:39:46 2011 by + Generated on Mon Nov 21 10:10:33 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/CellAlignment.html b/doc/Axlsx/CellAlignment.html index a1b9a56c..0865cbb5 100644 --- a/doc/Axlsx/CellAlignment.html +++ b/doc/Axlsx/CellAlignment.html @@ -1238,7 +1238,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:40:00 2011 by + Generated on Mon Nov 21 10:10:54 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/CellProtection.html b/doc/Axlsx/CellProtection.html index 53d01dc9..809bab9e 100644 --- a/doc/Axlsx/CellProtection.html +++ b/doc/Axlsx/CellProtection.html @@ -556,7 +556,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:40:04 2011 by + Generated on Mon Nov 21 10:11:00 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/CellStyle.html b/doc/Axlsx/CellStyle.html index a3bb37aa..8cb02ba4 100644 --- a/doc/Axlsx/CellStyle.html +++ b/doc/Axlsx/CellStyle.html @@ -940,7 +940,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:45 2011 by + Generated on Mon Nov 21 10:10:32 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Chart.html b/doc/Axlsx/Chart.html index d7e1e5c1..4a612aca 100644 --- a/doc/Axlsx/Chart.html +++ b/doc/Axlsx/Chart.html @@ -1360,7 +1360,7 @@ Chart Serialization serializes the chart </div> <div id="footer"> - Generated on Mon Nov 21 08:39:59 2011 by + Generated on Mon Nov 21 10:10:53 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Color.html b/doc/Axlsx/Color.html index ea258b5c..60e142a1 100644 --- a/doc/Axlsx/Color.html +++ b/doc/Axlsx/Color.html @@ -656,7 +656,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:51 2011 by + Generated on Mon Nov 21 10:10:40 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/ContentType.html b/doc/Axlsx/ContentType.html index c6df769d..3880eaec 100644 --- a/doc/Axlsx/ContentType.html +++ b/doc/Axlsx/ContentType.html @@ -331,7 +331,7 @@ The document as a string. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:51 2011 by + Generated on Mon Nov 21 10:10:39 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Core.html b/doc/Axlsx/Core.html index d6cbb70f..0a4e5ed6 100644 --- a/doc/Axlsx/Core.html +++ b/doc/Axlsx/Core.html @@ -456,7 +456,7 @@ time when this method is called. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:55 2011 by + Generated on Mon Nov 21 10:10:47 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/DataTypeValidator.html b/doc/Axlsx/DataTypeValidator.html index a52b5754..6ce1762d 100644 --- a/doc/Axlsx/DataTypeValidator.html +++ b/doc/Axlsx/DataTypeValidator.html @@ -315,7 +315,7 @@ types or the block passed returns false </div> <div id="footer"> - Generated on Mon Nov 21 08:39:50 2011 by + Generated on Mon Nov 21 10:10:38 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Default.html b/doc/Axlsx/Default.html index e26a4173..b7be4fac 100644 --- a/doc/Axlsx/Default.html +++ b/doc/Axlsx/Default.html @@ -566,7 +566,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:40:04 2011 by + Generated on Mon Nov 21 10:11:01 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Drawing.html b/doc/Axlsx/Drawing.html index 3ebad077..21afe10e 100644 --- a/doc/Axlsx/Drawing.html +++ b/doc/Axlsx/Drawing.html @@ -1145,7 +1145,7 @@ Serializes the drawing </div> <div id="footer"> - Generated on Mon Nov 21 08:40:01 2011 by + Generated on Mon Nov 21 10:10:57 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Fill.html b/doc/Axlsx/Fill.html index e4d54840..f81853e3 100644 --- a/doc/Axlsx/Fill.html +++ b/doc/Axlsx/Fill.html @@ -451,7 +451,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:57 2011 by + Generated on Mon Nov 21 10:10:51 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Font.html b/doc/Axlsx/Font.html index 261cb513..54f607fa 100644 --- a/doc/Axlsx/Font.html +++ b/doc/Axlsx/Font.html @@ -1545,7 +1545,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:52 2011 by + Generated on Mon Nov 21 10:10:41 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/GradientFill.html b/doc/Axlsx/GradientFill.html index 4c1d6f34..91b411c5 100644 --- a/doc/Axlsx/GradientFill.html +++ b/doc/Axlsx/GradientFill.html @@ -1017,7 +1017,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:56 2011 by + Generated on Mon Nov 21 10:10:48 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/GradientStop.html b/doc/Axlsx/GradientStop.html index 07d32399..232eaaaa 100644 --- a/doc/Axlsx/GradientStop.html +++ b/doc/Axlsx/GradientStop.html @@ -517,7 +517,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:46 2011 by + Generated on Mon Nov 21 10:10:34 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/GraphicFrame.html b/doc/Axlsx/GraphicFrame.html index 1796d22c..4b00c70c 100644 --- a/doc/Axlsx/GraphicFrame.html +++ b/doc/Axlsx/GraphicFrame.html @@ -637,7 +637,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:49 2011 by + Generated on Mon Nov 21 10:10:37 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Marker.html b/doc/Axlsx/Marker.html index 4d207dcf..c34a2c6a 100644 --- a/doc/Axlsx/Marker.html +++ b/doc/Axlsx/Marker.html @@ -848,7 +848,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:50 2011 by + Generated on Mon Nov 21 10:10:38 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/NumFmt.html b/doc/Axlsx/NumFmt.html index 2fa42536..08ccb543 100644 --- a/doc/Axlsx/NumFmt.html +++ b/doc/Axlsx/NumFmt.html @@ -553,7 +553,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:58 2011 by + Generated on Mon Nov 21 10:10:52 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Override.html b/doc/Axlsx/Override.html index 1611c3b0..d265aa93 100644 --- a/doc/Axlsx/Override.html +++ b/doc/Axlsx/Override.html @@ -559,7 +559,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:56 2011 by + Generated on Mon Nov 21 10:10:50 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Package.html b/doc/Axlsx/Package.html index bccc0255..cd969a29 100644 --- a/doc/Axlsx/Package.html +++ b/doc/Axlsx/Package.html @@ -1284,7 +1284,7 @@ An array of all validation errors encountered. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:55 2011 by + Generated on Mon Nov 21 10:10:47 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/PatternFill.html b/doc/Axlsx/PatternFill.html index 0a45f7a0..e48ae5f4 100644 --- a/doc/Axlsx/PatternFill.html +++ b/doc/Axlsx/PatternFill.html @@ -672,7 +672,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:57 2011 by + Generated on Mon Nov 21 10:10:51 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Pie3DChart.html b/doc/Axlsx/Pie3DChart.html index 710cf7e4..a9cc3c67 100644 --- a/doc/Axlsx/Pie3DChart.html +++ b/doc/Axlsx/Pie3DChart.html @@ -430,7 +430,7 @@ Serializes the pie chart </div> <div id="footer"> - Generated on Mon Nov 21 08:39:45 2011 by + Generated on Mon Nov 21 10:10:33 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/PieSeries.html b/doc/Axlsx/PieSeries.html index 24164fd5..ae99a489 100644 --- a/doc/Axlsx/PieSeries.html +++ b/doc/Axlsx/PieSeries.html @@ -753,7 +753,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:57 2011 by + Generated on Mon Nov 21 10:10:51 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/RegexValidator.html b/doc/Axlsx/RegexValidator.html index 5770cc34..49fe4a80 100644 --- a/doc/Axlsx/RegexValidator.html +++ b/doc/Axlsx/RegexValidator.html @@ -259,7 +259,7 @@ The value to validate. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:52 2011 by + Generated on Mon Nov 21 10:10:40 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Relationship.html b/doc/Axlsx/Relationship.html index 56a4a057..600f4ae1 100644 --- a/doc/Axlsx/Relationship.html +++ b/doc/Axlsx/Relationship.html @@ -545,7 +545,7 @@ the reference id of the object. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:52 2011 by + Generated on Mon Nov 21 10:10:41 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Relationships.html b/doc/Axlsx/Relationships.html index 7a6b8f83..79b9f017 100644 --- a/doc/Axlsx/Relationships.html +++ b/doc/Axlsx/Relationships.html @@ -334,7 +334,7 @@ Serializes the relationships document. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:54 2011 by + Generated on Mon Nov 21 10:10:45 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/RestrictionValidator.html b/doc/Axlsx/RestrictionValidator.html index 2333e0e7..a3fd5cb2 100644 --- a/doc/Axlsx/RestrictionValidator.html +++ b/doc/Axlsx/RestrictionValidator.html @@ -291,7 +291,7 @@ Raised if the value provided is not in the list of choices. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:56 2011 by + Generated on Mon Nov 21 10:10:49 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Row.html b/doc/Axlsx/Row.html index a0492bf2..c33af64a 100644 --- a/doc/Axlsx/Row.html +++ b/doc/Axlsx/Row.html @@ -762,7 +762,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:59 2011 by + Generated on Mon Nov 21 10:10:53 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Scaling.html b/doc/Axlsx/Scaling.html index 731f0beb..2169a2d7 100644 --- a/doc/Axlsx/Scaling.html +++ b/doc/Axlsx/Scaling.html @@ -731,7 +731,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:54 2011 by + Generated on Mon Nov 21 10:10:44 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Series.html b/doc/Axlsx/Series.html index 916bea45..97dce3d5 100644 --- a/doc/Axlsx/Series.html +++ b/doc/Axlsx/Series.html @@ -741,7 +741,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:47 2011 by + Generated on Mon Nov 21 10:10:35 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/SimpleTypedList.html b/doc/Axlsx/SimpleTypedList.html index e5937d25..343d2e90 100644 --- a/doc/Axlsx/SimpleTypedList.html +++ b/doc/Axlsx/SimpleTypedList.html @@ -1608,7 +1608,7 @@ Unlock the list </div> <div id="footer"> - Generated on Mon Nov 21 08:40:01 2011 by + Generated on Mon Nov 21 10:10:56 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Styles.html b/doc/Axlsx/Styles.html index 068b6d46..ec5b305a 100644 --- a/doc/Axlsx/Styles.html +++ b/doc/Axlsx/Styles.html @@ -1745,7 +1745,7 @@ Serializes the styles document </div> <div id="footer"> - Generated on Mon Nov 21 08:40:04 2011 by + Generated on Mon Nov 21 10:11:00 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/TableStyle.html b/doc/Axlsx/TableStyle.html index 0f756e06..2c47f51d 100644 --- a/doc/Axlsx/TableStyle.html +++ b/doc/Axlsx/TableStyle.html @@ -701,7 +701,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:57 2011 by + Generated on Mon Nov 21 10:10:50 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/TableStyleElement.html b/doc/Axlsx/TableStyleElement.html index aaf72d82..f7a0978c 100644 --- a/doc/Axlsx/TableStyleElement.html +++ b/doc/Axlsx/TableStyleElement.html @@ -668,7 +668,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:58 2011 by + Generated on Mon Nov 21 10:10:52 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/TableStyles.html b/doc/Axlsx/TableStyles.html index 5526e203..f30dd2ca 100644 --- a/doc/Axlsx/TableStyles.html +++ b/doc/Axlsx/TableStyles.html @@ -590,7 +590,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:45 2011 by + Generated on Mon Nov 21 10:10:32 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Title.html b/doc/Axlsx/Title.html index ab6c5238..fa912ed9 100644 --- a/doc/Axlsx/Title.html +++ b/doc/Axlsx/Title.html @@ -612,7 +612,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:40:02 2011 by + Generated on Mon Nov 21 10:10:57 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/TwoCellAnchor.html b/doc/Axlsx/TwoCellAnchor.html index 03cfeebf..f4ace1f0 100644 --- a/doc/Axlsx/TwoCellAnchor.html +++ b/doc/Axlsx/TwoCellAnchor.html @@ -1106,7 +1106,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:54 2011 by + Generated on Mon Nov 21 10:10:45 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/ValAxis.html b/doc/Axlsx/ValAxis.html index 45b9bea9..2b0c82a7 100644 --- a/doc/Axlsx/ValAxis.html +++ b/doc/Axlsx/ValAxis.html @@ -530,7 +530,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:39:47 2011 by + Generated on Mon Nov 21 10:10:34 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/View3D.html b/doc/Axlsx/View3D.html index 6bc8857b..b97af86d 100644 --- a/doc/Axlsx/View3D.html +++ b/doc/Axlsx/View3D.html @@ -962,7 +962,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:40:02 2011 by + Generated on Mon Nov 21 10:10:58 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Workbook.html b/doc/Axlsx/Workbook.html index 0598bb3d..7bad5705 100644 --- a/doc/Axlsx/Workbook.html +++ b/doc/Axlsx/Workbook.html @@ -1338,7 +1338,7 @@ Serializes the workbook document </div> <div id="footer"> - Generated on Mon Nov 21 08:39:51 2011 by + Generated on Mon Nov 21 10:10:40 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Worksheet.html b/doc/Axlsx/Worksheet.html index 0a8da325..cbb59658 100644 --- a/doc/Axlsx/Worksheet.html +++ b/doc/Axlsx/Worksheet.html @@ -1855,7 +1855,7 @@ of Cell objects </div> <div id="footer"> - Generated on Mon Nov 21 08:39:51 2011 by + Generated on Mon Nov 21 10:10:39 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/Axlsx/Xf.html b/doc/Axlsx/Xf.html index ef2abfd9..1cd01143 100644 --- a/doc/Axlsx/Xf.html +++ b/doc/Axlsx/Xf.html @@ -1672,7 +1672,7 @@ The document builder instance this objects xml will be added to. </div> <div id="footer"> - Generated on Mon Nov 21 08:40:03 2011 by + Generated on Mon Nov 21 10:10:59 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/_index.html b/doc/_index.html index aa1ce964..fad580ad 100644 --- a/doc/_index.html +++ b/doc/_index.html @@ -566,7 +566,7 @@ </div> <div id="footer"> - Generated on Mon Nov 21 08:39:44 2011 by + Generated on Mon Nov 21 10:10:31 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/file.README.html b/doc/file.README.html index ff39e7b5..2024bfa2 100644 --- a/doc/file.README.html +++ b/doc/file.README.html @@ -144,6 +144,43 @@ It enables the you to generate 100% valid xlsx files that include customised sty <span class='end end kw'>end</span> </pre> +<p>Cell Specifc Styles</p> + +<pre class="code"> <span class='p identifier id'>p</span> <span class='assign token'>=</span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='Package constant id'>Package</span><span class='dot token'>.</span><span class='new identifier id'>new</span> <span class='do do kw'>do</span> <span class='bitor op'>|</span><span class='package identifier id'>package</span><span class='bitor op'>|</span> + + <span class='black_cell_spec identifier id'>black_cell_spec</span> <span class='assign token'>=</span> <span class='lbrace token'>{</span> <span class='symbol val'>:bg_color</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='string val'>"FF000000"</span><span class='comma token'>,</span> <span class='symbol val'>:fg_color</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='string val'>"FFFFFFFF"</span><span class='comma token'>,</span> <span class='symbol val'>:sz=</span><span class='gt op'>></span><span class='integer val'>14</span><span class='comma token'>,</span> <span class='symbol val'>:alignment</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='lbrace token'>{</span> <span class='symbol val'>:horizontal=</span><span class='gt op'>></span> <span class='symbol val'>:center</span> <span class='rbrace token'>}</span> <span class='rbrace token'>}</span> + <span class='blue_cell_spec identifier id'>blue_cell_spec</span> <span class='assign token'>=</span> <span class='lbrace token'>{</span> <span class='symbol val'>:bg_color</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='string val'>"FF0000FF"</span><span class='comma token'>,</span> <span class='symbol val'>:fg_color</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='string val'>"FFFFFFFF"</span><span class='comma token'>,</span> <span class='symbol val'>:sz=</span><span class='gt op'>></span><span class='integer val'>14</span><span class='comma token'>,</span> <span class='symbol val'>:alignment</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='lbrace token'>{</span> <span class='symbol val'>:horizontal=</span><span class='gt op'>></span> <span class='symbol val'>:center</span> <span class='rbrace token'>}</span> <span class='rbrace token'>}</span> + + <span class='black_cell identifier id'>black_cell</span> <span class='assign token'>=</span> <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='styles identifier id'>styles</span><span class='dot token'>.</span><span class='add_style identifier id'>add_style</span> <span class='black_cell_spec identifier id'>black_cell_spec</span> + <span class='blue_cell identifier id'>blue_cell</span> <span class='assign token'>=</span> <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='styles identifier id'>styles</span><span class='dot token'>.</span><span class='add_style identifier id'>add_style</span> <span class='blue_cell_spec identifier id'>blue_cell_spec</span> + + <span class='comment val'># date1904 support. uncomment the line below if you are working on a mac.</span> + <span class='comment val'># package.workbook.date1904 = true </span> + + <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='add_worksheet identifier id'>add_worksheet</span> <span class='do do kw'>do</span> <span class='bitor op'>|</span><span class='sheet identifier id'>sheet</span><span class='bitor op'>|</span> + <span class='sheet identifier id'>sheet</span><span class='dot token'>.</span><span class='add_row identifier id'>add_row</span> <span class='lbrack token'>[</span><span class='string val'>"Text Autowidth"</span><span class='comma token'>,</span> <span class='string val'>"Second"</span><span class='comma token'>,</span> <span class='string val'>"Third"</span><span class='rbrack token'>]</span><span class='comma token'>,</span> <span class='symbol val'>:style</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='lbrack token'>[</span><span class='black_cell identifier id'>black_cell</span><span class='comma token'>,</span> <span class='blue_cell identifier id'>blue_cell</span><span class='comma token'>,</span> <span class='black_cell identifier id'>black_cell</span><span class='rbrack token'>]</span> + <span class='sheet identifier id'>sheet</span><span class='dot token'>.</span><span class='add_row identifier id'>add_row</span> <span class='lbrack token'>[</span><span class='integer val'>1</span><span class='comma token'>,</span> <span class='integer val'>2</span><span class='comma token'>,</span> <span class='integer val'>3</span><span class='rbrack token'>]</span><span class='comma token'>,</span> <span class='symbol val'>:style</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='STYLE_THIN_BORDER constant id'>STYLE_THIN_BORDER</span> + <span class='end end kw'>end</span> + <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='serialize identifier id'>serialize</span><span class='lparen token'>(</span><span class='string val'>"example3.xlsx"</span><span class='rparen token'>)</span> + <span class='end end kw'>end</span> +</pre> + +<p>Number and Date formatting</p> + +<pre class="code"> <span class='p identifier id'>p</span> <span class='assign token'>=</span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='Package constant id'>Package</span><span class='dot token'>.</span><span class='new identifier id'>new</span> <span class='do do kw'>do</span> <span class='bitor op'>|</span><span class='package identifier id'>package</span><span class='bitor op'>|</span> + <span class='date identifier id'>date</span> <span class='assign token'>=</span> <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='styles identifier id'>styles</span><span class='dot token'>.</span><span class='add_style identifier id'>add_style</span> <span class='symbol val'>:format_code=</span><span class='gt op'>></span><span class='string val'>"yyyy-mm-dd"</span><span class='comma token'>,</span> <span class='symbol val'>:border</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='STYLE_THIN_BORDER constant id'>STYLE_THIN_BORDER</span> + <span class='padded identifier id'>padded</span> <span class='assign token'>=</span> <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='styles identifier id'>styles</span><span class='dot token'>.</span><span class='add_style identifier id'>add_style</span> <span class='symbol val'>:format_code=</span><span class='gt op'>></span><span class='string val'>"00#"</span><span class='comma token'>,</span> <span class='symbol val'>:border</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='STYLE_THIN_BORDER constant id'>STYLE_THIN_BORDER</span> + <span class='percent identifier id'>percent</span> <span class='assign token'>=</span> <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='styles identifier id'>styles</span><span class='dot token'>.</span><span class='add_style identifier id'>add_style</span> <span class='symbol val'>:format_code=</span><span class='gt op'>></span><span class='string val'>"0%"</span><span class='comma token'>,</span> <span class='symbol val'>:border</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='STYLE_THIN_BORDER constant id'>STYLE_THIN_BORDER</span> + + <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='add_worksheet identifier id'>add_worksheet</span> <span class='do do kw'>do</span> <span class='bitor op'>|</span><span class='sheet identifier id'>sheet</span><span class='bitor op'>|</span> + <span class='sheet identifier id'>sheet</span><span class='dot token'>.</span><span class='add_row identifier id'>add_row</span> + <span class='sheet identifier id'>sheet</span><span class='dot token'>.</span><span class='add_row identifier id'>add_row</span> <span class='lbrack token'>[</span><span class='string val'>"Custom Formatted Date"</span><span class='comma token'>,</span> <span class='string val'>"Percent Formatted Float"</span><span class='comma token'>,</span> <span class='string val'>"Padded Numbers"</span><span class='rbrack token'>]</span><span class='comma token'>,</span> <span class='symbol val'>:style</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='STYLE_THIN_BORDER constant id'>STYLE_THIN_BORDER</span> + <span class='sheet identifier id'>sheet</span><span class='dot token'>.</span><span class='add_row identifier id'>add_row</span> <span class='lbrack token'>[</span><span class='Time constant id'>Time</span><span class='dot token'>.</span><span class='now identifier id'>now</span><span class='comma token'>,</span> <span class='integer val'>0</span><span class='integer val'>.2</span><span class='comma token'>,</span> <span class='integer val'>32</span><span class='rbrack token'>]</span><span class='comma token'>,</span> <span class='symbol val'>:style</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='lbrack token'>[</span><span class='date identifier id'>date</span><span class='comma token'>,</span> <span class='percent identifier id'>percent</span><span class='comma token'>,</span> <span class='padded identifier id'>padded</span><span class='rbrack token'>]</span> + <span class='end end kw'>end</span> + <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='serialize identifier id'>serialize</span><span class='lparen token'>(</span><span class='string val'>"example5.xlsx"</span><span class='rparen token'>)</span> + <span class='end end kw'>end</span> +</pre> + <h3>Documentation</h3> <p>This gem is 100% documented with YARD, an exceptional documentation library. To see documentation for this, and all the gems installed on your system use:</p> @@ -163,21 +200,20 @@ It enables the you to generate 100% valid xlsx files that include customised sty <ul> <li>Updated documentation</li> <li>altered package to accept a filename string for serialization instead of a File object.</li> -<li>Updated specs to conform -Copyright</li> +<li>Updated specs to conform</li> </ul> </li> </ul> -<hr /> +<h2>Copyright</h2> <p>Axlsx © 2011 by <a href="mailto:[email protected]">Randy Morgan</a>. Axlsx is licensed under the MIT license. Please see the <a href="file.LICENSE.html" title="LICENSE">LICENSE</a> document for more information.</p> </div></div> <div id="footer"> - Generated on Mon Nov 21 08:39:44 2011 by + Generated on Mon Nov 21 10:10:31 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/index.html b/doc/index.html index ff39e7b5..2024bfa2 100644 --- a/doc/index.html +++ b/doc/index.html @@ -144,6 +144,43 @@ It enables the you to generate 100% valid xlsx files that include customised sty <span class='end end kw'>end</span> </pre> +<p>Cell Specifc Styles</p> + +<pre class="code"> <span class='p identifier id'>p</span> <span class='assign token'>=</span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='Package constant id'>Package</span><span class='dot token'>.</span><span class='new identifier id'>new</span> <span class='do do kw'>do</span> <span class='bitor op'>|</span><span class='package identifier id'>package</span><span class='bitor op'>|</span> + + <span class='black_cell_spec identifier id'>black_cell_spec</span> <span class='assign token'>=</span> <span class='lbrace token'>{</span> <span class='symbol val'>:bg_color</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='string val'>"FF000000"</span><span class='comma token'>,</span> <span class='symbol val'>:fg_color</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='string val'>"FFFFFFFF"</span><span class='comma token'>,</span> <span class='symbol val'>:sz=</span><span class='gt op'>></span><span class='integer val'>14</span><span class='comma token'>,</span> <span class='symbol val'>:alignment</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='lbrace token'>{</span> <span class='symbol val'>:horizontal=</span><span class='gt op'>></span> <span class='symbol val'>:center</span> <span class='rbrace token'>}</span> <span class='rbrace token'>}</span> + <span class='blue_cell_spec identifier id'>blue_cell_spec</span> <span class='assign token'>=</span> <span class='lbrace token'>{</span> <span class='symbol val'>:bg_color</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='string val'>"FF0000FF"</span><span class='comma token'>,</span> <span class='symbol val'>:fg_color</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='string val'>"FFFFFFFF"</span><span class='comma token'>,</span> <span class='symbol val'>:sz=</span><span class='gt op'>></span><span class='integer val'>14</span><span class='comma token'>,</span> <span class='symbol val'>:alignment</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='lbrace token'>{</span> <span class='symbol val'>:horizontal=</span><span class='gt op'>></span> <span class='symbol val'>:center</span> <span class='rbrace token'>}</span> <span class='rbrace token'>}</span> + + <span class='black_cell identifier id'>black_cell</span> <span class='assign token'>=</span> <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='styles identifier id'>styles</span><span class='dot token'>.</span><span class='add_style identifier id'>add_style</span> <span class='black_cell_spec identifier id'>black_cell_spec</span> + <span class='blue_cell identifier id'>blue_cell</span> <span class='assign token'>=</span> <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='styles identifier id'>styles</span><span class='dot token'>.</span><span class='add_style identifier id'>add_style</span> <span class='blue_cell_spec identifier id'>blue_cell_spec</span> + + <span class='comment val'># date1904 support. uncomment the line below if you are working on a mac.</span> + <span class='comment val'># package.workbook.date1904 = true </span> + + <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='add_worksheet identifier id'>add_worksheet</span> <span class='do do kw'>do</span> <span class='bitor op'>|</span><span class='sheet identifier id'>sheet</span><span class='bitor op'>|</span> + <span class='sheet identifier id'>sheet</span><span class='dot token'>.</span><span class='add_row identifier id'>add_row</span> <span class='lbrack token'>[</span><span class='string val'>"Text Autowidth"</span><span class='comma token'>,</span> <span class='string val'>"Second"</span><span class='comma token'>,</span> <span class='string val'>"Third"</span><span class='rbrack token'>]</span><span class='comma token'>,</span> <span class='symbol val'>:style</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='lbrack token'>[</span><span class='black_cell identifier id'>black_cell</span><span class='comma token'>,</span> <span class='blue_cell identifier id'>blue_cell</span><span class='comma token'>,</span> <span class='black_cell identifier id'>black_cell</span><span class='rbrack token'>]</span> + <span class='sheet identifier id'>sheet</span><span class='dot token'>.</span><span class='add_row identifier id'>add_row</span> <span class='lbrack token'>[</span><span class='integer val'>1</span><span class='comma token'>,</span> <span class='integer val'>2</span><span class='comma token'>,</span> <span class='integer val'>3</span><span class='rbrack token'>]</span><span class='comma token'>,</span> <span class='symbol val'>:style</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='STYLE_THIN_BORDER constant id'>STYLE_THIN_BORDER</span> + <span class='end end kw'>end</span> + <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='serialize identifier id'>serialize</span><span class='lparen token'>(</span><span class='string val'>"example3.xlsx"</span><span class='rparen token'>)</span> + <span class='end end kw'>end</span> +</pre> + +<p>Number and Date formatting</p> + +<pre class="code"> <span class='p identifier id'>p</span> <span class='assign token'>=</span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='Package constant id'>Package</span><span class='dot token'>.</span><span class='new identifier id'>new</span> <span class='do do kw'>do</span> <span class='bitor op'>|</span><span class='package identifier id'>package</span><span class='bitor op'>|</span> + <span class='date identifier id'>date</span> <span class='assign token'>=</span> <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='styles identifier id'>styles</span><span class='dot token'>.</span><span class='add_style identifier id'>add_style</span> <span class='symbol val'>:format_code=</span><span class='gt op'>></span><span class='string val'>"yyyy-mm-dd"</span><span class='comma token'>,</span> <span class='symbol val'>:border</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='STYLE_THIN_BORDER constant id'>STYLE_THIN_BORDER</span> + <span class='padded identifier id'>padded</span> <span class='assign token'>=</span> <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='styles identifier id'>styles</span><span class='dot token'>.</span><span class='add_style identifier id'>add_style</span> <span class='symbol val'>:format_code=</span><span class='gt op'>></span><span class='string val'>"00#"</span><span class='comma token'>,</span> <span class='symbol val'>:border</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='STYLE_THIN_BORDER constant id'>STYLE_THIN_BORDER</span> + <span class='percent identifier id'>percent</span> <span class='assign token'>=</span> <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='styles identifier id'>styles</span><span class='dot token'>.</span><span class='add_style identifier id'>add_style</span> <span class='symbol val'>:format_code=</span><span class='gt op'>></span><span class='string val'>"0%"</span><span class='comma token'>,</span> <span class='symbol val'>:border</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='STYLE_THIN_BORDER constant id'>STYLE_THIN_BORDER</span> + + <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='workbook identifier id'>workbook</span><span class='dot token'>.</span><span class='add_worksheet identifier id'>add_worksheet</span> <span class='do do kw'>do</span> <span class='bitor op'>|</span><span class='sheet identifier id'>sheet</span><span class='bitor op'>|</span> + <span class='sheet identifier id'>sheet</span><span class='dot token'>.</span><span class='add_row identifier id'>add_row</span> + <span class='sheet identifier id'>sheet</span><span class='dot token'>.</span><span class='add_row identifier id'>add_row</span> <span class='lbrack token'>[</span><span class='string val'>"Custom Formatted Date"</span><span class='comma token'>,</span> <span class='string val'>"Percent Formatted Float"</span><span class='comma token'>,</span> <span class='string val'>"Padded Numbers"</span><span class='rbrack token'>]</span><span class='comma token'>,</span> <span class='symbol val'>:style</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='Axlsx constant id'>Axlsx</span><span class='colon2 op'>::</span><span class='STYLE_THIN_BORDER constant id'>STYLE_THIN_BORDER</span> + <span class='sheet identifier id'>sheet</span><span class='dot token'>.</span><span class='add_row identifier id'>add_row</span> <span class='lbrack token'>[</span><span class='Time constant id'>Time</span><span class='dot token'>.</span><span class='now identifier id'>now</span><span class='comma token'>,</span> <span class='integer val'>0</span><span class='integer val'>.2</span><span class='comma token'>,</span> <span class='integer val'>32</span><span class='rbrack token'>]</span><span class='comma token'>,</span> <span class='symbol val'>:style</span> <span class='assign token'>=</span><span class='gt op'>></span> <span class='lbrack token'>[</span><span class='date identifier id'>date</span><span class='comma token'>,</span> <span class='percent identifier id'>percent</span><span class='comma token'>,</span> <span class='padded identifier id'>padded</span><span class='rbrack token'>]</span> + <span class='end end kw'>end</span> + <span class='package identifier id'>package</span><span class='dot token'>.</span><span class='serialize identifier id'>serialize</span><span class='lparen token'>(</span><span class='string val'>"example5.xlsx"</span><span class='rparen token'>)</span> + <span class='end end kw'>end</span> +</pre> + <h3>Documentation</h3> <p>This gem is 100% documented with YARD, an exceptional documentation library. To see documentation for this, and all the gems installed on your system use:</p> @@ -163,21 +200,20 @@ It enables the you to generate 100% valid xlsx files that include customised sty <ul> <li>Updated documentation</li> <li>altered package to accept a filename string for serialization instead of a File object.</li> -<li>Updated specs to conform -Copyright</li> +<li>Updated specs to conform</li> </ul> </li> </ul> -<hr /> +<h2>Copyright</h2> <p>Axlsx © 2011 by <a href="mailto:[email protected]">Randy Morgan</a>. Axlsx is licensed under the MIT license. Please see the <a href="file.LICENSE.html" title="LICENSE">LICENSE</a> document for more information.</p> </div></div> <div id="footer"> - Generated on Mon Nov 21 08:39:44 2011 by + Generated on Mon Nov 21 10:10:31 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/doc/top-level-namespace.html b/doc/top-level-namespace.html index 0a92e23e..88249615 100644 --- a/doc/top-level-namespace.html +++ b/doc/top-level-namespace.html @@ -94,7 +94,7 @@ </div> <div id="footer"> - Generated on Mon Nov 21 08:40:04 2011 by + Generated on Mon Nov 21 10:11:01 2011 by <a href="http://yardoc.org" title="Yay! A Ruby Documentation Tool" target="_parent">yard</a> 0.7.3 (ruby-1.8.7). </div> diff --git a/lib/axlsx/util/constants.rb b/lib/axlsx/util/constants.rb index a9f4b9f0..5fbfdf80 100644 --- a/lib/axlsx/util/constants.rb +++ b/lib/axlsx/util/constants.rb @@ -1,7 +1,7 @@ module Axlsx # version - VERSION="1.0.3" + VERSION="1.0.4" # XML Encoding ENCODING = "UTF-8" |