Import Excel (XLS 97-2003) file using ClosedXML in ASP.Net

Question

HiI use imports ClosedXMLExcel to import XLSX filesIs there a version to import XLS 972003 Excel filesthanks

dharmendr · Accepted Answer

Hi  kevinfClosedXML doesnt support Excel 972003 ie xls extension fileIt only supports xlsx extensionSo you have to use OleDB to read the excelRefer below articleUsing SqlBulkCopy to import Excel SpreadSheet data into SQL Server in ASPNet using C and VBNet

Import Excel (XLS 97-2003) file using ClosedXML in ASP.Net

Using SqlBulkCopy to import Excel SpreadSheet data into SQL Server in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us