80 lines
3.2 KiB
C#
80 lines
3.2 KiB
C#
|
using ExcelDataReader;
|
|||
|
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Data;
|
|||
|
|
using System.IO;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Text;
|
|||
|
|
|
|||
|
|
namespace Io.Github.Kerwinxu.LibShapes.Utils
|
|||
|
|
{
|
|||
|
|
/// <summary>
|
|||
|
|
/// 这个是一个工具类，可以读取excel数据的
|
|||
|
|
/// </summary>
|
|||
|
|
public class ExcelData
|
|||
|
|
{
|
|||
|
|
public static DataTable LoadExcel(string file_path)
|
|||
|
|
{
|
|||
|
|
using (var stream = File.Open(file_path, FileMode.Open, FileAccess.Read))
|
|||
|
|
{
|
|||
|
|
using (var reader = ExcelReaderFactory.CreateReader(stream))
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
// Gets or sets a callback to obtain configuration options for a DataTable.
|
|||
|
|
var conf = new ExcelDataSetConfiguration()
|
|||
|
|
{
|
|||
|
|
// Gets or sets a value indicating whether to set the DataColumn.DataType
|
|||
|
|
// property in a second pass.
|
|||
|
|
UseColumnDataType = true,
|
|||
|
|
|
|||
|
|
// Gets or sets a callback to determine whether to include the current sheet
|
|||
|
|
// in the DataSet. Called once per sheet before ConfigureDataTable.
|
|||
|
|
FilterSheet = (tableReader, sheetIndex) => true,
|
|||
|
|
|
|||
|
|
// Gets or sets a callback to obtain configuration options for a DataTable.
|
|||
|
|
ConfigureDataTable = (tableReader) => new ExcelDataTableConfiguration()
|
|||
|
|
{
|
|||
|
|
// Gets or sets a value indicating the prefix of generated column names.
|
|||
|
|
EmptyColumnNamePrefix = "Column",
|
|||
|
|
|
|||
|
|
// Gets or sets a value indicating whether to use a row from the
|
|||
|
|
// data as column names. 是否使用数据作为列名
|
|||
|
|
UseHeaderRow = true,
|
|||
|
|
|
|||
|
|
//// Gets or sets a callback to determine which row is the header row.
|
|||
|
|
//// Only called when UseHeaderRow = true.
|
|||
|
|
//ReadHeaderRow = (rowReader) =>
|
|||
|
|
//{
|
|||
|
|
// // F.ex skip the first row and use the 2nd row as column headers:
|
|||
|
|
// rowReader.Read();
|
|||
|
|
//},
|
|||
|
|
|
|||
|
|
// Gets or sets a callback to determine whether to include the
|
|||
|
|
// current row in the DataTable.
|
|||
|
|
FilterRow = (rowReader) =>
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
},
|
|||
|
|
|
|||
|
|
// Gets or sets a callback to determine whether to include the specific
|
|||
|
|
// column in the DataTable. Called once per column after reading the
|
|||
|
|
// headers.
|
|||
|
|
FilterColumn = (rowReader, columnIndex) =>
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
};
|
|||
|
|
|
|||
|
|
var ds = reader.AsDataSet(conf);
|
|||
|
|
// 这里方便只是导入第一个
|
|||
|
|
return ds.Tables[0];
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return null;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
