110,502
社区成员
发帖
与我相关
我的任务
分享
public static void GenerationExcel(List<List<string>> values)
{
string path = Utils.BasePath + "报表模板/通用报表模板.xls";
string newFilePath=Utils.CopyFile(path,"不知道叫什么.xls");
Office.XlFileFormat version = Office.XlFileFormat.xlExcel9795; //OFFICE 2003
if (path.LastIndexOf("xlsx") > -1) //OFFICE 2007
{
version = Office.XlFileFormat.xlExcel2;
}
Office.Application excel = new Office.Application();
excel.Visible = false;
excel.Application.Workbooks.Add(true);
Office.Workbook wb = excel.Workbooks._Open(newFilePath,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value);
Office.Worksheet sheet = (Office.Worksheet)wb.Sheets[1];
int currentRowNum = 1;
foreach (List<string> list in values)
{
int currentCellNum = 1;
foreach (string item in list)
{
Office.Range cell = (Office.Range)sheet.Cells[currentRowNum, currentCellNum];
cell.Value2 = item;
Console.WriteLine(Missing.Value+"====值====" + item + "===行===" + currentRowNum + "====列====" + currentCellNum);
currentCellNum++;
}
currentRowNum++;
}
excel.DisplayAlerts = false;
try
{
sheet.SaveAs(newFilePath, version, null, null, null, null, null, null, null, null);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
sheet = null;
wb = null;
excel.Quit();
excel = null;
}