README.md in spreadsheet_architect-2.0.0 vs README.md in spreadsheet_architect-2.0.1
- old
+ new
@@ -134,11 +134,11 @@
```ruby
# Ex. with ActiveRecord relation
File.open('path/to/file.xlsx', 'w+b') do |f|
f.write{ Post.order(published_at: :asc).to_xlsx }
end
-File.open('path/to/file.ods', 'w+b) do |f|
+File.open('path/to/file.ods', 'w+b') do |f|
f.write{ Post.order(published_at: :asc).to_ods }
end
File.open('path/to/file.csv', 'w+b') do |f|
f.write{ Post.order(published_at: :asc).to_csv }
end
@@ -276,9 +276,18 @@
# Complex XLSX Example with Styling
See this example: (https://github.com/westonganger/spreadsheet_architect/blob/master/examples/complex_xlsx_styling.rb)
# Multi Sheet XLSX or ODS spreadsheets
+```ruby
+# Returns corresponding spreadsheet libraries object
+package = SpreadsheetArchitect.to_axlsx_package({data: data, headers: headers})
+SpreadsheetArchitect.to_axlsx_package({data: data, headers: headers}, package) # to combine two sheets to one file
+
+spreadsheet = SpreadsheetArchitect.to_rodf_spreadsheet({data: data, headers: headers})
+SpreadsheetArchitect.to_rodf_spreadsheet({data: data, headers: headers}, spreadsheet) # to combine two sheets to one file
+```
+
See this example: (https://github.com/westonganger/spreadsheet_architect/blob/master/examples/multi_sheet_spreadsheets.rb)
# Axlsx Style Reference
I have compiled a list of all available style options for `axlsx` here: (https://github.com/westonganger/spreadsheet_architect/blob/master/docs/axlsx_styles_reference.md)