Dear professionals,
i have problem with exporting data from form to Excel.
If any row in any column contain NULL value form freeze, and with the "Task manager" i could see that Excel.exe process is running, but there is no open Excel files. Along with opening any Excel file from computer file Book1 opens, and inside are few first rows which columns doesn't contain NULL value...
So, my question is: how to overcome "NULL values in columns" problem during exporting data from Form to Excel.
Here is code segment...
args:=CLIENT_OLE2.CREATE_ARGLIST;
CLIENT_OLE2.ADD_ARG(args, row_n+1);
synchronize;
CLIENT_OLE2.ADD_ARG(args, col_n);
cell:=CLIENT_OLE2.GET_OBJ_PROPERTY(worksheet, 'Cells', args);
CLIENT_OLE2.DESTROY_ARGLIST(args);
IF get_item_property(item_name,DATATYPE)<>'NUMBER' THEN
CLIENT_OLE2.SET_PROPERTY(cell, 'NumberFormat', '@');
END IF;
CLIENT_OLE2.SET_PROPERTY(cell, 'Value', name_in(item_name));
CLIENT_OLE2.RELEASE_OBJ(cell);
Thanks in advance, Adnan
edit: on this link some guy had identical problem, but without solving proposal
1355667
Edited by: adnanBIH on Jun 7, 2011 1:28 PM