Skip to Content
0
Sep 07, 2007 at 03:39 PM

Uploading a 2-D excel "table"

10 Views

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