怎么用代码生成excel文件,其中要生成8张表单(不是默认的sheet1,sheet2...) excel文件默认的sheet1,sheet2...不行吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 从自己程序中粘贴了几行程序,可作为参考。需要注意:1、增加对EXCEL的引用2、using System.Reflection;第一部分:生成空的表格 Excel._Application oExcel = new Excel.ApplicationClass(); oExcel.Visible = false; oExcel.DisplayAlerts = false; Excel._Workbook oWorkbook = (Excel._Workbook)oExcel.Workbooks.Add(Missing.Value); Excel._Worksheet oSheet = (Excel._Worksheet)oWorkbook.Sheets[1]; for(int i= 1; i<=5 ;i ++) { oWorkbook.Sheets.Add(Missing.Value,Missing.Value,Missing.Value,Missing.Value); } for(int i= 1;i <=8 ; i++) { oSheet = (Excel._Worksheet)oWorkbook.Sheets[1]; switch (i) { case 1 : oSheet.Name = "表1"; break; case 2: oSheet.Name = "表2"; break; } } 第二部分:写数据(一个个写,想快一点用数组方式) oSheet.Cells[1,1] = "11"; oSheet.Cells[1,2] = "22"; oSheet.Cells[1,3] = "343"; oSheet.Cells[1,4] = "4"; 第三部分: 调整格式,关闭文件 oRange = oSheet.get_Range("C1",Missing.Value); oRange.EntireColumn.AutoFit(); // 调整列宽 oWorkbook.SaveAs(FileName,Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value,Missing.Value); oExcel.Workbooks.Close(); oWorkbook = null; oExcel.Quit(); oExcel = null; http://www.javasp.net/show.aspx?id=429http://www.javasp.net/show.aspx?id=57http://www.aspx8.com/teach/list.asp?id=278 我需要使用2张网卡连接2台设备,网卡IP不同,设备的IP是一样的,C#下如何使用SOCKET 怎么向字符串中传参? 求教, 子窗体 ShowDialog(), 结果其他所有窗体都被锁定, 无法操作 如何读取xml文件文本? C#.net项目怎么转成VB.net项目? 请问怎么样给图形上色.但还保存图的原样 问你一个逻辑上的问题: 如何在datagrid表格最后一列添加Button按钮 火狐 谷歌 onblur事件找不到 e.clientX 请教关于OleDbCommand的问题 TreeView 操作出错。在线等。。。。。。快来帮个忙,谢谢! Application.Exit()一些问题
需要注意:
1、增加对EXCEL的引用
2、using System.Reflection;第一部分:生成空的表格
Excel._Application oExcel = new Excel.ApplicationClass();
oExcel.Visible = false;
oExcel.DisplayAlerts = false;
Excel._Workbook oWorkbook = (Excel._Workbook)oExcel.Workbooks.Add(Missing.Value);
Excel._Worksheet oSheet = (Excel._Worksheet)oWorkbook.Sheets[1]; for(int i= 1; i<=5 ;i ++)
{
oWorkbook.Sheets.Add(Missing.Value,Missing.Value,Missing.Value,Missing.Value);
} for(int i= 1;i <=8 ; i++)
{
oSheet = (Excel._Worksheet)oWorkbook.Sheets[1];
switch (i)
{
case 1 : oSheet.Name = "表1"; break;
case 2: oSheet.Name = "表2"; break; }
}
第二部分:写数据(一个个写,想快一点用数组方式)
oSheet.Cells[1,1] = "11";
oSheet.Cells[1,2] = "22";
oSheet.Cells[1,3] = "343";
oSheet.Cells[1,4] = "4"; 第三部分: 调整格式,关闭文件
oRange = oSheet.get_Range("C1",Missing.Value);
oRange.EntireColumn.AutoFit(); // 调整列宽
oWorkbook.SaveAs(FileName,Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,Missing.Value);
oExcel.Workbooks.Close();
oWorkbook = null;
oExcel.Quit();
oExcel = null;
http://www.javasp.net/show.aspx?id=429
http://www.javasp.net/show.aspx?id=57
http://www.aspx8.com/teach/list.asp?id=278