topic Re: Reading Excel File from Application server in Application Development and Automation Discussions

Reading Excel File from Application server

Former Member — Fri, 09 May 2008 12:02:46 GMT

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,

Re: Reading Excel File from Application server

Former Member — Fri, 09 May 2008 12:08:34 GMT

Hi,

Try using funtion module

GUI_UPLOAD

Reward points if helpful.

Regards,

Mukul Sharma

Re: Reading Excel File from Application server

Former Member — Fri, 09 May 2008 12:16:29 GMT

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

Re: Reading Excel File from Application server

rodrigo_paisante3 — Fri, 09 May 2008 12:37:51 GMT

Hi,

maybe it helps you