Skip to Content
author's profile photo Former Member
Former Member

Load .XLS file into BW

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

10 Answers

  • Posted on Dec 05, 2012 at 08:03 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 05, 2012 at 08:05 AM

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

    1. CSV

    2. ASCII

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 05, 2012 at 08:11 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2014 at 07:35 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 23, 2014 at 01:30 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2014 at 04:30 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 23, 2014 at 08:27 AM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2014 at 08:35 AM

    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.


    excel.png (32.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 23, 2014 at 08:35 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 23, 2014 at 09:18 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.