用C#生成Excel报表

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› Node.js›Node.js教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

//连接excel数据源
            string filePath = this.openFileDialog1.FileName;
            OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ filePath + ";Extended Properties=\"Excel 8.0;\"");
            conn.Open();

//建立Excel应用(写Excel Sheet之前)
            Microsoft.Office.Interop.Excel.ApplicationClass oExcel;
            oExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();
            oExcel.UserControl = false;
            Microsoft.Office.Interop.Excel.WorkbookClass wb = (Microsoft.Office.Interop.Excel.WorkbookClass)oExcel.Workbooks.Add(System.Reflection.Missing.Value);

//新建一个Sheet,新建后会默认处于焦点状态

wb.Worksheets.Add(Missing.Value, Missing.Value, 1, Missing.Value);

//写单元格示例

oExcel.Cells[1, 1] = "第一列";
oExcel.Cells[1, 2] = "第二列";
oExcel.Cells[1, 3] = "第三列";

//保存工作簿

wb.Saved = true;

//生成文件，释放资源

oExcel.ActiveWorkbook.SaveCopyAs(filename);
oExcel.Quit();
System.GC.Collect();