如何从Excel获取工作表名称 [英] How to get sheet name from Excel
本文介绍了如何从Excel获取工作表名称的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何从Excel中获取工作表名称并将其添加到我的comboBox列表中?我似乎无法像在public static
How do I get sheet name from Excel and add them to my comboBox list? I can't seem to add it in my code as it is in public static
public static DataTable ExcelToDataTable (string fileName)
{
using (var stream = File.Open(fileName, FileMode.Open, FileAccess.Read))
{
using (var reader = ExcelReaderFactory.CreateReader(stream))
{
var result = reader.AsDataSet(new ExcelDataSetConfiguration()
{
UseColumnDataType = true,
ConfigureDataTable = (data) => new ExcelDataTableConfiguration()
{
UseHeaderRow = true
}
});
DataTableCollection table = result.Tables;
DataTable resultTable = table["Sheet1"];
return resultTable;
}
}
}
推荐答案
如果我了解您的需求!您可以使用以下代码:
If I understand what you want! you can use this code:
var sheetNames = result.Tables
.OfType<DataTable>()
.Select(c => c.TableName)
.ToArray();
这篇关于如何从Excel获取工作表名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文