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

533

Answers (1)

Next Recommended Forum

c# window login form application

K-Way Set Associate Cache: LRC & MRC Implementation

Leaderboard

View all

Rodrigo Diaz

-1

Dr Naveen Sharma

+11

Mahesh Chand

View all

Yesterday's leader

Rodrigo Diaz

Software Architecture, Cloud computing, Cloud-native apps, AI, .NET, C#

Mexico

173

13.2k

11k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

186

290.8k

10.5k

500

Upcoming events

View all

The Cloud Show with Magnus Mårtensson ft. Rik Hepworth - Ep: 65
The Cloud Show with Magnus Mårtensson ft. Olena Borzenko - Ep: 64
Coding Secure Software: What Developers Keep Getting Wrong - Code Red: Ep.3

Suggested for you

View all

Naresh Beniwal

Vijay Yadav

Swesh S

Munesh Sharma

Kanchana Jayathilake

Forum Statistics

Please welcome our newest member Jeevanantham V.
3,077,904 users have contributed to 147,418 threads and 483,392
In the past 24 hours, we have 8 new threads, 32 new posts, and 67 new users.
In last week, the most popular thread is 'ItemId is not able to save into the tblQuantities'.