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

695

1 Visual Basic .NET

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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)