public void WriteToExcel(string path, string sheetName, string[,] content)
{
ExcelStream stream = new ExcelStream();
ExcelWriteArgs args = new ExcelWriteArgs();
args.Path = path;
args.SheetName = sheetName;
args.Content = content;
stream.WriteResource(args);
}
private bool WriteExcel(ExcelWriteArgs data)
{
FileInfo newFile = new FileInfo(data.Path);
if (!newFile.Exists)
{
//创建一个新的excel文件
newFile.Delete();
newFile = new FileInfo(data.Path);
using (ExcelPackage package = new ExcelPackage(newFile))
{
//在excel空文件添加新sheet
ExcelWorksheet worksheet = package.Workbook.Worksheets.Add(data.SheetName);
//添加列名
int columnNum = data.Content.GetLength(1);
int rowNum = data.Content.Length / columnNum;
DebugUtils.DebugError(rowNum.ToString());
DebugUtils.DebugError(columnNum.ToString());
for (int i = 0; i < rowNum; i++)
{
for (int j = 0; j < columnNum; j++)
{
worksheet.Cells[i + 4, j + 4].Value = data.Content[i, j];
}
}
//保存excel
package.Save();
}
}
else
{
using (ExcelPackage package = new ExcelPackage(newFile))
{
ExcelWorksheet worksheet = null;
//在excel空文件添加新sheet
for (int i = 1; i <= package.Workbook.Worksheets.Count; i++)
{
if (package.Workbook.Worksheets[i].Name == data.SheetName)
{
worksheet = package.Workbook.Worksheets[i];
break;
}
}
if (worksheet == null)
{
worksheet = package.Workbook.Worksheets.Add(data.SheetName);
}
//添加列名
int columnNum = data.Content.GetLength(1);
int rowNum = data.Content.Length / columnNum;
for (int i = 0; i < rowNum; i++)
{
for (int j = 0; j < columnNum; j++)
{
worksheet.Cells[i + 4, j + 1].Value = data.Content[i, j];
}
}
//保存excel
package.Save();
}
}
return(true);
}
