I have uploaded excel files before and I have no problem doing it. However this time I need to upload a 2D "table" that is in an excel spreadsheet. Below is an example of the "table":
H I J
A 1 2 3
B 4 5 6
C 7 8 9
How can I read the table so that I preserve the row and column values? Basically I need the internal table to be as follows:
data: begin of record occurs 0, col type c, row type c, value type i, end of record.
Then the table would have the following contents:
row = A
col = H
value = 1
row = A
col = I
value = 2
row = A
col = J
value = 3
row = B
col = H
value = 4
etc...
The only way(s) that I know how to upload an excel into a table will give me:
row = 001
col = 001
value = H
row = 001
col = 002
value = I
etc...
Is it possible to do what I am requesting or will the excel sheet need to be reconfigured?
Regards,
Davis