# \[ANN\] spreadsheet 0.6.0 Released

**URL:** <https://rubytalk.org/t/ann-spreadsheet-0-6-0-released/49608>\
**Category:** ruby-talk\
**Created:** [13 October 2008 13:46 UTC](https://rubytalk.org/t/ann-spreadsheet-0-6-0-released/49608 "2008-10-13T13:46:41Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hannes\_Wyss](https://avatars.discourse-cdn.com/v4/letter/h/e5b9ba/32.png) [@Hannes\_Wyss](https://rubytalk.org/u/Hannes_Wyss)\
**Post date:** [13 October 2008 13:46 UTC](https://rubytalk.org/t/ann-spreadsheet-0-6-0-released/49608/1 "2008-10-13T13:46:41Z")

</div>

spreadsheet version 0.6.0 has been released!

\* \<[http://spreadsheet.rubyforge.org](http://spreadsheet.rubyforge.org)\>

The Spreadsheet Library is designed to read and write Spreadsheet  
Documents. As of version 0.6.0, only Microsoft Excel compatible  
spreadsheets are supported. Spreadsheet is a combination/complete  
rewrite of the Spreadsheet::Excel Library by Daniel J. Berger and the  
ParseExcel Library by Hannes Wyss. Spreadsheet can read, write and  
modify Spreadsheet Documents.

Changes:

### 0.6.0 / 2008-10-13  
Initial upload of the shiny new Spreadsheet Gem after three weeks of  
grueling labor in the dark binary mines of Little-Endian Biff and long  
hours spent polishing the surfaces of documentation:

\* Significantly improved memory-efficiency when reading large Excel  
&nbsp;&nbsp;Files  
\* Limited Spreadsheet modification support  
\* Improved handling of String Encodings  
\* Runs on top of the ruby-ole Library

Roadmap:

0.7.0: Improved Format support/Styles  
0.7.1: Document Modification: Formats/Styles  
0.8.0: Formula Support  
0.8.1: Document Modification: Formulas  
0.9.0: Write-Support: BIFF5  
1.0.0: Ruby 1.9 Support;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Remove backward compatibility code

Backward Compatibility:

Spreadsheet is designed to be a drop-in replacement for both  
ParseExcel and Spreadsheet::Excel. It provides a number of  
require-paths for backward compatibility with its predecessors. If you  
have been working with ParseExcel, you have probably used one or more  
of the following:

&nbsp;&nbsp;require 'parseexcel'  
&nbsp;&nbsp;require 'parseexcel/parseexcel'  
&nbsp;&nbsp;require 'parseexcel/parser'

Either of the above will define the ParseExcel.parse method as a  
facade to Spreadsheet.open. Additionally, this will alter Spreadsheets  
behavior to define the ParseExcel::Worksheet::Cell class and fill each  
parsed Row with instances thereof, which in turn provide ParseExcel's  
Cell#to\_s(encoding) and Cell#date methods.  
You will have to manually uninstall the parseexcel library.

If you are upgrading from Spreadsheet::Excel, you were probably using  
Workbook#add\_worksheet and Worksheet#write, write\_row or write\_column.  
Use the following to load the code which provides them:

&nbsp;&nbsp;require 'spreadsheet/excel'

Again, you will have to manually uninstall the spreadsheet-excel library.

If you perform fancy formatting, you may run into trouble as the  
Format implementation has changed considerably. If that is the case,  
please drop me a line at [hannes.wyss@gmail.com](mailto:hannes.wyss@gmail.com) and I will try to help  
you. Don't forget to include the offending code-snippet!

Enjoy!

Cheers  
Hannes

---

<div class="post-metadata">

**Author:** ![James\_H](https://avatars.discourse-cdn.com/v4/letter/j/9de053/32.png) [@James\_H](https://rubytalk.org/u/James_H)\
**Post date:** [17 October 2008 17:00 UTC](https://rubytalk.org/t/ann-spreadsheet-0-6-0-released/49608/2 "2008-10-17T17:00:00Z")

</div>

ParseExcel mentioned somewhere that it doesn't support formulae. Does  
Spreadsheet?

James

> **···**
>
> On Mon, Oct 13, 2008 at 9:46 AM, Hannes Wyss \<hannes.wyss@gmail.com\> wrote:
> 
> > spreadsheet version 0.6.0 has been released!
> > 
> > \* \<[http://spreadsheet.rubyforge.org](http://spreadsheet.rubyforge.org)\>
> > 
> > The Spreadsheet Library is designed to read and write Spreadsheet  
> > Documents. As of version 0.6.0, only Microsoft Excel compatible  
> > spreadsheets are supported. Spreadsheet is a combination/complete  
> > rewrite of the Spreadsheet::Excel Library by Daniel J. Berger and the  
> > ParseExcel Library by Hannes Wyss. Spreadsheet can read, write and  
> > modify Spreadsheet Documents.
> > 
> > Changes:
> > 
> > ### 0.6.0 / 2008-10-13  
> > Initial upload of the shiny new Spreadsheet Gem after three weeks of  
> > grueling labor in the dark binary mines of Little-Endian Biff and long  
> > hours spent polishing the surfaces of documentation:
> > 
> > \* Significantly improved memory-efficiency when reading large Excel  
> > Files  
> > \* Limited Spreadsheet modification support  
> > \* Improved handling of String Encodings  
> > \* Runs on top of the ruby-ole Library
> > 
> > Roadmap:
> > 
> > 0.7.0: Improved Format support/Styles  
> > 0.7.1: Document Modification: Formats/Styles  
> > 0.8.0: Formula Support  
> > 0.8.1: Document Modification: Formulas  
> > 0.9.0: Write-Support: BIFF5  
> > 1.0.0: Ruby 1.9 Support;  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Remove backward compatibility code
> > 
> > Backward Compatibility:
> > 
> > Spreadsheet is designed to be a drop-in replacement for both  
> > ParseExcel and Spreadsheet::Excel. It provides a number of  
> > require-paths for backward compatibility with its predecessors. If you  
> > have been working with ParseExcel, you have probably used one or more  
> > of the following:
> > 
> > require 'parseexcel'  
> > require 'parseexcel/parseexcel'  
> > require 'parseexcel/parser'
> > 
> > Either of the above will define the ParseExcel.parse method as a  
> > facade to Spreadsheet.open. Additionally, this will alter Spreadsheets  
> > behavior to define the ParseExcel::Worksheet::Cell class and fill each  
> > parsed Row with instances thereof, which in turn provide ParseExcel's  
> > Cell#to\_s(encoding) and Cell#date methods.  
> > You will have to manually uninstall the parseexcel library.
> > 
> > If you are upgrading from Spreadsheet::Excel, you were probably using  
> > Workbook#add\_worksheet and Worksheet#write, write\_row or write\_column.  
> > Use the following to load the code which provides them:
> > 
> > require 'spreadsheet/excel'
> > 
> > Again, you will have to manually uninstall the spreadsheet-excel library.
> > 
> > If you perform fancy formatting, you may run into trouble as the  
> > Format implementation has changed considerably. If that is the case,  
> > please drop me a line at hannes.wyss@gmail.com and I will try to help  
> > you. Don't forget to include the offending code-snippet!
> > 
> > Enjoy!
> > 
> > Cheers  
> > Hannes

---

<div class="post-metadata">

**Author:** ![Emma](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@Emma](https://rubytalk.org/u/Emma)\
**Post date:** [4 December 2008 23:59 UTC](https://rubytalk.org/t/ann-spreadsheet-0-6-0-released/49608/3 "2008-12-04T23:59:07Z")

</div>

Hi, when I do this:

book = Spreadsheet::Workbook.new  
sheet = book.create\_worksheet  
sheet.row(0).replace [1, 2, 3.4]  
book.write "excel.xls"

And open the generated file, Excel show the error: "data could be  
lost", and when it open the sheet it contains a wrong number in cell  
C1... I'm doing something wrong?

(Tested on spreadsheet-0.6.1.9)

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Mark\_Thomas](https://avatars.discourse-cdn.com/v4/letter/m/b5a626/32.png) [@Mark\_Thomas](https://rubytalk.org/u/Mark_Thomas)\
**Post date:** [17 October 2008 17:44 UTC](https://rubytalk.org/t/ann-spreadsheet-0-6-0-released/49608/4 "2008-10-17T17:44:34Z")

</div>

From the above post:

Roadmap:

0.7.0: Improved Format support/Styles  
0.7.1: Document Modification: Formats/Styles  
0.8.0: Formula Support  
0.8.1: Document Modification: Formulas  
0.9.0: Write-Support: BIFF5  
1.0.0: Ruby 1.9 Support;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Remove backward compatibility code

> **···**
>
> On Oct 17, 1:00 pm, James Herdman \<james.herd...@gmail.com\> wrote:
> 
> > [Note: parts of this message were removed to make it a legal post.]
> > 
> > ParseExcel mentioned somewhere that it doesn't support formulae. Does  
> > Spreadsheet?

---

<div class="post-metadata">

**Author:** ![Hannes\_Wyss](https://avatars.discourse-cdn.com/v4/letter/h/e5b9ba/32.png) [@Hannes\_Wyss](https://rubytalk.org/u/Hannes_Wyss)\
**Post date:** [5 December 2008 14:50 UTC](https://rubytalk.org/t/ann-spreadsheet-0-6-0-released/49608/5 "2008-12-05T14:50:21Z")

</div>

Emma,

> **···**
>
> On Fri, Dec 5, 2008 at 12:59 AM, Emma \<emma.sender@gmail.com\> wrote:
> 
> > And open the generated file, Excel show the error: "data could be  
> > lost", and when it open the sheet it contains a wrong number in cell  
> > C1... I'm doing something wrong?
> 
> alas, this is a known issue:  
> [http://rubyforge.org/tracker/index.php?func=detail&aid=22892&group\_id=678&atid=2677](http://rubyforge.org/tracker/index.php?func=detail&aid=22892&group_id=678&atid=2677)
> 
> I'm still working on it, and will get back to you as soon as I've fixed it.
> 
> cheers  
> Hannes

---

<div class="post-metadata">

**Author:** ![James\_H](https://avatars.discourse-cdn.com/v4/letter/j/9de053/32.png) [@James\_H](https://rubytalk.org/u/James_H)\
**Post date:** [17 October 2008 17:51 UTC](https://rubytalk.org/t/ann-spreadsheet-0-6-0-released/49608/6 "2008-10-17T17:51:09Z")

</div>

Hah. Sorry about that. It seems I need to get a stronger cup of coffee.

James

> **···**
>
> On Fri, Oct 17, 2008 at 1:44 PM, Mark Thomas \<mark@thomaszone.com\> wrote:
> 
> > On Oct 17, 1:00 pm, James Herdman \<james.herd...@gmail.com\> wrote:  
> > \> [Note: parts of this message were removed to make it a legal post.]  
> > \>  
> > \> ParseExcel mentioned somewhere that it doesn't support formulae. Does  
> > \> Spreadsheet?
> > 
> > From the above post:
> > 
> > Roadmap:
> > 
> > 0.7.0: Improved Format support/Styles  
> > 0.7.1: Document Modification: Formats/Styles  
> > 0.8.0: Formula Support  
> > 0.8.1: Document Modification: Formulas  
> > 0.9.0: Write-Support: BIFF5  
> > 1.0.0: Ruby 1.9 Support;  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Remove backward compatibility code

---

<div class="post-metadata">

**Author:** ![sumesh\_b](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@sumesh\_b](https://rubytalk.org/u/sumesh_b)\
**Post date:** [4 August 2011 10:49 UTC](https://rubytalk.org/t/ann-spreadsheet-0-6-0-released/49608/7 "2011-08-04T10:49:57Z")

</div>

Hannes Wyss wrote in post #756952:

> Emma,
> 
> > And open the generated file, Excel show the error: "data could be  
> > lost", and when it open the sheet it contains a wrong number in cell  
> > C1... I'm doing something wrong?
> 
> alas, this is a known issue:

[http://rubyforge.org/tracker/index.php?func=detail&aid=22892&group\_id=678&atid=2677](http://rubyforge.org/tracker/index.php?func=detail&aid=22892&group_id=678&atid=2677)

> I'm still working on it, and will get back to you as soon as I've fixed  
> it.
> 
> cheers  
> Hannes

Any updates?

> **···**
>
> > On Fri, Dec 5, 2008 at 12:59 AM, Emma \<emma.sender@gmail.com\> wrote:
> 
> --  
> Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C).

---

<div class="post-metadata">

**Author:** ![Chuck\_Remes](https://avatars.discourse-cdn.com/v4/letter/c/3be4f8/32.png) [@Chuck\_Remes](https://rubytalk.org/u/Chuck_Remes)\
**Post date:** [4 August 2011 13:08 UTC](https://rubytalk.org/t/ann-spreadsheet-0-6-0-released/49608/8 "2011-08-04T13:08:22Z")

</div>

I'm going to teach you how to fish.

If you go to [https://rubygems.org/](https://rubygems.org/) (where pretty much every available gem is listed) you may search for that gem. The results will likely surprise and please you.

cr

> **···**
>
> On Aug 4, 2011, at 5:49 AM, sumesh b. wrote:
> 
> > Hannes Wyss wrote in post #756952:
> > 
> > > Emma,
> > > 
> > > On Fri, Dec 5, 2008 at 12:59 AM, Emma \<emma.sender@gmail.com\> wrote:
> > > 
> > > > And open the generated file, Excel show the error: "data could be  
> > > > lost", and when it open the sheet it contains a wrong number in cell  
> > > > C1... I'm doing something wrong?
> > > 
> > > alas, this is a known issue:
> > 
> > [http://rubyforge.org/tracker/index.php?func=detail&aid=22892&group\_id=678&atid=2677](http://rubyforge.org/tracker/index.php?func=detail&aid=22892&group_id=678&atid=2677)
> > 
> > > I'm still working on it, and will get back to you as soon as I've fixed  
> > > it.
> > > 
> > > cheers  
> > > Hannes
> > 
> > Any updates?
