topic Re: Read Excel file from Network shared folder in Application Development and Automation Discussions

Read Excel file from Network shared folder

gary_king2 — Thu, 18 Jan 2018 08:58:25 GMT

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.

Re: Read Excel file from Network shared folder

matt — Thu, 18 Jan 2018 09:02:53 GMT

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?

Re: Read Excel file from Network shared folder

RaymondGiuseppi — Thu, 18 Jan 2018 09:09:38 GMT

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.

Re: Read Excel file from Network shared folder

gary_king2 — Thu, 18 Jan 2018 09:20:16 GMT

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.

Re: Read Excel file from Network shared folder

RaymondGiuseppi — Thu, 18 Jan 2018 09:42:10 GMT

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.