use-revolution Digest, Vol 37, Issue 37

Henk van der Velden henk at
Fri Oct 20 06:09:06 EDT 2006

Good day Josep,

Since you are talking about a price list, the simplest way would  
probably be to export the Excel file to a text file - for example a  
tab delimited one. That text file can easily be opened in Rev: just  
put the contents of it into a table field.

If you want to read directly from the .xls file, you will run into a  
lot of difficulties, I think. These files contain lots of data that  
you are probably not interested in, so you have to filter the data.  
And in order to do that, you have to understand the file format.

Kind regards,

Henk v.d. Velden
iGlow Media
Magda Janssenslaan 36

0031 (0)6 16 024 337

On 20-okt-2006, at 10:39, use-revolution-request at wrote:

> From: Josep M Yepes <jmyepes at>
> Date: 19 oktober 2006 19:45:49 GMT+02:00
> To: use-revolution at
> Subject: Reading Excel files on Mac OS X
> Reply-To: How to use Revolution <use-revolution at>
> Hi to all,
> My name is Josep from Barcelona, Spain. I'm new in Revolution and I  
> have a lot of questions in my mind :)
> Now I need to read form a excel file. The excel file is pre- 
> formated with two columns data. It's a price list.
> Any tip to aboard the file? I'm developing on Mac OS X, but the  
> application must be run also on Windows.
> I need to load and insert the data into mySQL table ckecking the  
> data that was changed from the last import.
> Thanks in advance,
> Josep

More information about the Use-livecode mailing list