Inserting data into Excel using SOI interface and INSERT_ONE_TABLE

[Former Member]

I am using this method to transfer data from an internal table to Excel.

First I read the internal table structure using RFC_GET_STRUCTURE_DEFINITION.

Then I pass in the data to excel using the INSERT_ONE_TABLE method.

The problem I have is that for date entries when the internal table contains an initial value 00000000 this is interpereted by excel in some cases as 1999-11-30 and others as 12:00 am.

Even in debugger if the table field is cleared then in Excel it behaves differently

I would prefer a blank cell.

Rgds

Glenn

Glenn

[Former Member]

Better late than never ...

You could modify the received structure definition and pass problematic fields as text. I.e. pass the data preceded by '.

0000000 --> '0000000

This will qualify the content of the cell as text and Excel won't change the format on it's own.

Regards,

Cornelius