ability to read Excel sheets on a AWS S3

Answered

Follow

3

Don Seur

• March 04, 2019 14:22

It would be great if it was possible to have the Excel connector available on AWS s3 platform. We had a case in which XLSX files were seated on the s3. To read data from the xlsx we had to copy the file towards a windows filesystem and then use the Excel connector.

• Comment actions Permalink

  Official comment

  

  Martin Lutzemann

  • March 08, 2019 09:25

  Dear Mr. Seur,

   

  thank you for the request you filed.
  Currently, the scenario you describe is a combination of two different connectors,
  because the S3 access belongs to the category of file-type connectors but Excel spreadsheets need
  a different logic in order to add them as data sources.

  Hence, we encourage you to implement this via a short script,
  which dynamically retrieves the excel file you need, stores it in a specified location on the system
  and then automatically refreshes the corresponding data source.

  It is also possible to add new data sources dynamically based on new spreadsheet files.
  Feel free to contact us, if you need any advise regarding the scripts to implement one of
  the mentioned scenarios.

   

  Best regards,
  Martin Lutzemann

• 1

  Comment actions Permalink

  

  Eralper Yilmaz

  • October 11, 2020 21:14

  Hello,

  Is there a change or a new solution for accessing Excel files stored on AWS S3 buckets?

• 1

  Comment actions Permalink

  

  Niklas Schmidtmer

  • November 05, 2020 12:00

  Hi all,

   

  there have been more requests on this topic lately, so we decided to start investigating options to create an Excel data source based on a file from another filesystem-like data source (such as S3, Azure Blob Storage, SFTP, etc).

  We need to check the technical situation first, I will report back here as soon as we have more details.

   

  Best

   

  Niklas

Please sign in to leave a comment.