SAP BW on HANA how to consume Excel workbook from file server?

[Former Member]

Hi dears,

Is there any solution for o BW on Hana to consume excel files (workbook) from file server?

Can be  across own BW, HANA applications, ABAP or Data Services..? what else...

Does anyone have any ideas?

I Know that there is for local machine source, but in my project is premisse to consume excel files from file server.

I hope on your help..

Regards,

Alexandre Fiel

[former_member206568]

Hi Alexandre,

Do you mean you want to load data from a excel file to BW which exists on the BW application server? If yes, it's possible to load it to BW through flat file source system from the application server.

Thanks!

[Former Member]

Hi Sumit,

But excel file?

I need to read excel with xls extension and workbook, an read the spreadsheets.

In BW Datasource from Flat File source system, we have the options below

When i tried to execute the 2 options, I select the option "AL11"

Then I select the file (excel .xls)

When I display the content, then the error occurs

Thanks

[Former Member]

Hi ,

To upload file to application server, you can try like this:

parameter: fil_loc(128) type c lower case,

                   app_loc(128) type c lower case.

constants: c_width type i value 1000.\

data: l_t_data(c_width) type c occurs 0 with header line,

         l_filename TYPE string,

         filelength type i,

         len type i,

         dat type ref to data.

field-symbols: <dat> type any.

l_filename = fil_loc.

call function 'GUI_UPLOAD'

EXPORTING

filename = l_filename

filetype = 'ASC'

has_field_separator = ''

tables

    data_tab = l_t_data.

AUTHORITY-CHECK OBJECT 'S_DATASET'

                       ID 'PROGRAM' FIELD sy-CPROG

                       ID 'ACTVT' FIELD '34'

                       ID 'FILENAME' FIELD app_loc.

if sy-subrc <> 0.

message i051(rsar) with 'No Authority'.

exit.

endif.

loop at l_t_data.

transfer l_t_data to app_loc.

endloop.

close dataset app_loc.

When you execute it, for fil_loc: give local excel file location

                                   for app_loc: give application server location where you want to upload

to search for application server location, go to al11 transaction

later on you can give that path.

Thanks,

Mukta