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.
Henk v.d. Velden
Magda Janssenslaan 36
3584 GR UTRECHT
0031 (0)6 16 024 337
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,
More information about the Use-livecode