Skip to Content
0
Former Member
Jun 01, 2011 at 03:12 PM

Excel to internal table upload 'ALSM_EXCEL_TO_INTERNAL_TABLE'

73 Views

I need to upload an excel that has data in two formats inside.

First 4 rows have 2 columns each- 1 column with the headings and the second column with the data

Billing Co xxxx

Invoice no. xxxxx

Invoice date 5/31/2011

PO NO. 2100002

5th row is blank

from the 6th row a table with 10 fields of invoice related data and line items

Store Number Store Name Store Address City State Zip code QTY Cost Tax rate Tax

4900 Albertville 6415 Labeaux Ave Albertville MN 55301 1 310 75% 10.68

Initially the excel format was just with the table above and I was using the 'ALSM_EXCEL_TO_INTERNAL_TABLE' fm to upload and performing case statements inside the loop. But, now since the row-column and column-row differs for the two sections, I am unable to differentiate them inside the code. Any suggestions please?