use-revolution Digest, Vol 37, Issue 37

Henk van der Velden henk at iglow-media.nl
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
--------------------------
Henk v.d. Velden
iGlow Media
Magda Janssenslaan 36
3584 GR  UTRECHT
Netherlands

0031 (0)6 16 024 337
www.iglow-media.nl



On 20-okt-2006, at 10:39, use-revolution-request at lists.runrev.com wrote:

> From: Josep M Yepes <jmyepes at mac.com>
> Date: 19 oktober 2006 19:45:49 GMT+02:00
> To: use-revolution at lists.runrev.com
> Subject: Reading Excel files on Mac OS X
> Reply-To: How to use Revolution <use-revolution at lists.runrev.com>
>
>
> 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