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.
taking out a range of cells in a .xls with php
Moderator: General Moderators
-
alienpepsiman
- Forum Newbie
- Posts: 2
- Joined: Fri Sep 25, 2009 4:13 am
-
Mark Baker
- Forum Regular
- Posts: 710
- Joined: Thu Oct 30, 2008 6:24 pm
Re: taking out a range of cells in a .xls with php
You'll need a library such as PHPExcel that is capable of reading Excel's binary formatted files
-
alienpepsiman
- Forum Newbie
- Posts: 2
- Joined: Fri Sep 25, 2009 4:13 am
Re: taking out a range of cells in a .xls with php
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.
-
Mark Baker
- Forum Regular
- Posts: 710
- Joined: Thu Oct 30, 2008 6:24 pm
Re: taking out a range of cells in a .xls with php
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 italienpepsiman 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.