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?