Problem on using Excel automation in C/AL

Cem_Karaer

Here is the problem: I try to extract data from an Excel sheet by using Excel automation objects, namely Excel application object, worksheet object and range object. But when I encounter an empty cell on the sheet, value property of the range object returns nothing!! C/AL doesn't even execute an assignment statement. How can I handle this? I tried to find if there is any way to check that the return value is null, empty or something like it, I found no function for this.

kriki

Check T370:"Excel Buffer". This table has some code in it to import/export data from/to Excel.
Maybe you can use this to receive the information from Excel. Or maybe in the code in the table, you can find how to do it.

Saalek

Hi

The problem is that Navision doesn't accept NULL values.
Try using Variant variables.

Variant1 := Excell......
Thne, use Variant variable function to know wath type of data is

if variant1.ISINTEGER THEN
begin
end;
if variant1.ISTEXT then
begin
end;

I had similar problen reading access databases and that was my problem solution

Bye

Cem_Karaer

Thank you for your help.