Load .XLS file into BW

[Former Member]

Dear Experts,

Is it possible to load .XLS file type into BW system via infopackage?

I have tried to load XLS filetype with no success. I'm wondering why it's not uploading.

Any help in this regard is deeply appreciated.

Br,

H

[former_member182516]

Yes its possible in BW7.3 versoin to load the flat file of type .XLS.

You can check the FM SAP_CONVERT_TO_CSV_FORMAT

Regards

KP

[Former Member]

FM : SAP_CONVERT_TO_CSV_FORMAT

is not in my BW 73105 system.

However the DTP option adapter : EXCEL Load Microsoft Excel file (XLS) from local station

Exist.

Regards FMC

[former_member209728]

I think first of all you need to convert your .XLS file to .csv and store it on the application server.

There is a FM FILE_READ_AND_CONVERT_SAP_DATA which can read data from .XLS file BUT ONLY FROM A PRESENTATION SERVER(but still double check on this).Pass 'XLS' to I_FILEFORMAT.

This FM will put the contents of your .XLS in to a internal table, which you can write to a .csv file easily using DATASET.

[ravi_chandra3]

Hi Kush,

There is no such FM to convert the .XLS  file to .CSV in the application server.The only possibility i think is by writing DataSet.

Please correct me if i were wrong..

Regards,
RaviChandra.

[former_member209728]

HI Tanka,

Yes you are right even i don't know of any. What i was trying to tell was to use the above mentioned FM to read a xls file from presentation server and write it to application server via dataset. Also it can not be scheduled as a background job.

Thanks,

Kush

[ravi_chandra3]

Hi Kush,

DataSet program is used to read/write the data from the file which is present in the application server.

If we want to read the data from the presentation then we can use the GUI_DOWNLOAD FM.

[former_member209728]

Hi Tanka,

There are always many methods to do a particular task and one should evaluate all the possibilities before deciding on one based on what suits you . 🙂

I had used the FM FILE_READ_AND_CONVERT_SAP_DATA some longtime back so don't remember exactly what i did.

Check

http://scn.sap.com/thread/1234997

Thanks,

Kush

[ravi_chandra3]

Hi Kush,

Everything is possible in BI.

Recently i faced this issue, i have solved it by using the DataSet  Logic.

[Former Member]

You can upload Excel sheets without converting it first to CSV.

Go to your datasource, extraction tab:

Choose 'Load Microsoft Excel File (XLS) from Local Workstation'

Select the file name and the sheet to be extracted. These should be stored onto your local machine.

Next, create an InfoPackage and it will automatically select the file to be extracted as setup in the datasource.

[ravi_chandra3]

Hi harish,

Before creating the datasource on the top of the .xls flat file, write one dataset program to convert the .xls to .csv file and then create the datasource on the top of this .csv file.

DataSet program to load the data from .xls to .csv will have more complexity, because in my previous we have faced this situation.

Directly we can't create datasource on .XLS file.

Hope u got it,

[Former Member]

Hi,

Loading the XLS from flat file will be availble from 7.3 or hiher version,

give the file location path etc...and also there is option for selecting perticular sheet from excel sheet as well.

Regards,

Chandra.

[KodandaPani_KV]

Hi Harish,

you can laod XLS files in BW 7.3 version.

Adaptor- load microsoft excel file (XLS) from local work station.

File name - xxxx

sheet to be extracted-  xxxxx

header rows to be ignored- 1.

Thanks,

Phani.

[Former Member]

You can load XLS files in BW 7.3 or higher, but the file should be in your PC, not in server.

[RamanKorrapati]

Hi Harish,

For CSV format at infopack external tab screen

provide these details

File name:

Fily type:

Data Separator

Escape Sign  

Number of header rows to be ignored 1

regards

[RamanKorrapati]

As i know, we load data into Bw in two formats,

1. CSV

2. ASCII

regards

[Former Member]

Hi KR,

Thanks for your reply.

I know we can load CSV, TXT and ASCII and binary format. But we have to load XLS format as we require no manual intervention and Business is not willing to provide files other than XLS.

Br,

H

[former_member182470]

Hi Harish,

It's not possible till 7.0. But it may be possible from 7.3 on wards.

If you are in 7.0, you must convert your file into CSV before uploading to BW.

Regards,

Suman

[RamanKorrapati]

Hi Harish,

its flat file loading.. about XLS no idea.

if possible, save file into CSV format, try to load using info pack,

as CSV format

you need to give, coma separated value  and delimiter.

header rows to be ignored : 1

regards