How to read excel file(kept on desktop) without browsing it(without file uploader) in UI5?

[Former Member]

Hello Experts,

My aim is to create some graphs in UI5 using the data present in an excel sheet on local system. This excel sheet is automatically updated every 30 seconds and that is why I cannot use a file browser to read this file. I want UI5 application to read it automatically at specific intervals. I am using Eclipse oxygen to create this application with XML views. Please suggest me how can it be achieved.

Regards,

Abhishek Tyagi

[former_member484715]

Hi Abhishek Tyagi,

To upload an static excel file,

• Try using the exceljs plugin. It is very helpfull.
• You can use the simpleExceljs plugin also.

Regards,

Arjun Biswas.

[iftah_peretz]

Hey,

The file needs to be on the backend server. If you are using ABAP as your backend then this would be the application server.

I don't think you can read (without upload) from the frontend system. If you want to read it from the frontend system, you'd need to have a listner on that computer that would send that data to your backend server.

[Former Member]

Hey,

Thanks for your answer.

I am using eclipse and I can keep my excel file in one of the folders under "Web Content". Would that work?

[iftah_peretz]

You want to read that excel file from your "Web Content" folder and you are using eclipse to the develop the app, right?