Inserting data into Excel using SOI interface and INSERT_ONE_TABLE
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.