using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DocumentFormat.OpenXml.Packaging;
using System.Data;
using System.IO;
using DocumentFormat.OpenXml.Spreadsheet;
using MS.Internal.Hashing.WindowsBase;
namespace OpenXML
{
class GetDatatable
{
#region
public DataTable GetExcelData(string filePath)
{
return ReadExcel("Sheet1", filePath);
}
/// <summary>
/// 按照给定的Excel流组织成Datatable
/// </summary>
/// <param name="stream">Excel文件流</param>
/// <param name="sheetName">须要读取的Sheet</param>
/// <returns>组织好的DataTable</returns>
private DataTable ReadExcel(string sheetName, string filePath)
{
using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(filePath, false))//从指定的路径读取数据到spreadsheetDocume
OpenXml方式读取Excel数据
最新推荐文章于 2023-08-22 00:01:17 发布