C# WinForm创建Excel文件

最新推荐文章于 2024-07-26 16:48:19 发布

rztyfx

最新推荐文章于 2024-07-26 16:48:19 发布

阅读量3.4k

点赞数

分类专栏： C# 文章标签： c# excel

本文链接：https://blog.csdn.net/rztyfx/article/details/52411232

版权

private bool creatExcel(string xlsfile)
        {
            try
            {
                object missing = System.Reflection.Missing.Value;
                Excel.ApplicationClass myExcel = new Excel.ApplicationClass();

                Excel._Workbook xBk;                //工作薄 
                Excel._Worksheet xSt;      //工作Sheet    

                xBk = myExcel.Workbooks.Add(true);

                for (int i = 0; i < 1; i++)
                {
                    xSt = (Excel._Worksheet)xBk.ActiveSheet;
                    xSt.Name = "Sheet" + i;
                    myExcel.Sheets.Add(missing, missing, 1, Excel.XlSheetType.xlWorksheet);
                }
                //myExcel.Visible = true;
                if (xlsfile.ToLower().EndsWith(".xlsx"))
                {
                    xBk.SaveAs(xlsfile, 56, missing,
                    missing, missing, missing, Excel.XlSaveAsAcc