Hi all,
I have a requirement which is really challenging for all
1) I have a file in excel format in application server. i need to download in internal table.
2)Excel file is " # " delimied and cannot be in any other format.
format of excel sheet is as follows:
coloum2
coloum3
Row1 | | |
Row2 | | |
Row3 | | |
coloum2
coloum3
coloum4
coloum5
Row1 | | | | |
Row2 | | | | |
Row3 | | | | |
3) I need to take all data along with coloum heading and row heading in to internal table. and
for eg: change the data in Row 2 only .
note row and coloums specifically should not to be of fixed length, should be dynamic as per the excel sheet.
4) After the manupulation is over need to get the ouput in EXCEL format in the same workbook but in two different worksheets.
kindly suggest..........maximum points will be rewarded
Regards,
AJ