bigD Posted November 30, 2010 Share Posted November 30, 2010 Can anyone tell me the best tools to read Excel files? Quote Link to comment https://forums.phpfreaks.com/topic/220209-reading-excel-spreadsheets/ Share on other sites More sharing options...
requinix Posted November 30, 2010 Share Posted November 30, 2010 Probably Microsoft Excel. I hear OpenOffice.org is pretty good too. Quote Link to comment https://forums.phpfreaks.com/topic/220209-reading-excel-spreadsheets/#findComment-1141252 Share on other sites More sharing options...
bigD Posted November 30, 2010 Author Share Posted November 30, 2010 Probably Microsoft Excel. I hear OpenOffice.org is pretty good too. Sorry... I meant using PHP... Quote Link to comment https://forums.phpfreaks.com/topic/220209-reading-excel-spreadsheets/#findComment-1141253 Share on other sites More sharing options...
requinix Posted November 30, 2010 Share Posted November 30, 2010 If you're running on Windows and have Office installed, COM is actually quite nice. Otherwise I've heard good things about PHPExcel. Quote Link to comment https://forums.phpfreaks.com/topic/220209-reading-excel-spreadsheets/#findComment-1141263 Share on other sites More sharing options...
vkgbiz Posted November 30, 2010 Share Posted November 30, 2010 I've attached files with this, use those to read excel files using php. the zip files contains all the samples u needed. if you have any problems in reading date formats then use the PHPExcel_Shared_Date::ExcelToPHP(value) in date.php file. "value" should be in numerals. because excel stores the dates as numeric values. that value should be passed to that function to get the date... for example, convert the date field in excel to a numeric using format option in excel , you will see some numbers in the formatted field. [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/220209-reading-excel-spreadsheets/#findComment-1141299 Share on other sites More sharing options...
bigD Posted December 4, 2010 Author Share Posted December 4, 2010 Thanks guys! It works perfect...... Quote Link to comment https://forums.phpfreaks.com/topic/220209-reading-excel-spreadsheets/#findComment-1142822 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.