Re-2: OT:converting csv to xls with Rev

runrev260805 at m-r-d.de runrev260805 at m-r-d.de
Wed Jan 9 09:02:27 EST 2008


Hi Xavier,

thanks for your answer.

You are right, Excel can import csv files directly.

But the normal user would double-click on a csv, as the csv-file has an xls-icon under windows systems with excel installed. But this can cause problems, especially with our csv. Our csv-file is structured like this: 01299;Text1;Text2;25;Text3
As you can see, the first column contains numeric data, some  with a leading 0. Opening this file in excel would cut the leading 0 in the first row. And that would cause problems.

 Importing it using the "import-menu" in excel is allways successfull. 
But that means more work for the user. The user wants just to open the file.

That´s why i asked for converting it with Rev/VBS.

Btw: There are various specifications and implementations for the csv format. There´s no real standard. See http://tools.ietf.org/html/rfc4180#section-1




Regards,

Matthias

-------- Original Message --------
Subject: Re: OT:converting csv to xls with Rev (09-Jan-2008 14:27)
From:    xavier.bury at clearstream.com
To:      runrev260805 at m-r-d.de

> Hi Matthias,
> 
> Excel imports csv files directly or tab files (which sql should also 
> export). 
> 
> Learning the cvs for it should not be hard, there's a zillion examples out 
> there. 
> 
> Regards,
> ---------------------=---------------------
> Xavier Bury
> 
> use-revolution-bounces at lists.runrev.com wrote on 09/01/2008 14:08:04:
> 
> To: use-revolution at lists.runrev.com


More information about the use-livecode mailing list