public class ExcelHelper
{
/// <summary>
/// 将数据导出为Excel文件
/// </summary>
/// <param name="name">文件名</param>
/// <param name="strList">数据</param>
/// <param name="path">路径,默认D盘根目录</param>
/// <returns></returns>
public string ExportExcel(string name, List<string[]> strList, string path = "D:\\")
{
string documentPath = string.Format($"{path}{name}.xlsx");
var spreadsheetDocument = SpreadsheetDocument.Create(documentPath, SpreadsheetDocumentType.Workbook);
var workbookpart = spreadsheetDocument.AddWorkbookPart();
workbookpart.Workbook = new Workbook();
WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>();
worksheetPart.Worksheet = new Worksheet(new SheetData());
Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild(new Sheets());
Sheet sheet = new Sheet() { Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Sheet1" };
sheets.Append(sheet);
var sheetData = worksheetPart.Worksheet.GetFirstChild<SheetData>();
foreach (var item in strList)
{
Row row = new Row();
foreach (var str in item)
{
Cell dataCell = new Cell
{
CellValue = new CellValue(str),
DataType = new EnumValue<CellValues>(CellValues.String)
};
row.AppendChild(dataCell);
}
sheetData.Append(row);
}
workbookpart.Workbook.Save();
spreadsheetDocument.Close();
return documentPath;
}
/// <summary>
/// 读取Excel文件
/// </summary>
/// <param name="path">文件路径</param>
public List<string[]> ImportExcel(string path)
{
using (SpreadsheetDocument doc = SpreadsheetDocument.Open(path, false))
{
WorkbookPart wbPart = doc.WorkbookPart;
SharedStringTablePart tablePart = wbPart.SharedStringTablePart;
Sheet mysheet = (Sheet)doc.WorkbookPart.Workbook.Sheets.ChildElements.FirstOrDefault();
WorksheetPart worksheet = ((WorksheetPart)wbPart.GetPartById(mysheet.Id));
SheetData sheetData = worksheet.Worksheet.GetFirstChild<SheetData>();
List<string[]> strList = new List<string[]>();
ArrayList arrayList = new ArrayList();
foreach (var row in sheetData.ChildElements)
使用DocumentOpenXML、OfficeOpenXML、NPOI、EpPlus实现导入导出Excel表格
最新推荐文章于 2024-08-08 08:05:08 发布
本文详细介绍了如何利用DocumentOpenXML、OfficeOpenXML、NPOI和EpPlus这四个库进行Excel文件的导入与导出操作。内容涵盖读取数据、写入数据、格式设置等关键步骤,旨在帮助开发者高效处理Excel数据。
摘要由CSDN通过智能技术生成