Read Excel file and save details to database using PHP-Repost

How can you read excel file using php and save that details to the database? My other post is describing Read Excel file and save details to database using PHP.But it is not properly working in new version of excel 2007..etc.My readers are asked to do this for other excel versions.So I’m going to show how to read any format of excel file like 97-2003(xls) or 2007 (xlsx) formats excel files. Also I’ll show how to create/write excel file using php.

Continue reading Read Excel file and save details to database using PHP-Repost

Convert xml file into excel file using php

Here we are describing convert xml file into excel file using php.Simple way to convert xml file into excel file with php.If you have basic knowledge of xml and php(:D) this is very easy.My another post is showing how to read Excel file and save details to database using php. If you not good familiar with xml read this PHP Creating XML file post and Read XML file using PHP post to get and better idea.

Continue reading Convert xml file into excel file using php

Read Excel file and save details to database using PHP

How can you read and display excel file using php and save that details to the database? You can use this simple php class to do this.That is read row by row while reading column by column.While reading like this it gets each cells details.Look at this example that is simply describes this process and you can understand this better.

Continue reading Read Excel file and save details to database using PHP

Creating zip files using PHP

How can I compress specific files or compress specific folder or compress bulk files using php.Only you want to add zip class and pass parameters as you want.
This class can be used to create archives of compress files in ZIP format.You can compressed archive to a file instead of a variable when the archive size exceeds a given memory usage threshold.
Also you can add comments to the zip file,rename final zip file,get Archive/zip files size.
Continue reading Creating zip files using PHP