VS2005 C# 如何不用com组件生成Excel文件

Anod 2013-11-20 10:06:12

即在未安装office 2007的情况下,使用Microsoft.Office.Tools.Excel如何进行Excel的新建和写,保存.

...全文

270 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

Anod 2013-11-22

打赏
举报

上面那个代码俺会啊... 看来是必须解出来一个Excel的dll了....

lzc2125 2013-11-20

打赏
举报

需要把excel的相关dll给加载进来

卧_槽 2013-11-20

打赏
举报

搜索NOPI

lasesiwen 2013-11-20

打赏
举报

晕，备注都乱码了，忘记截图了

lasesiwen 2013-11-20

打赏
举报

以下代码需要有Excel的Dll Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.ApplicationClass(); app.DefaultFilePath = filepath; //filepath涓烘枃浠剁殑淇濆瓨璺緞 app.DisplayAlerts = true; app.SheetsInNewWorkbook = 1; //Sheet1 Microsoft.Office.Interop.Excel.Workbook book = app.Workbooks.Add(true); //璁剧疆鍒楁爣棰? app.Cells[1, 1] = "鍒?"; app.Cells[1, 2] = ""; app.Cells[1, 3] = ""; //娣诲姞鍐呭 int RowIndex = 2; //琛岀储寮? int ColIndex = 1; //鍒楃储寮? for (int i = 0; i < Temp.Rows.Count; i++) { //璁剧疆姣忎釜鍗曞厓鏍肩殑鍐呭 ColIndex = 1; app.Cells[RowIndex, ColIndex++] = ""; app.Cells[RowIndex, ColIndex++] = ""; app.Cells[RowIndex, ColIndex++] = ""; RowIndex++; } //鍚堣 app.Cells[RowIndex, 1] = "=sum(A2:E" + (RowIndex - 1).ToString() + ")"; app.Cells[RowIndex, 2] = "=sum(B2:H" + (RowIndex - 1).ToString() + ")"; app.Cells[RowIndex, 3] = "=sum(C2:J" + (RowIndex - 1).ToString() + ")"; book.SaveCopyAs(filepath); book = null; app = null;

Anod 2013-11-20