Hi Jeff
Expand that numeric column in the excel spreadsheet to 3 decimal places
Does the 1.38 become 1.376
The spreadsheet may have rounding to the nearest
This message was sent from my BlackBerry
My BlackBerry number is 631 880 8640
----- Original Message -----
From: Jeff Young [cooljeff913@xxxxxxxxx]
Sent: 06/01/2009 09:15 AM MST
To: rpg400-l@xxxxxxxxxxxx
Subject: Incorrect data returned reading EXCEL worksheet using POS API and XlPares_Workbook
I have an EXCEL worksheet where I amÂselecting specific columns to process in my program.
One of these columns is a numeric column defined with 2 decimal position.
On the worksheet, I have the following values:
1.38-
20.97-
11.44-
0.84
0.80
In my program, I am receiving the following values:
1.37-
20.96-
11.44-
0.83
0.79
Â
The PI for my numeric processing subproceedure is :
D NumberCellÂÂÂÂÂ PIÂÂÂÂÂÂÂÂÂÂÂÂ 1NÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ
DÂÂ SheetÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 1024AÂÂ Varying ConstÂÂÂÂÂÂ
DÂÂ RowÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 10I 0 ValueÂÂÂÂÂÂÂÂÂÂÂÂÂÂ
DÂÂ ColumnÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 5I 0 ValueÂÂÂÂÂÂÂÂÂÂÂÂÂÂ
DÂÂ ValueÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 8FÂÂ ValueÂÂÂÂÂÂÂÂÂÂÂÂÂÂ
The actual instruction to retreive the data from the cell is :
AdjVarAmt = %Dec(Value : 11 : 2);
The field AdjVarAmt is defined in my program as TYPE = PACKED(11,2)
Does anyone have any explanation as to why this is happening?
I am on V5R3M0
Thanks,
Jeff Young
Sr. Programmer Analyst
IBMÂ-e(logo) serverÂCertified Systems ExperÂ- iSeries Technical Solutions V5R2Â
IBMÂ Certified Specialist-Âe(logo)ÂserverÂi5Series Technical Solutions DesignerÂV5R3
IBMÂ Certified Specialist- e(logo)server i5Series Technical SolutionsÂImplementerÂV5R3
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
