Re: Incorrect data returned reading EXCEL worksheet using POS API and XlPares_Workbook

Thanks again.
I did not think to test for overflow.


 
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
  
 






________________________________
From: i5 <i5@xxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Sent: Monday, June 1, 2009 1:48:19 PM
Subject: Re: Incorrect data returned reading EXCEL worksheet using POS API and XlPares_Workbook

And also check against overflown:

fld = mxlsname(column);
wqtmax = *hival;
wqtmim = *loval;
if value < wqtmax and value > wqtmin;
  wqty = %dech(value:16:4);
else;
  / error
endif;


HTH
MarcoF
-------------------------
Original Message:
From: Jeff Young <cooljeff913@xxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Cc:
Date: Monday, June 1 2009 07:28 PM
Subject: Re: Incorrect data returned reading EXCEL worksheet using POS API and XlPares_Workbook
Marco,
Thanks.
I changed my program to use %DECH and it worked.
Question - Do I always need to half adjust when processing a numeric field with decimal values?

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
  
 






________________________________
From: i5 <i5@xxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Sent: Monday, June 1, 2009 12:51:32 PM
Subject: Re: Incorrect data returned reading EXCEL worksheet using POS API and XlPares_Workbook

%DECH

HTH
MarcoF

-------------------------
Original Message:
From: Jeff Young <cooljeff913@xxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxx
Cc:
Date: Monday, June 1 2009 06:28 PM
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