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

Reading Excel File from Application Server

Former Member — Mon, 28 Dec 2009 10:50:47 GMT

hello,

I have an excel file on the application server which I have to read and process. I can do this with open dataset but my problem is the excel file has header data (names of the fields) in each column. Is there any way to skip the header row from the excel file when reading from the application server.

Thanks for your help

Re: Reading Excel File from Application Server

BH2408 — Mon, 28 Dec 2009 11:09:21 GMT

Hi,

Header line will be there at once only , so read from the second record i.e consider that header line is one record.

Read the file and if no record found exit the loop.

READ DATASET physical file INTO temp table.

Always the first record of the application server file is Header line.
So header line is skiping

IF sy-index = 1.

CONTINUE.

ENDIF.

Regards,

Bharani

Re: Reading Excel File from Application Server

Former Member — Mon, 28 Dec 2009 15:59:01 GMT

Hi Dishant,

Do not consider the first line in your internal table when you read it from file.

or you can delete it by using index = 1.

Hope this helps you.

Re: Reading Excel File from Application Server

kesavadas_thekkillath — Mon, 28 Dec 2009 16:04:46 GMT

Why cant you read the whole and skip the first line while processing ?

check this link

Re: Reading Excel File from Application Server

Former Member — Tue, 30 Nov 2010 16:03:20 GMT

requirement changed.

Re: Reading Excel File from Application Server

Former Member — Wed, 09 Feb 2011 13:38:52 GMT

Hi Dinesh

How u read .XLS file from Application Server, Can u send me Code Sample