Re: Reading excel via ILE RPG -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

On 2/8/2017 4:07 PM, Englander, Douglas wrote:

We are using Scott Klement's software to read an Excel XLSX spreadsheet. When I bring up the spreadsheet in excel, a cell has a value of .07. However, when I read the cell with the software, it reads 7.0. Other rows in the spreadsheet (above and below this row) read the values correctly for this column.

I am thinking there is something strange with the data in this row, but cannot find it.

Does anyone have any ideas why this one cell/row would be incorrectly read, or how I find anything else to research this?

If it's XLSX, it's packaged up as a ZIP file, despite the extension of
XLSX. Inside that ZIP file are several folders; one of them is called
xl. Inside that is a folder called worksheets. Inside that is an XML
file. Open that with whatever tool you prefer to use for XML - I use
Notepad++ You can then examine the values with the naked eye.

The easiest(?!) way to unzip this is to change the extension from XLSX
to ZIP and then use Windows File Explorer to Extract All...

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.