CODEWITHSUNDEEP
.netexcelamazon-web-servicesasp.net-coregoogle-sheets-api
CharithW
CharithW

Reputation: 101

Alternative ways to manipulate excel files in aws lambda

I have a desktop application which takes data by reading an excel sheet so accordingly that we process some data and write them to a new excel file.
So currently we are in process of converting this to a cloud based solution. We are planning to use aws with .net core/nodsjs. I found that handling excels in web servers are pretty hard work. cos either we have to use an COM object or run time somewhere

So what are the solutions that are available options out there to overcome this issue? (Will google spreadsheet will fit in here ?

Thank you

Upvotes: 2

Views: 2298

Answers (1)

Tim Hutchison
Tim Hutchison

Reputation: 3633

I am currently using ClosedXML to read and write excel files. ClosedXML seems to have good documentation, an active development team, and a large set of features. Furthermore, ClosedXML is free. I have not found any other free software for reading Excel that works as well or seems as stable for a production environment. COM is not recommended even by Microsoft because it is slow and has memory leaks.

A client side solution I have also used recently to read data is Papa Parse. Although not an excel solution, this may be an alternative option. Papa parse is a javascript library that provides client side csv parsing and works smoothly.

Upvotes: 2

Related Questions