taking out a range of cells in a .xls with php

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
alienpepsiman
Forum Newbie
Posts: 2
Joined: Fri Sep 25, 2009 4:13 am

taking out a range of cells in a .xls with php

Post 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.
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

Post by Mark Baker »

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

Post 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.
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

Post 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
Post Reply