Skip to Content
0
Former Member
May 09, 2008 at 12:02 PM

Reading Excel File from Application server

50 Views

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