diff options
| author | Randy Morgan <[email protected]> | 2012-09-26 22:49:09 +0900 |
|---|---|---|
| committer | Randy Morgan <[email protected]> | 2012-09-26 22:49:09 +0900 |
| commit | 51d4118966d1c89a52a9d04ebede6e60dd26afe9 (patch) | |
| tree | a0b36746aa5678dfdc208dd449241edd9faddf9f /README.md | |
| parent | 54e3e2f157df97e6edebaca3510fb0603be432a9 (diff) | |
| download | caxlsx-51d4118966d1c89a52a9d04ebede6e60dd26afe9.tar.gz caxlsx-51d4118966d1c89a52a9d04ebede6e60dd26afe9.zip | |
update readme to show clear example of use_shared_strings for Numbers
Diffstat (limited to 'README.md')
| -rw-r--r-- | README.md | 18 |
1 files changed, 17 insertions, 1 deletions
@@ -209,7 +209,23 @@ related to themes, which axlsx does not implement at this time. - border colors do not work 3. Numbers - - you must set 'use_shared_strings' to true + - you must set 'use_shared_strings' to true. This is most + conveniently done just before rendering by calling Package.use_shared_strings = true prior to serialization. + +```ruby +Axlsx::Package.new do |p| + p.workbook.add_worksheet(:name => "Pie Chart") do |sheet| + sheet.add_row ["Simple Pie Chart"] + %w(first second third).each { |label| sheet.add_row [label, rand(24)+1] } + sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,5], :end_at => [10, 20], :title => "example 3: Pie Chart") do |chart| + chart.add_series :data => sheet["B2:B4"], :labels => sheet["A2:A4"], :colors => ['FF0000', '00FF00', '0000FF'] + end + end + p.use_shared_strings = true + p.serialize('simple.xlsx') +end +``` + - charts do not render |
