Problem with data from Excel file created on Windows 7

General discussion on Zend Server for IBM System i

Problem with data from Excel file created on Windows 7

Postby vsanderson on Thu Dec 06, 2012 9:57 pm

Has anyone esel run into this problem?

I have a PHP program that calls another 'reader.php' script to read the data in an Excel spreadsheet, and write it to an iSeries database file.

This process was working fine before an upgrade to the user's PC where the spreadsheet is produced, from Windows XP to Windows 7. The version of Excel is still the same (2003).

Now, when the PHP program reads the spreadsheet, any columns that have a value produced by a formula show an incorrect value - the leftmost significant digit has been dropped and several digits of accuarcy are tacked on to the right of the number. ie $576.23 becomes $76.234985.

The cell format in the Excel sheets are exactly the ssame when I compare one that worked to one that does not work.

Any clues anyone can provide would be greatly appreciated!

Thanks,

Val
vsanderson
 
Posts: 1
Joined: Thu Dec 06, 2012 9:49 pm

Return to Zend Server for IBM i

Who is online

Users browsing this forum: No registered users and 3 guests