Create a new excel file

How to create a new excel file in ruby with examples .

With your bare hands and a computer usually.

Jayanth

On Fri, Jun 19, 2009 at 10:32 AM, Vetrivel V. <

Vetrivel V. [email protected] wrote:

How to create a new excel file in ruby with examples .

Depends what system you’re running. There’s one way on Windows and a
different way on Mac OS X. m.

Funny you mention this. I myself was trying to remember what I need to
export to Excel and I was about to do the whole thing in CSV (might
still do anyway, since Excel has support for it) when this came
through. Thanks!

On Fri, Jun 19, 2009 at 1:50 PM, Daniel B.[email protected]
wrote:

How to create a new excel file in ruby with examples .
Dan


Rilindo F.
AOL Instant Messenger: rilindo
Google Talk: [email protected]
Web S.: http://www.monzell.com
Primary: [email protected]
Secondary: [email protected]
"Rich bachelors should be heavily taxed. It is not fair that some men
should be happier than others. – Oscar Wilde

Depends what system you’re running. There’s one way on Windows and a
different way on Mac OS X. m.

No, actually, the spreadsheet gem is cross-platform.

gem install spreadsheet.

Regards,

Dan

Daniel B. [email protected] wrote:

Depends what system you’re running. There’s one way on Windows and a
different way on Mac OS X. m.

No, actually, the spreadsheet gem is cross-platform.

Ooops, sorry about that. Okay, I guess what I meant is that there’s also
at least one way on Mac OS X that doesn’t exist on Windows. On Mac OS X
you could do it with rb-appscript; that’s what my book manuscript is
about here:

http://www.apeth.com/ruby/10examples.html

The “Microsoft Excel” section on that page includes an example where we
create a new Excel document, populate it with some data, and tell Excel
to draw a chart. m.