| Import from Excel Strange behaviour [message #511245] |
Fri, 10 June 2011 07:09 |
AzharPro
Messages: 2
Registered: June 2005
|
Junior Member |
|
|
I have created a form to Load Excel file, It is loading O.K at my site. But when i call from Client machine then it is loading every row in single Columns (Attached Screen)
To get Number of Columns i am using this Code.
(Please suggest if their is any other property to get number of columns)
-----------Get Number of Columns
Loop
args := ole2.CREATE_ARGLIST;
ole2.ADD_ARG(args, 1); --row
ole2.ADD_ARG(args, col_cnt); -- col
MyCell := ole2.GET_OBJ_PROPERTY(MySheet, 'Cells', args);
ole2.DESTROY_ARGLIST(args);
lvc_temp_value := ole2.GET_CHAR_PROPERTY(MyCell, 'Text');
Exit when lvc_temp_value is Null;
col_cnt := col_cnt + 1;
End Loop;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
