website/index.html in roo-0.4.1 vs website/index.html in roo-0.5.0
- old
+ new
@@ -31,11 +31,11 @@
<div id="main">
<h1>roo</h1>
<div id="version" class="clickable" onclick='document.location = "http://rubyforge.org/projects/roo"; return false'>
Get Version
- <a href="http://rubyforge.org/projects/roo" class="numbers">0.4.1</a>
+ <a href="http://rubyforge.org/projects/roo" class="numbers">0.5.0</a>
</div>
<h2>What</h2>
<p>This gem allows you to access the content of open-office and Excel spreadsheets (.ods/.xls).</p>
@@ -135,38 +135,62 @@
<code>
4.upto(oo.last_row) do |line|
</code>
</pre>
+ <h3>Cell Types</h3>
+
+
+ <p>oo.<strong>celltype</strong>(row,col) returns the type of a cell. Currently these types will be
+returned:</p>
+
+
+ <ul>
+ <li>:float</li>
+ <li>:string</li>
+ <li>:date</li>
+ <li>:percentage</li>
+ <li>:formula</li>
+ </ul>
+
+
<h3>Formulas</h3>
<p>Formulas in Openoffice-Spreadsheets can be handled.</p>
- <p>oo.celltype(row,col) returns :formula if there is a formula in this cell.</p>
+ <p>oo.<strong>celltype</strong>(row,col) returns :formula if there is a formula in this cell.</p>
- <p>oo.formula?(row,col) returns true if there is a formula</p>
+ <p>oo.<strong>formula?</strong>(row,col) returns true if there is a formula</p>
- <p>oo.formula(row,col) returns the formula in this cell in a string variable (like ”=<acronym title="[.A1:.M13]">SUM</acronym>”). You can do whatever you want with this expression.
+ <p>oo.<strong>formula</strong>(row,col) returns the formula in this cell in a string variable (like ”=<acronym title="[.A1:.M13]">SUM</acronym>”). You can do whatever you want with this expression.
If there is no formula in this cell nil is returned.</p>
- <p>oo.cell(row,col) returns the computed result of the formula (as it was saved in the file, no recalculation is done in this Gem).</p>
+ <p>oo.<strong>cell</strong>(row,col) returns the computed result of the formula (as it was saved in the file, no recalculation is done in this Gem).</p>
- <p>oo.formulas returns all formulas in the selected spreadsheet in an array like this:</p>
+ <p>oo.<strong>formulas</strong> returns all formulas in the selected spreadsheet in an array like this:</p>
- <p>Each entry consists of the elements row, col, formual.</p>
+<pre>
+<code>
+ [[1,2,"=SUM(.A1:.B1)"],
+ [1,3,"=SIN(.C3)"],
+ [1,4,"=COS(.D4)"]]
+</code>
+</pre>
+ <p>Each entry consists of the elements row, col, formula.</p>
- <p>Note: oo.cell(row,col) is the same for ordinary cells and formulas. So you can use the computated value of a formula. If you have to distinguish if a cell is a formula use #formula?</p>
+ <p>Note: oo.<strong>cell</strong>(row,col) is the same for ordinary cells and formulas. So you can use the computated value of a formula. If you have to distinguish if a cell is a formula use #<strong>formula</strong>?</p>
+
<p>Please note: formulas in Excel-Spreadsheets cannot be handled (this is another gem, see: “Thanks”)</p>
<h3><span class="caps">YAML</span>-Output</h3>
@@ -204,10 +228,13 @@
<p>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,..).</p>
+ <p><span class="caps">EDIT</span>: since the release 0.4.2, default_sheet in Excel-object can be handled with names like the Openoffice-sheet.</p>
+
+
<p>Formulas can only be handled in OpenOffice-spreadsheets.</p>
<p>Features in OpenOffice and Excel:</p>
@@ -219,11 +246,11 @@
<td>Excel</td>
</tr>
<tr>
<td>default_sheet</td>
<td>as name</td>
- <td>as number</td>
+ <td>as number or name (>=0.4.2)</td>
</tr>
<tr>
<td>formulas</td>
<td>yes</td>
<td>no</td>
@@ -236,13 +263,20 @@
</table>
- <p>Old .sxc OpenOffice files are currently not supported – please load these files and save as an “OpenDocument Spreadsheet (.ods)”.</p>
+ <p>Old .sxc OpenOffice files are currently not supported – please load these files and save it as an “OpenDocument Spreadsheet (.ods)”.</p>
+ <h3>Remote Access</h3>
+
+
+ <p>You can even access your spreadsheet data from a remote machine via <span class="caps">SOAP</span>. The examples directory shows a little example how to do this. If you like, you can extend these functions or restrict the access to certain cells.
+Remote access with <span class="caps">SOAP</span> is nothing specific to roo, you can do this with every Rub object, but i thought it would nice to give an example what could be done with roo.</p>
+
+
<h2>Where is it used?</h2>
<p>How do you use roo? What are you doing with roo?</p>
@@ -283,10 +317,19 @@
<p><a href="http://roo.rubyforge.org/wiki/wiki.pl">http://roo.rubyforge.org/wiki/wiki.pl</a></p>
+ <h2>How to submit patches</h2>
+
+
+ <p>Read the <a href="http://drnicwilliams.com/2007/06/01/8-steps-for-fixing-other-peoples-code/">8 steps for fixing other people’s code</a> and for section <a href="http://drnicwilliams.com/2007/06/01/8-steps-for-fixing-other-peoples-code/#8b-google-groups">8b: Submit patch to Google Groups</a>, use the Google Group above.</p>
+
+
+ <p>The trunk repository is <code>svn://rubyforge.org/var/svn/gorank/trunk</code> for anonymous access.</p>
+
+
<h2>License</h2>
<p>This code is free to use under the terms of Ruby</p>
@@ -300,14 +343,14 @@
<h2>Thanks</h2>
<ul>
<li><a href="http://rubyforge.org/users/nicwilliams/">Dr Nic Williams</a> for his wonderful gem ‘<a href="http://rubyforge.org/projects/newgem/">newgem</a>’ which makes it very convenient to create, manage and publish Ruby gems</li>
- <li>for the Excel-part the “spreadsheet’:http://rubyforge.org/projects/spreadsheet/ gem is used. My functions are a convenient wrapper around the functions of this gem</li>
+ <li>for the Excel-part the <a href="http://rubyforge.org/projects/spreadsheet/">spreadsheet</a> gem is used. My functions are a convenient wrapper around the functions of this gem</li>
<li>Dirk Huth fürs Testen unter Windows</li>
</ul>
<p class="coda">
- <a href="mailto:drnicwilliams@gmail.com">Dr Nic</a>, 27th June 2007<br>
+ <a href="mailto:drnicwilliams@gmail.com">Dr Nic</a>, 20th July 2007<br>
Theme extended from <a href="http://rb2js.rubyforge.org/">Paul Battley</a>
</p>
</div>
<!-- insert site tracking codes here, like Google Urchin -->