Member Avatar for eyeda

Hello guys! I'd a problem here. Is there any way that I can download a sheet from an excel file by php? For example,I have this excel file named test.xls,and it have several sheets in it. What i want is to download only a sheet from it. Any suggestion or helps are much appreciated! =)

  • 3 Contributors
  • 3 Replies
  • 197 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by eyeda
Member Avatar for LastMitch

@eyeda

For example,I have this excel file named test.xls,and it have several sheets in it. What i want is to download only a sheet from it. Any suggestion or helps are much appreciated! =)

You need to download the Pear Package for this to work:

http://pear.php.net/package/Spreadsheet_Excel_Writer/download

This is the code that run with the Pear Package

http://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.intro.php

Also you can used this PHPEXCEL:

http://phpexcel.codeplex.com/

commented: To Rectify what some retard did to LastMitch +0
Member Avatar for eyeda

Thank you guys. I'll try to work with it

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.