Skip to Content
0

Read Excel file from Network shared folder

Jan 18 at 08:58 AM

106

avatar image
Former Member

There seem to be a few postings on a similar subject, however, none that I can find have any kind of helpful answer/solution.

So, my problem is that I can load an excel file in from a local file using FM TMP_GUI_FILE_OPEN_DIALOG to get the file path/name, followed by FM ALSM_EXCEL_TO_INTERNAL_TABLE to read the excel file, but I am unable to get this to work when reading an excel frim from a shared netwrok folder, it just hangs. I could debug it but that would only tell me where it hangs and would not resolve the issue.

I have also tried using FM KD_GET_FILENAME_ON_F4 to get the file name and then FM TEXT_CONVERT_XLS_TO_SAP as well, but still with no joy.

Is there a way to achieve this?. That is read in an excel file regardless of whether it stored locally or in a shared network folder. Any help or advice would be appreciated.

10 |10000 characters needed characters left characters exceeded

What exactly do you mean by network shared folder? Is it like another drive of your PC, but it just happens to be on a network?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Raymond Giuseppi
Jan 18 at 09:09 AM
-1

AFAIK FMs like EXT_CONVERT_XLS_TO_SAP or ALSM_EXCEL_TO_INTERNAL_TABLE use OLE. so Ms Excel on your workstation/PC must be able to access the file.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for that Raymond. I guess that I should have said that when using Excel I have no problem in accessing and loading the same excel file on a Network shared folder that I am attempting to read in via program.

0

Did you try to set a BRAK-POINT at a statement like

CALL METHOD  OF workbook 'Open'    EXPORTING #1 = filename.

Also look on your workstation/PC for file lock and process excel.exe waiting.

0