Reading a large excel file at client side(ui5) recommened or server side(ECC)?

[Dashrath_Singh]

Hi Expert,

We have a requirement where we need to read content of large excel sheet. I want experts' help to understand which option is better. Is reading on frontend better or reading on ECC using odata service and then push back to UI to show in one table?

Thanks in advance.

Regards,

Dashrath

[gregorw]

It depends on your exact usecase. If the data needs to end up anyway in the backend you should try out https://github.com/ivanfemia/abap2xlsx.

[maheshpalavalli]

Hi Dashrath,

If you know and have the right library to read the excel sheet, it is better to do it in UI5 app itself simply because it will be a lot faster..

if you send the data to backend, the total time will be the sum of time to send the excel to backend + time to process the excel to internal table + time to read that data to UI5 app via odata service which will be surely high.

BR,

Mahesh

[Dashrath_Singh]

HI Mahesh,

Thanks for guiding me. My problem is, we have huge data some 10-20K records and more. Each row contains some 15-16 columns. So i am not sure if we will face some memory leak issue if we process it on UI. Through oData, we have option to read records in chunks.

Thanks,

Dashrath

[maheshpalavalli]

Not sure about the memory leaks though, if you are sure about it Then you need to persist the data in the backend temp table and process it as gregorw suggested..