website/index.txt in roo-0.5.4 vs website/index.txt in roo-0.6.0
- old
+ new
@@ -140,10 +140,29 @@
With the YAML output you can import your data in a Ruby on Rails application in a manner that spreadsheet data can accessed in a Rails application.
This is not limited to a Rails application - you can also do further evaluations with your data.
+h3. CSV-Output
+
+You can generate output in csv-format with
+
+<pre>
+<code>
+oo.to_csv
+</code>
+</pre>
+
+to write to the standard output or
+<pre>
+<code>
+oo.to_csv("somefile.txt")
+</code>
+</pre>
+
+to write to a file.
+
h3. Using MS-Excel spreadsheets
You can also access MS-Excel spreadsheat.
Replace Openoffice with
@@ -154,18 +173,15 @@
</pre>
All methode are the same for OpenOffice and Excel-objects. The only difference
is the setting of the default-worksheet. OpenOffice uses the name of the worksheet whereas Excel needs the index of the worksheet (1,2,3,..).
-EDIT: since the release 0.4.2, default_sheet in Excel-object can be handled with names like the Openoffice-sheet.
-
Formulas can only be handled in OpenOffice-spreadsheets.
Features in OpenOffice and Excel:
table(border:1px solid black).
|feature|Open Office|Excel|
-|default_sheet|as name|as number or name (>=0.4.2)|
|formulas|yes|no|
|to_yaml|yes|yes|
Old .sxc OpenOffice files are currently not supported - please load these files and save it as an "OpenDocument Spreadsheet (.ods)".