importing from an Excel file.

[yusif]

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]

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