Reading Excel File from Application server

[Former Member]

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

[Former Member]

Hi,

Try using funtion module

GUI_UPLOAD

Reward points if helpful.

Regards,

Mukul Sharma

[Former Member]

hi i had one idea ..

data: wa_file(100) .

open dataset pa_upld for input in text mode.

if sy-subrc = 0.

do.

read dataset pa_upld into wa_file.

if sy-subrc <> 0.

exit.

endif.

split wa_file at '#' into field1 field2 field3 field4 .

itab-field1 = field1.

itab-field2 = field2.

itab-field3 = field3.

itab-field4 = field4.

append itab.

enddo.

close dataset pa_upld.

endif.

regards,

venkat

[rodrigo_paisante3]

Hi,

maybe it helps you