CODEWITHSUNDEEP
c#excellambda.net-core
Mike Pennington
Mike Pennington

Reputation: 676

Read excel file using .NET core in aws lambda

I have a .NET Core app running in AWS Lambda. I now have a requirement to read and do some calculations on an Excel file. I've found two libraries for Excel parsing in .NET Core, but each doesn't seem to be able to run in lambda for different reasons:

Do I have any options besides:

  1. Wait for lambda to support .NET Core 2.0
  2. Not use lambda

Thanks.

Upvotes: 2

Views: 2310

Answers (1)

Ashan
Ashan

Reputation: 19758

If you are looking at an alternative option, you can use Google Sheets and API instead of using Excel.

The Google Sheets API can be invoked from Lamda and if there are complex reads and writes, you can also write an App Script in Google Sheet and invoke it also from Lambda.

We were in a similar situation and imported the Excel to Google Sheets and was able to make the calculation work.

Upvotes: 3

Related Questions