README.md in simple-spreadsheet-0.0.5.2 vs README.md in simple-spreadsheet-0.0.5.3
- old
+ new
@@ -1,8 +1,8 @@
# Simple Spreadsheet
-Recently a wrote a module to import raw data from Excel-like files to database and export it in various formats. To accomplish this i have to use different gems with different usage patterns so I decide to wrap them in a single simple gem. This is a spreadsheet reader and writer that (will) supports common formats: CSV (.csv), Excel (.xls, .xlsx), Open-office (.ods) and Google (online).
+Recently I wrote a module to import raw data from Excel-like files to database and export it in various formats. To accomplish this i have to use different gems with different usage patterns so I decide to wrap them in a single simple gem. This is a spreadsheet reader and writer that (will) supports common formats: CSV (.csv), Excel (.xls, .xlsx), Open-office (.ods) and Google (online).
Used gems:
- Roo (http://roo.rubyforge.org/)
- Spreadsheet (http://spreadsheet.ch/)
@@ -53,10 +53,12 @@
## Recipes
### Get all data from some cols of first sheet of a XLS file
```ruby
+require "simple-spreadsheet"
+
s = SimpleSpreadsheet::Workbook.read("my_spreadsheets_file.xls")
s.select_worksheet = s.sheets.first
s.first_row.upto(@workbook.last_row) do |line|
data1 = s.cell(line, 1)
data2 = s.cell(line, 3)
@@ -64,9 +66,11 @@
```
### Get all data from some cols of first sheet of a XLS file (option 2)
```ruby
+require "simple-spreadsheet"
+
s = SimpleSpreadsheet::Workbook.read("my_spreadsheets_file.xls")
s.first_row.upto(@workbook.last_row) do |line|
data1 = s.cell(line, 1, 1)
data2 = s.cell(line, 3, 1)
end