creating something M$ Excel can read?

[Mike]

I want to create a file on linux that is pushed over an apache
connection that excel can open, read, process, etc. This file
is full of monthly project, time sheet type data. I suppose I
could use the Visual Basic for Application, but I'd rather not.
Is there some way to generate a file on linux that contains
formulas, formatting, etc, that can be read by Excel?

Mike

 

[Ben Morrow]

I want to create a file on linux that is pushed over an apache
connection that excel can open, read, process, etc. This file
is full of monthly project, time sheet type data. I suppose I
could use the Visual Basic for Application, but I'd rather not.
Is there some way to generate a file on linux that contains
formulas, formatting, etc, that can be read by Excel?

Spreadsheet::WriteExcel

Ben

 

[Mahesh Asolkar]

I want to create a file on linux that is pushed over an apache
connection that excel can open, read, process, etc. This file
is full of monthly project, time sheet type data. I suppose I
could use the Visual Basic for Application, but I'd rather not.
Is there some way to generate a file on linux that contains
formulas, formatting, etc, that can be read by Excel?

I have used the Spreadsheet::WriteExcel module pretty effective in the
past.

http://search.cpan.org/dist/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel.pm

Spreadsheet:arseExcel is also useful to read data from MS Excel
spreadsheet.

HTH,
Mahesh.

 

[Mark Hobley]

Is there some way to generate a file on linux that contains
formulas, formatting, etc, that can be read by Excel?

Microsoft Excel can read comma separated lists (.csv files). I would create a
test file, and try importing it into Excel.

Mark.

--
Mark Hobley
393 Quinton Road West
QUINTON
Birmingham
B32 1QE

Email: markhobley at hotpop dot donottypethisbit com

http://markhobley.yi.org/

 

[Mike]

Spreadsheet::WriteExcel

Ben

I thought of Spreadsheet::WriteExcel before I posted, but didn't
check it out first. I had it in my head that Spreadsheet::WriteExcel
would not work on linux, only on Windows.

Thanks.

Mike

 

[Gary E. Ansok]

I thought of Spreadsheet::WriteExcel before I posted, but didn't
check it out first. I had it in my head that Spreadsheet::WriteExcel
would not work on linux, only on Windows.

I use Spreadsheet::WriteExcel on a Solaris system to create spreadsheets
served from an Apache server to be downloaded on Windows clients, and
it works very well.

Gary

 

[Martijn Lievaart]

And you can use a little trick. Because Excel is stupid (or
inteiligent?) you can create standard CSV file but name it as *.XLS
Really! Try it ;-)

Works with anything Excel groks. I use html!

However, this does not allow entering formulas, which was requested.

HTH,
M4