-
StackOverflow 文件
-
epplus 教程
-
儲存 Excel 文件
-
儲存到磁碟
//Using File.WriteAllBytes
using (ExcelPackage excelPackage = new ExcelPackage())
{
//create a new Worksheet
ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1");
//add some text to cell A1
worksheet.Cells["A1"].Value = "My second EPPlus spreadsheet!";
//convert the excel package to a byte array
byte[] bin = excelPackage.GetAsByteArray();
//the path of the file
string filePath = "C:\\ExcelDemo.xlsx";
//or if you use asp.net, get the relative path
filePath = Server.MapPath("ExcelDemo.xlsx");
//write the file to the disk
File.WriteAllBytes(filePath, bin);
//Instead of converting to bytes, you could also use FileInfo
FileInfo fi = new FileInfo(filePath);
excelPackage.SaveAs(fi);
}
//Using SaveAs
using (ExcelPackage excelPackage = new ExcelPackage())
{
//create a new Worksheet
ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1");
//add some text to cell A1
worksheet.Cells["A1"].Value = "My second EPPlus spreadsheet!";
//the path of the file
string filePath = "C:\\ExcelDemo.xlsx";
//or if you use asp.net, get the relative path
filePath = Server.MapPath("ExcelDemo.xlsx");
//Write the file to the disk
FileInfo fi = new FileInfo(filePath);
excelPackage.SaveAs(fi);
}