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

[Anod]

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

[Anod]

虽然是开源的 但是如果商用 有版权问题么

[熙风]

http://blog.csdn.net/happy09li/article/details/7431967

[Anod]

如果用Com组件,如果客户只装了2007/2010 或 2003,那如何创建Excel文件呢?

[lasesiwen]

以下代码需要有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;

[lasesiwen]

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

[卧_槽]

搜索NOPI

[lzc2125]

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

[Anod]

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