| Age | Commit message (Collapse) | Author | |
|---|---|---|---|
| 2020-09-11 | Restructure examples folder (#47) | Zsolt Kozaroczy | |
| Split examples into separate markdown files, each containing a description, sample code, and a screenshot of the resulting xlsx document. The script `generate.rb` is provided to actually generate the example documents by executing the sample code contained in the markdown files. | |||
| 2012-11-27 | Can configure a pivot table when creating it | Alex Rothenberg | |
| see examples/pivot_table.rb wb.add_worksheet(:name => "Data Sheet") do |sheet| sheet.add_row ['Month', 'Year', 'Type', 'Sales', 'Region'] 30.times { sheet.add_row [month, year, type, sales, region] } sheet.add_pivot_table 'G4:L17', "A1:E31" do |pivot_table| pivot_table.rows = ['Month', 'Year'] pivot_table.columns = ['Type'] pivot_table.data = ['Sales'] pivot_table.pages = ['Region'] end end | |||
| 2012-11-27 | Create a simple Pivot Table | Alex Rothenberg | |
| * an example can be run with `ruby examples/pivot_table.rb` * right now you cannot set options on the pivot table to make it useful (coming soon...) | |||
 |
index : caxlsx | |
| Caxlsx | realtradam |
| summaryrefslogtreecommitdiffhomepage |