How to bulk update an Excel spreadsheet data item's stock and price?

Working with Data
1

Hi everyone,

I have thousands of grocery store records in Excel format. I want to update stock and price of all items from excel sheet using C#. What is the best way to bulk update?
Thank you.

2

Hello @Tabish_Alam. Welcome to the MongoDB Community forum.

You are trying to update the Excel spreadsheet data using C#. Do you think MongoDB database and its tools have any use in this process or do you want to use MongoDB database and tools?

As such to read and write form and to Excel spreadsheets using C#, there are libraries like NPOI and IKVM. You can use them directly without any mention of MongoDB.