Skip to Content

Read Excel file from Network shared folder

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.