×
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.
Hi all
i would need some help to undestand where i'm wrong with XLPARSE2 commad.
my scenario is this:
1- I create a xls file in as400 with command SQL2XLS
2- I copy the xls file from Ifs to My pc
3- I open the Xls file in my pc With Excel and then i save it without any
changes
4- I copy the Xls file from my pc to Ifs
5- I Run the XLPARSE2 command and i see the right record ID :
B means "sheet title"
H means "column head
D means "data columns"
see img01 at
http://www.code400.com/forum/showthread.php/13712-Help-with-XLPARSE2
instead, in step 3 if I open the Xls file in my pc With Excel and then for
example i delete all the data rows leaving olny the first and the last row,
when i run the XLPARSE2 command (after having copied again my Xls file
modified from Pc to Ifs) i lost the B ID and the H ID began D see img02 at
http://www.code400.com/forum/showthread.php/13712-Help-with-XLPARSE2
As I'm don't know how to post attached , you can see them at
http://www.code400.com/forum/showthread.php/13712-Help-with-XLPARSE2
can some help where is the problem ?
thanks in advance
XLPARSE2 Date and time of this release : 141103213048
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.
midrange.com
