Retrieve Data from Excel File Using C#

Fri, 15 Sep 2023 19:20:00 GMT

We can retrieve the data from the Excel file using two ways:

1. OLeDb Connection

2. Interop Library

Here we are going to use Interop Library.

We have a list of contacts in an Excel file named (Contacts.xlsx) with their Record ID, the scenario here is to retrieve the ID from Excel then use the ID to fetch the record from CRM and update the Contacts field “AE Assigned” to yes.

Blog - Retrieve Row from Excel

Retrieve Data from Excel File Using C#