Hi SNEHA MUKHERJEE, You can use Spire.XLS library to easily bind data from excel to datatable. At first, get Spire.xls.dll from NuGet (https://www.nuget.org/packages/Spire.XLS/), then refer to the following code: Workbook workbook = new Workbook(); workbook.Version = ExcelVersion.Version2013; workbook.LoadFromFile(@”..\FandH.xlsx”); Worksheet sheet = workbook.Worksheets[0]; DataTable dt = sheet.ExportDataTable();

Answer

i have a excel sheet with 800 rows and 77 colums . how can i bind those data in datatable using c# console

SNEHA MUKHERJEE

592

Answers (1)

Next Recommended Forum

c# window login form application

K-Way Set Associate Cache: LRC & MRC Implementation

Forum Statistics

Please welcome our newest member Tabago Gto.
3,094,823 users have contributed to 147,394 threads and 483,647
In the past 24 hours, we have 4 new threads, 8 new posts, and 68 new users.
In last week, the most popular thread is 'What is the DISTINCT statement and how do use it'.

Upcoming Events

View all

ChainTalks: The Web3 Spotlight
AI Agents Conference - 2025