Reading Data from xls to php

drumdogg · 12 Dec 2012 at 09:03

Hi Guys, i have been trying to read a single cell value from a spreadsheet into php. I can only seem to read a whole file but not a specific cell.

Have read about using phpExcelReader. Would that be alone the right lines to get started?

Thanks

drumdogg · 13 Dec 2012 at 13:50

Can anyone point me in the right direction please?

visibleman · 13 Dec 2012 at 14:17

phpExcelReader should do what you're after, otherwise have a look at http://phpexcel.codeplex.com/ which allows you to read an Excel file and extract data from cells (need to create a data filter class for the reader; it's all in the documentation with examples anyway).

Xelene · 13 Dec 2012 at 21:58

Open xls file in Excel. Save as CSV.

drumdogg · 14 Dec 2012 at 09:35

phpExcelReader should do what you're after, otherwise have a look at http://phpexcel.codeplex.com/ which allows you to read an Excel file and extract data from cells (need to create a data filter class for the reader; it's all in the documentation with examples anyway).

Thanks, wont get a good look at this for a few days but cheers

drumdogg · 21 Dec 2012 at 09:13

This might be a silly question guys, but how do i set up the phpexcel reader. What files and folders do i put into my directory etc.

Cheers