Re: creating something M$ Excel can read?

From: Martijn Lievaart <m@xxxxxxxxxxxxxxxx>
Date: Sat, 29 Sep 2007 15:46:12 +0200

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

Mark Hobley wrote:

Mike <mikee@xxxxxxxxxxxx> 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
.

References:
- creating something M$ Excel can read?
  - From: Mike
- Re: creating something M$ Excel can read?
  - From: Mark Hobley
- Re: creating something M$ Excel can read?
  - From: Petr Vileta

Prev by Date: Perl/unix script to convert a fixed width file to a tab delimited file
Next by Date: Re: string concatentation vs. interpolation: which one is more optimal?
Previous by thread: Re: creating something M$ Excel can read?
Next by thread: Problem installing IO::Compress::Base
Index(es):
- Date
- Thread

Relevant Pages

Re: Code looping through files new line
... Why not let your excel code open the original CSV files, ... Otto and I have talking this morning and here are some clarifications about ... Dim fso As Object, fl As Object ...
(microsoft.public.excel.programming)
Re: With excel 2003 could open .csv file but not in excel 2007.
... I didn't know that you were using code to open your .csv files. ... And even though re-registering excel won't help your code, ... Function RowCountYX(ReferenceCell As String, RowOffset As Integer, ColOffset ... Dim Blank As Boolean ...
(microsoft.public.excel.programming)
Re: Linked .csv File Locking
... I have a daily automated job that creates multiple .csv files on a UNIX box, ... There are many users opening and linking to these files via Excel and MS ... multiple users of a read-only .csv file? ...
(microsoft.public.access.security)
Re: Excel loading CSV problem
... We were surprised by the change in functionality after the upgrade. ... Excel has treated 1-31 and 1-23 as dates for as long as I can remember through ... TIW opens for me in 2003 when I open a *.csv file renamed to *.txt ... You might try changing the extension on the CSV files to *.TXT ...
(microsoft.public.excel)
Re: Word Form Fields - Can you Export to Excel Spreadsheet?
... the *.csv files in a folder, importing them one-by-one. ... fine - but you need to ask then in the excel.programming newsgroup. ... compile the data in Excel. ...
(microsoft.public.word.docmanagement)