Page 1 of 1
taking out a range of cells in a .xls with php
Posted: Fri Sep 25, 2009 4:20 am
by alienpepsiman
HI, I just started learning php and was wondering if I can use php to take a range of cells out of a .xls file. I wanted to take out cells D3 to D100 and store it in an array. Then take out E3 to E100 and store it in an array.
Thanks for any help you can give.
Re: taking out a range of cells in a .xls with php
Posted: Fri Sep 25, 2009 7:07 am
by Mark Baker
You'll need a library such as
PHPExcel that is capable of reading Excel's binary formatted files
Re: taking out a range of cells in a .xls with php
Posted: Wed Oct 07, 2009 1:30 pm
by alienpepsiman
Thank you so much I am looking at the library right now. But there are a couple of things i do not understand about the using it.
Re: taking out a range of cells in a .xls with php
Posted: Wed Oct 07, 2009 3:23 pm
by Mark Baker
alienpepsiman wrote:Thank you so much I am looking at the library right now. But there are a couple of things i do not understand about the using it.
Can't help much unless I know what those couple of things are, but there's plenty of examples in the Tests directory that can show you how to use it