diff options
| author | Randy Morgan <[email protected]> | 2011-11-21 23:42:03 +0900 |
|---|---|---|
| committer | Randy Morgan <[email protected]> | 2011-11-21 23:42:03 +0900 |
| commit | 11729af6e1dc9492ba1fadb3681b885a4ff7dbbb (patch) | |
| tree | c47d5e007b9711066bc46be5914fe73e75bace6c /assets/example.rb | |
| parent | e53a0b7223e531046dd263ff5686d6e34196512a (diff) | |
| download | caxlsx-11729af6e1dc9492ba1fadb3681b885a4ff7dbbb.tar.gz caxlsx-11729af6e1dc9492ba1fadb3681b885a4ff7dbbb.zip | |
Adding in support for line charts, style attribute for all charts and minor bug fixes.
Diffstat (limited to 'assets/example.rb')
| -rw-r--r-- | assets/example.rb | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/assets/example.rb b/assets/example.rb index b3fe6f54..fd02598f 100644 --- a/assets/example.rb +++ b/assets/example.rb @@ -31,6 +31,7 @@ end p.serialize("example3.xlsx") + #Using Custom Styles p = Axlsx::Package.new @@ -68,3 +69,15 @@ puts error.inspect end +#Generating A Line Chart + + p = Axlsx::Package.new + p.workbook.add_worksheet do |sheet| + sheet.add_row ["First", 1, 5, 7, 9] + sheet.add_row ["Second", 5, 2, 14, 9] + sheet.add_chart(Axlsx::Line3DChart, :start_at => [0,2], :end_at => [10, 15], :title=>"example 6: Line Chart") do |chart| + chart.add_series :data=>sheet.rows.first.cells[(1..-1)], :title=> sheet.rows.first.cells.first + chart.add_series :data=>sheet.rows.last.cells[(1..-1)], :title=> sheet.rows.last.cells.first + end + end + p.serialize("example6.xlsx") |