C# 使用 SpreadsheetGear 生成Excel文件

最新推荐文章于 2021-07-24 09:43:07 发布

weixin_30463341

最新推荐文章于 2021-07-24 09:43:07 发布

阅读量888

点赞数

文章标签： c#

原文链接：http://www.cnblogs.com/footmark/p/11010901.html

版权

               string filePath = AppDomain.CurrentDomain.BaseDirectory + @"datafile\temp.xlsx"; 
               System.IO.File.Create(filePath).Close(); //创建一个excel文件
           
                FileStream fs = new FileStream(filePath, FileMode.Open);
                IWorkbookSet workbookSet = Factory.GetWorkbookSet();
                IWorkbook workbook = workbookSet.Workbooks.OpenFromStream(fs);
                fs.Close();

                IWorksheet worksheet = workbook.Worksheets[0];
                worksheet.Name = "RFQ Replies";  //为sheet1重命名
                IRange cells = worksheet.Cells;
                cells[0,1].Value = "给第一行第二列的单元格复制"
                cells[0, 1].ColumnWidth = 70; //列宽
                string outputFilePath = AppDomain.CurrentDomain.BaseDirectory + @"datafile\";
                string singleName = "Excel " + DateTime.Now.ToChinaTime().ToString("dd_MM-yyyy HH_mm") + ".xlsx";
                workbook.SaveAs(outputFilePath + singleName, FileFormat.OpenXMLWorkbook);//保存为一个新文件
                System.IO.File.Delete(filePath); //删除之前的文件