topic Re: READ DATA in Application Development and Automation Discussions

READ DATA

Former Member — Wed, 23 Apr 2008 19:06:07 GMT

Can we read data horizontally(in an excel Sheet) through a BDCprogram??

Please help me out

Thanks in advance.

Former Member — Wed, 23 Apr 2008 19:19:43 GMT

Hi,

we can using a functional module TEXT_CONVERT_XLS_TO_SAP which will get the data from excel into sap.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 23, 2008 5:15 PM

Former Member — Wed, 23 Apr 2008 19:21:37 GMT

Another FM.

ALSM_EXCEL_TO_INTERNAL_TABLE

This FM reads each and every Cell of Excel step by step.

Former Member — Wed, 23 Apr 2008 19:27:33 GMT

hi Malloc Lee ,

use function module ALSM_EXCEL_TO_INTERNAL_TABLE

it reads the data horizontally only.

<REMOVED BY MODERATOR>

Thanks and regards.

Rajeshwar.

Edited by: Alvaro Tejada Galindo on Apr 23, 2008 5:16 PM

Former Member — Wed, 23 Apr 2008 21:50:52 GMT

hi,

1) Use the function module:ALSM_EXCEL_TO_INTERNAL_TABLE.

2) specify the file location.

3) enter the row and the column where the data is starting, in the excel.

4) we can avoid the header row and column, if the excel has any header.

5) this funciton module reads the data horizontally.

Thanks

Anitha T S

Former Member — Sat, 26 Apr 2008 18:08:41 GMT

Save the excel file as a text file.

Then your progr can read it in and populate an internal table.

Former Member — Sat, 26 Apr 2008 18:10:06 GMT

Save the excel file as a text file.

Then your progr can read it in and populate an internal table.