creating something M$ Excel can read?

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

--
Posted via a free Usenet account from http://www.teranews.com

Re: creating something M$ Excel can read?

Quoth 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?

Spreadsheet::WriteExcel

Ben

Re: creating something M$ Excel can read?

On Sep 28, 11:00 am, Mike wrote:
> 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/Sprea dsheet/WriteExcel.pm

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

HTH,
Mahesh.

Re: creating something M$ Excel can read?

Mike wrote:
> 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/

Re: creating something M$ Excel can read?

In article <3f00t4-61a.ln1@osiris.mauzo.dyndns.org>, Ben Morrow wrote:
>
> Quoth 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?
>
> 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

--
Posted via a free Usenet account from http://www.teranews.com

Re: creating something M$ Excel can read?

In article <46fd7ed5$0$26480$88260bb3@free.teranews.com>,
Mike wrote:
>In article <3f00t4-61a.ln1@osiris.mauzo.dyndns.org>, Ben Morrow wrote:
>>
>> Quoth 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?
>>
>> Spreadsheet::WriteExcel
>
>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

Re: creating something M$ Excel can read?

Mark Hobley wrote:
> Mike wrote:
>> 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.
>
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 ;-)

--

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)

Re: creating something M$ Excel can read?

On Sat, 29 Sep 2007 05:08:09 +0200, Petr Vileta wrote:

> Mark Hobley wrote:
>> Mike wrote:
>>> 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.
>>
> 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