CODEWITHSUNDEEP
c#asp.net-mvclinq-to-excel
plasteezy
plasteezy

Reputation: 317

How do I use LinqToExcel to get the sheet names of an Excel file?

I am using LinqToExcel. I want to be able to get the names of all sheets in an Excel file and compare them with an input value from my html form such that when the input value does not match any of the names on the Excel sheet, the system throws an exception. How do I go about using LinqToExcel to do this?

Upvotes: 4

Views: 8107

Answers (2)

bensonissac
bensonissac

Reputation: 695

using LinqToExcel;


filename = FileUpload1.FileName;
FileUpload1.SaveAs(Server.MapPath("~/Excelfiles/"+filename));
var xl = new ExcelQueryFactory(Server.MapPath("~/Excelfiles/" + filename));
var worksheetNames = xl.GetWorksheetNames();           
DropDownList2.DataSource = worksheetNames;
DropDownList2.DataBind();

Upvotes: 1

driis
driis

Reputation: 164281

The documentation says:

The GetWorksheetNames() method can be used to retrieve the list of worksheet names in a spreadsheet.

var excel = new ExcelQueryFactory("excelFileName");
var worksheetNames = excel.GetWorksheetNames();

Upvotes: 17

Related Questions