importing from an Excel file.

Archived from the Xataface Users forum.

yusif — Mon Aug 06, 2007 7:53 am

Hi Steve,
I read your documentation on importing excelxml file. I whether the same procedure could be used for an ordinary excel sheet.
Thanks in advance
Yusif

---

shannah — Mon Aug 06, 2007 9:19 pm

Hi Yusif,

A similar technique could be used for importing from an ordinary excel sheet.Ê The example in the docs, unfortunately, used a buggy excel spreadsheet reader class that I have since given up on.Ê There is a much better PEAR class (http://pear.php.net/package/Structures_DataGrid_DataSource_Excel) for reading excel spreadsheets.ÊÊ This class will read native (binary) excel files (i.e. .xls files).

You would still have to write your own import filter, but following the examples in the docs, this shouldn’t be too hard.

-Steve