From 0a8c8cde8bf55d2f0f3b5ae26e38d7d4bda8a625 Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Mon, 21 Nov 2011 19:46:07 +0900 Subject: Readme update with better examples --- doc/Axlsx.html | 4 +- doc/Axlsx/App.html | 2 +- doc/Axlsx/Axis.html | 2 +- doc/Axlsx/Bar3DChart.html | 2 +- doc/Axlsx/BarSeries.html | 2 +- doc/Axlsx/Border.html | 2 +- doc/Axlsx/BorderPr.html | 2 +- doc/Axlsx/CatAxis.html | 2 +- doc/Axlsx/Cell.html | 2 +- doc/Axlsx/CellAlignment.html | 2 +- doc/Axlsx/CellProtection.html | 2 +- doc/Axlsx/CellStyle.html | 2 +- doc/Axlsx/Chart.html | 2 +- doc/Axlsx/Color.html | 2 +- doc/Axlsx/ContentType.html | 2 +- doc/Axlsx/Core.html | 2 +- doc/Axlsx/DataTypeValidator.html | 2 +- doc/Axlsx/Default.html | 2 +- doc/Axlsx/Drawing.html | 2 +- doc/Axlsx/Fill.html | 2 +- doc/Axlsx/Font.html | 2 +- doc/Axlsx/GradientFill.html | 2 +- doc/Axlsx/GradientStop.html | 2 +- doc/Axlsx/GraphicFrame.html | 2 +- doc/Axlsx/Marker.html | 2 +- doc/Axlsx/NumFmt.html | 2 +- doc/Axlsx/Override.html | 2 +- doc/Axlsx/Package.html | 2 +- doc/Axlsx/PatternFill.html | 2 +- doc/Axlsx/Pie3DChart.html | 2 +- doc/Axlsx/PieSeries.html | 2 +- doc/Axlsx/RegexValidator.html | 2 +- doc/Axlsx/Relationship.html | 2 +- doc/Axlsx/Relationships.html | 2 +- doc/Axlsx/RestrictionValidator.html | 2 +- doc/Axlsx/Row.html | 2 +- doc/Axlsx/Scaling.html | 2 +- doc/Axlsx/Series.html | 2 +- doc/Axlsx/SimpleTypedList.html | 2 +- doc/Axlsx/Styles.html | 2 +- doc/Axlsx/TableStyle.html | 2 +- doc/Axlsx/TableStyleElement.html | 2 +- doc/Axlsx/TableStyles.html | 2 +- doc/Axlsx/Title.html | 2 +- doc/Axlsx/TwoCellAnchor.html | 2 +- doc/Axlsx/ValAxis.html | 2 +- doc/Axlsx/View3D.html | 2 +- doc/Axlsx/Workbook.html | 2 +- doc/Axlsx/Worksheet.html | 2 +- doc/Axlsx/Xf.html | 2 +- doc/_index.html | 2 +- doc/file.README.html | 128 +++++---- doc/index.html | 128 +++++---- doc/method_list.html | 512 ++++++++++++++++++------------------ doc/top-level-namespace.html | 2 +- 55 files changed, 429 insertions(+), 445 deletions(-) (limited to 'doc') diff --git a/doc/Axlsx.html b/doc/Axlsx.html index 78ff81c7..bd7f61fd 100644 --- a/doc/Axlsx.html +++ b/doc/Axlsx.html @@ -122,7 +122,7 @@ version - 
"1.0.3"
+        
"1.0.4"
 

       
         
ENCODING =
@@ -2434,7 +2434,7 @@ The value validated
 
     
     
diff --git a/doc/Axlsx/App.html b/doc/Axlsx/App.html
index 5ccf2477..ceacd9b7 100644
--- a/doc/Axlsx/App.html
+++ b/doc/Axlsx/App.html
@@ -2631,7 +2631,7 @@ The document as a string
 
     
     
diff --git a/doc/Axlsx/Axis.html b/doc/Axlsx/Axis.html
index 18e077ff..bd28e976 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.
 
     
     
diff --git a/doc/Axlsx/Bar3DChart.html b/doc/Axlsx/Bar3DChart.html
index 087b6b67..1d6f3539 100644
--- a/doc/Axlsx/Bar3DChart.html
+++ b/doc/Axlsx/Bar3DChart.html
@@ -1144,7 +1144,7 @@ Serializes the bar chart
 
     
     
diff --git a/doc/Axlsx/BarSeries.html b/doc/Axlsx/BarSeries.html
index 916c6c8f..5384a077 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.
 
     
     
diff --git a/doc/Axlsx/Border.html b/doc/Axlsx/Border.html
index fd1385dc..24d11058 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.
 
     
     
diff --git a/doc/Axlsx/BorderPr.html b/doc/Axlsx/BorderPr.html
index ba2a29f6..f9a93ed0 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.
 
     
     
diff --git a/doc/Axlsx/CatAxis.html b/doc/Axlsx/CatAxis.html
index 3415b79b..891168a1 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.
 
     
     
diff --git a/doc/Axlsx/Cell.html b/doc/Axlsx/Cell.html
index cc824eec..9f90513f 100644
--- a/doc/Axlsx/Cell.html
+++ b/doc/Axlsx/Cell.html
@@ -1614,7 +1614,7 @@ xml text for the cell
 
     
     
diff --git a/doc/Axlsx/CellAlignment.html b/doc/Axlsx/CellAlignment.html
index 0865cbb5..07651c06 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.
 
     
     
diff --git a/doc/Axlsx/CellProtection.html b/doc/Axlsx/CellProtection.html
index 809bab9e..9f0d06d6 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.
 
     
     
diff --git a/doc/Axlsx/CellStyle.html b/doc/Axlsx/CellStyle.html
index 8cb02ba4..f3dfc76b 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.
 
     
     
diff --git a/doc/Axlsx/Chart.html b/doc/Axlsx/Chart.html
index 4a612aca..d60170e6 100644
--- a/doc/Axlsx/Chart.html
+++ b/doc/Axlsx/Chart.html
@@ -1360,7 +1360,7 @@ Chart Serialization serializes the chart
 
     
     
diff --git a/doc/Axlsx/Color.html b/doc/Axlsx/Color.html
index 60e142a1..9a5fdbc8 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.
 
     
     
diff --git a/doc/Axlsx/ContentType.html b/doc/Axlsx/ContentType.html
index 3880eaec..72b5f52c 100644
--- a/doc/Axlsx/ContentType.html
+++ b/doc/Axlsx/ContentType.html
@@ -331,7 +331,7 @@ The document as a string.
 
     
     
diff --git a/doc/Axlsx/Core.html b/doc/Axlsx/Core.html
index 0a4e5ed6..2b9f51f4 100644
--- a/doc/Axlsx/Core.html
+++ b/doc/Axlsx/Core.html
@@ -456,7 +456,7 @@ time when this method is called.
 
     
     
diff --git a/doc/Axlsx/DataTypeValidator.html b/doc/Axlsx/DataTypeValidator.html
index 6ce1762d..31b3bb99 100644
--- a/doc/Axlsx/DataTypeValidator.html
+++ b/doc/Axlsx/DataTypeValidator.html
@@ -315,7 +315,7 @@ types or the block passed returns false
 
     
     
diff --git a/doc/Axlsx/Default.html b/doc/Axlsx/Default.html
index b7be4fac..961e096e 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.
 
     
     
diff --git a/doc/Axlsx/Drawing.html b/doc/Axlsx/Drawing.html
index 21afe10e..e6f1fb51 100644
--- a/doc/Axlsx/Drawing.html
+++ b/doc/Axlsx/Drawing.html
@@ -1145,7 +1145,7 @@ Serializes the drawing
 
     
     
diff --git a/doc/Axlsx/Fill.html b/doc/Axlsx/Fill.html
index f81853e3..65103017 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.
 
     
     
diff --git a/doc/Axlsx/Font.html b/doc/Axlsx/Font.html
index 54f607fa..8e829ac3 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.
 
     
     
diff --git a/doc/Axlsx/GradientFill.html b/doc/Axlsx/GradientFill.html
index 91b411c5..bfc9407a 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.
 
     
     
diff --git a/doc/Axlsx/GradientStop.html b/doc/Axlsx/GradientStop.html
index 232eaaaa..51727c98 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.
 
     
     
diff --git a/doc/Axlsx/GraphicFrame.html b/doc/Axlsx/GraphicFrame.html
index 4b00c70c..6c259d82 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.
 
     
     
diff --git a/doc/Axlsx/Marker.html b/doc/Axlsx/Marker.html
index c34a2c6a..b7212a79 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.
 
     
     
diff --git a/doc/Axlsx/NumFmt.html b/doc/Axlsx/NumFmt.html
index 08ccb543..afe2086f 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.
 
     
     
diff --git a/doc/Axlsx/Override.html b/doc/Axlsx/Override.html
index d265aa93..23d29842 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.
 
     
     
diff --git a/doc/Axlsx/Package.html b/doc/Axlsx/Package.html
index cd969a29..a9007719 100644
--- a/doc/Axlsx/Package.html
+++ b/doc/Axlsx/Package.html
@@ -1284,7 +1284,7 @@ An array of all validation errors encountered.
 
     
     
diff --git a/doc/Axlsx/PatternFill.html b/doc/Axlsx/PatternFill.html
index e48ae5f4..3dcc6dd9 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.
 
     
     
diff --git a/doc/Axlsx/Pie3DChart.html b/doc/Axlsx/Pie3DChart.html
index a9cc3c67..ec7187c3 100644
--- a/doc/Axlsx/Pie3DChart.html
+++ b/doc/Axlsx/Pie3DChart.html
@@ -430,7 +430,7 @@ Serializes the pie chart
 
     
     
diff --git a/doc/Axlsx/PieSeries.html b/doc/Axlsx/PieSeries.html
index ae99a489..aa9adfee 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.
 
     
     
diff --git a/doc/Axlsx/RegexValidator.html b/doc/Axlsx/RegexValidator.html
index 49fe4a80..3d0b4c97 100644
--- a/doc/Axlsx/RegexValidator.html
+++ b/doc/Axlsx/RegexValidator.html
@@ -259,7 +259,7 @@ The value to validate.
 
     
     
diff --git a/doc/Axlsx/Relationship.html b/doc/Axlsx/Relationship.html
index 600f4ae1..16e1e3e6 100644
--- a/doc/Axlsx/Relationship.html
+++ b/doc/Axlsx/Relationship.html
@@ -545,7 +545,7 @@ the reference id of the object.
 
     
     
diff --git a/doc/Axlsx/Relationships.html b/doc/Axlsx/Relationships.html
index 79b9f017..e7b973ef 100644
--- a/doc/Axlsx/Relationships.html
+++ b/doc/Axlsx/Relationships.html
@@ -334,7 +334,7 @@ Serializes the relationships document.
 
     
     
diff --git a/doc/Axlsx/RestrictionValidator.html b/doc/Axlsx/RestrictionValidator.html
index a3fd5cb2..a6441a7d 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.
 
     
     
diff --git a/doc/Axlsx/Row.html b/doc/Axlsx/Row.html
index c33af64a..d7e6d669 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.
 
     
     
diff --git a/doc/Axlsx/Scaling.html b/doc/Axlsx/Scaling.html
index 2169a2d7..a2a24dbf 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.
 
     
     
diff --git a/doc/Axlsx/Series.html b/doc/Axlsx/Series.html
index 97dce3d5..5da758f4 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.
 
     
     
diff --git a/doc/Axlsx/SimpleTypedList.html b/doc/Axlsx/SimpleTypedList.html
index 343d2e90..bc3e4b5f 100644
--- a/doc/Axlsx/SimpleTypedList.html
+++ b/doc/Axlsx/SimpleTypedList.html
@@ -1608,7 +1608,7 @@ Unlock the list
 
     
     
diff --git a/doc/Axlsx/Styles.html b/doc/Axlsx/Styles.html
index ec5b305a..0fca6383 100644
--- a/doc/Axlsx/Styles.html
+++ b/doc/Axlsx/Styles.html
@@ -1745,7 +1745,7 @@ Serializes the styles document
 
     
     
diff --git a/doc/Axlsx/TableStyle.html b/doc/Axlsx/TableStyle.html
index 2c47f51d..c8f1f93c 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.
 
     
     
diff --git a/doc/Axlsx/TableStyleElement.html b/doc/Axlsx/TableStyleElement.html
index f7a0978c..885d8e15 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.
 
     
     
diff --git a/doc/Axlsx/TableStyles.html b/doc/Axlsx/TableStyles.html
index f30dd2ca..fdb60660 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.
 
     
     
diff --git a/doc/Axlsx/Title.html b/doc/Axlsx/Title.html
index fa912ed9..c55d9b51 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.
 
     
     
diff --git a/doc/Axlsx/TwoCellAnchor.html b/doc/Axlsx/TwoCellAnchor.html
index f4ace1f0..b5ef9a71 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.
 
     
     
diff --git a/doc/Axlsx/ValAxis.html b/doc/Axlsx/ValAxis.html
index 2b0c82a7..a1433dc5 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.
 
     
     
diff --git a/doc/Axlsx/View3D.html b/doc/Axlsx/View3D.html
index b97af86d..31d98713 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.
 
     
     
diff --git a/doc/Axlsx/Workbook.html b/doc/Axlsx/Workbook.html
index 7bad5705..adbeafcb 100644
--- a/doc/Axlsx/Workbook.html
+++ b/doc/Axlsx/Workbook.html
@@ -1338,7 +1338,7 @@ Serializes the workbook document
 
     
     
diff --git a/doc/Axlsx/Worksheet.html b/doc/Axlsx/Worksheet.html
index cbb59658..881561d0 100644
--- a/doc/Axlsx/Worksheet.html
+++ b/doc/Axlsx/Worksheet.html
@@ -1855,7 +1855,7 @@ of Cell objects
 
     
     
diff --git a/doc/Axlsx/Xf.html b/doc/Axlsx/Xf.html
index 1cd01143..b8462333 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.
 
     
     
diff --git a/doc/_index.html b/doc/_index.html
index fad580ad..8249c785 100644
--- a/doc/_index.html
+++ b/doc/_index.html
@@ -566,7 +566,7 @@
 
     
     
diff --git a/doc/file.README.html b/doc/file.README.html
index 2024bfa2..10377a44 100644
--- a/doc/file.README.html
+++ b/doc/file.README.html
@@ -92,93 +92,85 @@ It enables the you to generate 100% valid xlsx files that include customised sty
 
 
Usage

 
-
Simple Workbook

-
-
 p = Axlsx::Package.new do |package|
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row ["First", "Second", "Third"]
-     sheet.add_row [1, 2, 3]
-   end
-   package.serialize("example1.xlsx")
- end  
+
 require 'rubygems'
+ require 'axlsx'
 

 
-
Generating A Bar Chart

+
A Simple Workbook

 
-
 p = Axlsx::Package.new do |package|
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row ["First", "Second", "Third"]
-     sheet.add_row [1, 2, 3]
-     sheet.add_chart(Axlsx::Bar3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 1: Chart") do |chart|
-       chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells
-     end
-   end
-   package.serialize("example1.xlsx")
- end  
+
  p = Axlsx::Package.new
+  p.workbook.add_worksheet do |sheet|
+    sheet.add_row ["First", "Second", "Third"]
+    sheet.add_row [1, 2, 3]
+  end
+  p.serialize("example1.xlsx")
 

 
-
Generating A Pie Chart

+
Generating A Bar Chart

 
-
 p = Axlsx::Package.new do |package|
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row ["First", "Second", "Third"]
-     sheet.add_row [1, 2, 3]
-     sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 2: Pie Chart") do |chart|
-       chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells
-     end
+
 p = Axlsx::Package.new
+ p.workbook.add_worksheet do |sheet|
+   sheet.add_row ["First", "Second", "Third"]
+   sheet.add_row [1, 2, 3]
+   sheet.add_chart(Axlsx::Bar3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 1: Chart") do |chart|
+     chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells
    end
-   package.serialize("example3.xlsx")
  end  
+ p.serialize("example2.xlsx")
 

 
-
Using Custom Styles

+
Generating A Pie Chart

 
-
 p = Axlsx::Package.new do |package|
-   style_options = { :bg_color => "FF000000", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center } }
-   header_style = package.workbook.styles.add_style style_options
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row ["Text Autowidth", "Second", "Third"], :style => header_style
-     sheet.add_row [1, 2, 3], :style => Axlsx::STYLE_THIN_BORDER
+
 p = Axlsx::Package.new
+ p.workbook.add_worksheet do |sheet|
+   sheet.add_row ["First", "Second", "Third"]
+   sheet.add_row [1, 2, 3]
+   sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 2: Pie Chart") do |chart|
+     chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells
    end
-   package.serialize("example3.xlsx")
  end  
+ p.serialize("example3.xlsx")
 

 
-
Cell Specifc Styles

-
-
 p = Axlsx::Package.new do |package|
-
-   black_cell_spec = { :bg_color => "FF000000", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center } }
-   blue_cell_spec = { :bg_color => "FF0000FF", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center } }
-
-   black_cell = package.workbook.styles.add_style black_cell_spec
-   blue_cell = package.workbook.styles.add_style blue_cell_spec
-
-   # date1904 support. uncomment the line below if you are working on a mac.
-   # package.workbook.date1904 = true 
+
Using Custom Styles

+
+
 p = Axlsx::Package.new
+ wb = p.workbook
+ black_cell = wb.styles.add_style :bg_color => "FF000000", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center }
+ blue_cell = wb.styles.add_style  :bg_color => "FF0000FF", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center }
+ wb.add_worksheet do |sheet|
+   sheet.add_row ["Text Autowidth", "Second", "Third"], :style => [black_cell, blue_cell, black_cell]
+   sheet.add_row [1, 2, 3], :style => Axlsx::STYLE_THIN_BORDER
+ end
+ p.serialize("example4.xlsx")
+

 
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row ["Text Autowidth", "Second", "Third"], :style => [black_cell, blue_cell, black_cell]
-     sheet.add_row [1, 2, 3], :style => Axlsx::STYLE_THIN_BORDER
-   end
-   package.serialize("example3.xlsx")
- end  
+
Using Custom Formatting and date1904

+
+
 p = Axlsx::Package.new
+ wb = p.workbook
+ date = wb.styles.add_style :format_code=>"yyyy-mm-dd", :border => Axlsx::STYLE_THIN_BORDER
+ padded = wb.styles.add_style :format_code=>"00#", :border => Axlsx::STYLE_THIN_BORDER
+ percent = wb.styles.add_style :format_code=>"0%", :border => Axlsx::STYLE_THIN_BORDER
+ wb.date1904 = true # required for generation on mac
+ wb.add_worksheet do |sheet|
+   sheet.add_row ["Custom Formatted Date", "Percent Formatted Float", "Padded Numbers"], :style => Axlsx::STYLE_THIN_BORDER
+   sheet.add_row [Time.now, 0.2, 32], :style => [date, percent, padded]
+ end
+ p.serialize("example5.xlsx")
 

 
-
Number and Date formatting

+
Validation

 
-
 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
-   percent = package.workbook.styles.add_style :format_code=>"0%", :border => Axlsx::STYLE_THIN_BORDER
+
 p = Axlsx::Package.new
+ p.workbook.add_worksheet do |sheet|
+   sheet.add_row ["First", "Second", "Third"]
+   sheet.add_row [1, 2, 3]
+ end
 
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row
-     sheet.add_row ["Custom Formatted Date", "Percent Formatted Float", "Padded Numbers"], :style => Axlsx::STYLE_THIN_BORDER
-     sheet.add_row [Time.now, 0.2, 32], :style => [date, percent, padded]
-   end
-   package.serialize("example5.xlsx")
- end  
+ p.validate.each do |error|
+   puts error.inspect
+ end
 

 
 
Documentation

@@ -213,7 +205,7 @@ licensed under the MIT license. Please see the 
     
     
diff --git a/doc/index.html b/doc/index.html
index 2024bfa2..10377a44 100644
--- a/doc/index.html
+++ b/doc/index.html
@@ -92,93 +92,85 @@ It enables the you to generate 100% valid xlsx files that include customised sty
 
 
Usage

 
-
Simple Workbook

-
-
 p = Axlsx::Package.new do |package|
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row ["First", "Second", "Third"]
-     sheet.add_row [1, 2, 3]
-   end
-   package.serialize("example1.xlsx")
- end  
+
 require 'rubygems'
+ require 'axlsx'
 

 
-
Generating A Bar Chart

+
A Simple Workbook

 
-
 p = Axlsx::Package.new do |package|
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row ["First", "Second", "Third"]
-     sheet.add_row [1, 2, 3]
-     sheet.add_chart(Axlsx::Bar3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 1: Chart") do |chart|
-       chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells
-     end
-   end
-   package.serialize("example1.xlsx")
- end  
+
  p = Axlsx::Package.new
+  p.workbook.add_worksheet do |sheet|
+    sheet.add_row ["First", "Second", "Third"]
+    sheet.add_row [1, 2, 3]
+  end
+  p.serialize("example1.xlsx")
 

 
-
Generating A Pie Chart

+
Generating A Bar Chart

 
-
 p = Axlsx::Package.new do |package|
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row ["First", "Second", "Third"]
-     sheet.add_row [1, 2, 3]
-     sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 2: Pie Chart") do |chart|
-       chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells
-     end
+
 p = Axlsx::Package.new
+ p.workbook.add_worksheet do |sheet|
+   sheet.add_row ["First", "Second", "Third"]
+   sheet.add_row [1, 2, 3]
+   sheet.add_chart(Axlsx::Bar3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 1: Chart") do |chart|
+     chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells
    end
-   package.serialize("example3.xlsx")
  end  
+ p.serialize("example2.xlsx")
 

 
-
Using Custom Styles

+
Generating A Pie Chart

 
-
 p = Axlsx::Package.new do |package|
-   style_options = { :bg_color => "FF000000", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center } }
-   header_style = package.workbook.styles.add_style style_options
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row ["Text Autowidth", "Second", "Third"], :style => header_style
-     sheet.add_row [1, 2, 3], :style => Axlsx::STYLE_THIN_BORDER
+
 p = Axlsx::Package.new
+ p.workbook.add_worksheet do |sheet|
+   sheet.add_row ["First", "Second", "Third"]
+   sheet.add_row [1, 2, 3]
+   sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 2: Pie Chart") do |chart|
+     chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells
    end
-   package.serialize("example3.xlsx")
  end  
+ p.serialize("example3.xlsx")
 

 
-
Cell Specifc Styles

-
-
 p = Axlsx::Package.new do |package|
-
-   black_cell_spec = { :bg_color => "FF000000", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center } }
-   blue_cell_spec = { :bg_color => "FF0000FF", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center } }
-
-   black_cell = package.workbook.styles.add_style black_cell_spec
-   blue_cell = package.workbook.styles.add_style blue_cell_spec
-
-   # date1904 support. uncomment the line below if you are working on a mac.
-   # package.workbook.date1904 = true 
+
Using Custom Styles

+
+
 p = Axlsx::Package.new
+ wb = p.workbook
+ black_cell = wb.styles.add_style :bg_color => "FF000000", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center }
+ blue_cell = wb.styles.add_style  :bg_color => "FF0000FF", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center }
+ wb.add_worksheet do |sheet|
+   sheet.add_row ["Text Autowidth", "Second", "Third"], :style => [black_cell, blue_cell, black_cell]
+   sheet.add_row [1, 2, 3], :style => Axlsx::STYLE_THIN_BORDER
+ end
+ p.serialize("example4.xlsx")
+

 
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row ["Text Autowidth", "Second", "Third"], :style => [black_cell, blue_cell, black_cell]
-     sheet.add_row [1, 2, 3], :style => Axlsx::STYLE_THIN_BORDER
-   end
-   package.serialize("example3.xlsx")
- end  
+
Using Custom Formatting and date1904

+
+
 p = Axlsx::Package.new
+ wb = p.workbook
+ date = wb.styles.add_style :format_code=>"yyyy-mm-dd", :border => Axlsx::STYLE_THIN_BORDER
+ padded = wb.styles.add_style :format_code=>"00#", :border => Axlsx::STYLE_THIN_BORDER
+ percent = wb.styles.add_style :format_code=>"0%", :border => Axlsx::STYLE_THIN_BORDER
+ wb.date1904 = true # required for generation on mac
+ wb.add_worksheet do |sheet|
+   sheet.add_row ["Custom Formatted Date", "Percent Formatted Float", "Padded Numbers"], :style => Axlsx::STYLE_THIN_BORDER
+   sheet.add_row [Time.now, 0.2, 32], :style => [date, percent, padded]
+ end
+ p.serialize("example5.xlsx")
 

 
-
Number and Date formatting

+
Validation

 
-
 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
-   percent = package.workbook.styles.add_style :format_code=>"0%", :border => Axlsx::STYLE_THIN_BORDER
+
 p = Axlsx::Package.new
+ p.workbook.add_worksheet do |sheet|
+   sheet.add_row ["First", "Second", "Third"]
+   sheet.add_row [1, 2, 3]
+ end
 
-   package.workbook.add_worksheet do |sheet|
-     sheet.add_row
-     sheet.add_row ["Custom Formatted Date", "Percent Formatted Float", "Padded Numbers"], :style => Axlsx::STYLE_THIN_BORDER
-     sheet.add_row [Time.now, 0.2, 32], :style => [date, percent, padded]
-   end
-   package.serialize("example5.xlsx")
- end  
+ p.validate.each do |error|
+   puts error.inspect
+ end
 

 
 
Documentation

@@ -213,7 +205,7 @@ licensed under the MIT license. Please see the 
     
     
diff --git a/doc/method_list.html b/doc/method_list.html
index 80d1dc52..aede7025 100644
--- a/doc/method_list.html
+++ b/doc/method_list.html
@@ -89,17 +89,17 @@
   
 
   
  • 
-    #ContentType
+    #ContentType
     
-      Axlsx::Override
+      Axlsx::Default
     
   
    • 
   
 
   
  • 
-    #ContentType
+    #ContentType
     
-      Axlsx::Default
+      Axlsx::Override
     
   
    • 
   
@@ -617,17 +617,17 @@
   
 
   
  • 
-    #chart
+    #chart
     
-      Axlsx::GraphicFrame
+      Axlsx::Series
     
   
    • 
   
 
   
  • 
-    #chart
+    #chart
     
-      Axlsx::Series
+      Axlsx::GraphicFrame
     
   
    • 
   
@@ -673,9 +673,9 @@
   
 
   
  • 
-    #color
+    #color
     
-      Axlsx::Font
+      Axlsx::GradientStop
     
   
    • 
   
@@ -689,9 +689,9 @@
   
 
   
  • 
-    #color
+    #color
     
-      Axlsx::GradientStop
+      Axlsx::Font
     
   
    • 
   
@@ -761,17 +761,17 @@
   
 
   
  • 
-    #data
+    #data
     
-      Axlsx::PieSeries
+      Axlsx::BarSeries
     
   
    • 
   
 
   
  • 
-    #data
+    #data
     
-      Axlsx::BarSeries
+      Axlsx::PieSeries
     
   
    • 
   
@@ -1065,17 +1065,17 @@
   
 
   
  • 
-    #hidden
+    #hidden
     
-      Axlsx::CellStyle
+      Axlsx::CellProtection
     
   
    • 
   
 
   
  • 
-    #hidden
+    #hidden
     
-      Axlsx::CellProtection
+      Axlsx::CellStyle
     
   
    • 
   
@@ -1113,41 +1113,41 @@
   
 
   
  • 
-    #index
+    #index
     
-      Axlsx::Chart
+      Axlsx::Row
     
   
    • 
   
 
   
  • 
-    #index
+    #index
     
-      Axlsx::Worksheet
+      Axlsx::TwoCellAnchor
     
   
    • 
   
 
   
  • 
-    #index
+    #index
     
-      Axlsx::Row
+      Axlsx::Worksheet
     
   
    • 
   
 
   
  • 
-    #index
+    #index
     
-      Axlsx::Series
+      Axlsx::Cell
     
   
    • 
   
 
   
  • 
-    #index
+    #index
     
-      Axlsx::Cell
+      Axlsx::Chart
     
   
    • 
   
@@ -1161,9 +1161,9 @@
   
 
   
  • 
-    #index
+    #index
     
-      Axlsx::TwoCellAnchor
+      Axlsx::Series
     
   
    • 
   
@@ -1177,9 +1177,9 @@
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Worksheet
+      Axlsx::TableStyles
     
   
    • 
   
@@ -1193,345 +1193,345 @@
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::CellStyle
+      Axlsx::Row
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Workbook
+      Axlsx::PieSeries
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Border
+      Axlsx::Default
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Relationships
+      Axlsx::GraphicFrame
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Drawing
+      Axlsx::CellAlignment
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Pie3DChart
+      Axlsx::ValAxis
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::BorderPr
+      Axlsx::CatAxis
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::SimpleTypedList
+      Axlsx::Title
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Bar3DChart
+      Axlsx::Core
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Core
+      Axlsx::TwoCellAnchor
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Title
+      Axlsx::Pie3DChart
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::BarSeries
+      Axlsx::GradientStop
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::GradientStop
+      Axlsx::TableStyleElement
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Chart
+      Axlsx::Axis
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Color
+      Axlsx::TableStyle
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::NumFmt
+      Axlsx::View3D
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Cell
+      Axlsx::Drawing
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::GraphicFrame
+      Axlsx::Override
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::TableStyle
+      Axlsx::Font
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Fill
+      Axlsx::Package
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Font
+      Axlsx::Scaling
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::PieSeries
+      Axlsx::Worksheet
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Axis
+      Axlsx::GradientFill
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::TableStyles
+      Axlsx::PatternFill
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Xf
+      Axlsx::Workbook
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::GradientFill
+      Axlsx::SimpleTypedList
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::CellAlignment
+      Axlsx::Border
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Default
+      Axlsx::Marker
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::TableStyleElement
+      Axlsx::CellStyle
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::View3D
+      Axlsx::CellProtection
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Override
+      Axlsx::Chart
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::CatAxis
+      Axlsx::Xf
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Row
+      Axlsx::ContentType
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::PatternFill
+      Axlsx::BarSeries
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Package
+      Axlsx::Fill
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Scaling
+      Axlsx::Series
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::TwoCellAnchor
+      Axlsx::Styles
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::ContentType
+      Axlsx::Relationships
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::ValAxis
+      Axlsx::NumFmt
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Series
+      Axlsx::Cell
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Marker
+      Axlsx::Color
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::CellProtection
+      Axlsx::Bar3DChart
     
   
    • 
   
 
   
  • 
-    #initialize
+    #initialize
     
-      Axlsx::Styles
+      Axlsx::BorderPr
     
   
    • 
   
@@ -1641,41 +1641,41 @@
   
 
   
  • 
-    #name
+    #name
     
-      Axlsx::Worksheet
+      Axlsx::BorderPr
     
   
    • 
   
 
   
  • 
-    #name
+    #name
     
-      Axlsx::CellStyle
+      Axlsx::TableStyle
     
   
    • 
   
 
   
  • 
-    #name
+    #name
     
-      Axlsx::TableStyle
+      Axlsx::Font
     
   
    • 
   
 
   
  • 
-    #name
+    #name
     
-      Axlsx::BorderPr
+      Axlsx::CellStyle
     
   
    • 
   
 
   
  • 
-    #name
+    #name
     
-      Axlsx::Font
+      Axlsx::Worksheet
     
   
    • 
   
@@ -1777,9 +1777,9 @@
   
 
   
  • 
-    #pn
+    #pn
     
-      Axlsx::Chart
+      Axlsx::Worksheet
     
   
    • 
   
@@ -1793,9 +1793,9 @@
   
 
   
  • 
-    #pn
+    #pn
     
-      Axlsx::Worksheet
+      Axlsx::Chart
     
   
    • 
   
@@ -1921,25 +1921,25 @@
   
 
   
  • 
-    #relationships
+    #relationships
     
-      Axlsx::Drawing
+      Axlsx::Worksheet
     
   
    • 
   
 
   
  • 
-    #relationships
+    #relationships
     
-      Axlsx::Worksheet
+      Axlsx::Workbook
     
   
    • 
   
 
   
  • 
-    #relationships
+    #relationships
     
-      Axlsx::Workbook
+      Axlsx::Drawing
     
   
    • 
   
@@ -1953,17 +1953,17 @@
   
 
   
  • 
-    #rels_pn
+    #rels_pn
     
-      Axlsx::Worksheet
+      Axlsx::Drawing
     
   
    • 
   
 
   
  • 
-    #rels_pn
+    #rels_pn
     
-      Axlsx::Drawing
+      Axlsx::Worksheet
     
   
    • 
   
@@ -2001,17 +2001,17 @@
   
 
   
  • 
-    #row
+    #row
     
-      Axlsx::Cell
+      Axlsx::Marker
     
   
    • 
   
 
   
  • 
-    #row
+    #row
     
-      Axlsx::Marker
+      Axlsx::Cell
     
   
    • 
   
@@ -2153,17 +2153,17 @@
   
 
   
  • 
-    #style
+    #style
     
-      Axlsx::BorderPr
+      Axlsx::Cell
     
   
    • 
   
 
   
  • 
-    #style
+    #style
     
-      Axlsx::Cell
+      Axlsx::BorderPr
     
   
    • 
   
@@ -2233,17 +2233,17 @@
   
 
   
  • 
-    #title
+    #title
     
-      Axlsx::Chart
+      Axlsx::Series
     
   
    • 
   
 
   
  • 
-    #title
+    #title
     
-      Axlsx::Series
+      Axlsx::Chart
     
   
    • 
   
@@ -2257,25 +2257,25 @@
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::BarSeries
+      Axlsx::GradientStop
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Row
+      Axlsx::Border
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Override
+      Axlsx::Font
     
   
    • 
   
@@ -2289,329 +2289,329 @@
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::GradientStop
+      Axlsx::Color
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Axis
+      Axlsx::Cell
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Border
+      Axlsx::Drawing
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Worksheet
+      Axlsx::CellProtection
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Font
+      Axlsx::TwoCellAnchor
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Cell
+      Axlsx::Styles
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::PatternFill
+      Axlsx::Default
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::GradientFill
+      Axlsx::Worksheet
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Default
+      Axlsx::TableStyles
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::CellAlignment
+      Axlsx::Relationship
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::CellStyle
+      Axlsx::ValAxis
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Core
+      Axlsx::Axis
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Title
+      Axlsx::BarSeries
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Fill
+      Axlsx::GraphicFrame
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Scaling
+      Axlsx::CellAlignment
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::TableStyles
+      Axlsx::Title
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Workbook
+      Axlsx::Scaling
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::TwoCellAnchor
+      Axlsx::Bar3DChart
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Xf
+      Axlsx::Marker
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::GraphicFrame
+      Axlsx::View3D
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::View3D
+      Axlsx::Fill
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Pie3DChart
+      Axlsx::Core
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::CatAxis
+      Axlsx::TableStyleElement
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::TableStyleElement
+      Axlsx::NumFmt
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Drawing
+      Axlsx::Xf
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::App
+      Axlsx::Workbook
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Marker
+      Axlsx::Chart
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Relationship
+      Axlsx::Pie3DChart
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::PieSeries
+      Axlsx::App
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Bar3DChart
+      Axlsx::Row
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::SimpleTypedList
+      Axlsx::PatternFill
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Chart
+      Axlsx::CatAxis
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Relationships
+      Axlsx::Override
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Styles
+      Axlsx::PieSeries
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::BorderPr
+      Axlsx::CellStyle
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::ValAxis
+      Axlsx::Series
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::CellProtection
+      Axlsx::SimpleTypedList
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::NumFmt
+      Axlsx::ContentType
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::ContentType
+      Axlsx::GradientFill
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Color
+      Axlsx::BorderPr
     
   
    • 
   
 
   
  • 
-    #to_xml
+    #to_xml
     
-      Axlsx::Series
+      Axlsx::Relationships
     
   
    • 
   
@@ -2625,9 +2625,9 @@
   
 
   
  • 
-    #type
+    #type
     
-      Axlsx::TableStyleElement
+      Axlsx::Cell
     
   
    • 
   
@@ -2641,9 +2641,9 @@
   
 
   
  • 
-    #type
+    #type
     
-      Axlsx::Cell
+      Axlsx::TableStyleElement
     
   
    • 
   
@@ -2673,17 +2673,17 @@
   
 
   
  • 
-    validate
+    #validate
     
-      Axlsx::RegexValidator
+      Axlsx::Package
     
   
    • 
   
 
   
  • 
-    #validate
+    validate
     
-      Axlsx::Package
+      Axlsx::RegexValidator
     
   
    • 
   
@@ -2849,17 +2849,17 @@
   
 
   
  • 
-    #worksheet
+    #worksheet
     
-      Axlsx::Row
+      Axlsx::Drawing
     
   
    • 
   
 
   
  • 
-    #worksheet
+    #worksheet
     
-      Axlsx::Drawing
+      Axlsx::Row
     
   
    • 
   
diff --git a/doc/top-level-namespace.html b/doc/top-level-namespace.html
index 88249615..7ebd7b99 100644
--- a/doc/top-level-namespace.html
+++ b/doc/top-level-namespace.html
@@ -94,7 +94,7 @@
 
     
     
-- 
cgit v1.2.3