资源描述：
《导出excel并设置格式通用方法》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。
1、.net导出excel并设置格式2010-12asp教程.net导出excel并设置格式添加引用：microsoftexcel11.0objectlibrary;添加：usingmicrosoft.office.interop.excel;一、打开excel文件＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ microsoft.office.interop.excel.applicationexcel1=newmicrosoft.office.interop.excel.application(); workbookworkbo
2、ok1=excel1.workbooks.open(@"e:aaa.xls",type.missing,type.missing,type.missing,type.missing,type.missing,type.missing,type.missing,type.missing,type.missing,type.missing,type.missing,type.missing,type.missing,type.missing); excel1.visible=true;二、新建excel对象＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
3、＝＝＝＝＝＝＝＝＝＝ microsoft.office.interop.excel.applicationexcel1=newmicrosoft.office.interop.excel.application(); workbookworkbook1=excel1.workbooks.add(xlwbatemplate.xlwbatworksheet或true); worksheet1.activate();//激活sheet1表 excel1.visible=true;三、新建excel表＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
4、＝＝＝＝＝ microsoft.office.interop.excel.applicationexcel1=newmicrosoft.office.interop.excel.application(); workbookworkbook1=excel1.workbooks.add(true); worksheetworksheet1=(worksheet)workbook1.worksheets["sheet1"]; worksheetworksheet1=(worksheet)workbook1.worksheets.add(ty
5、pe.missing,workbook1.worksheets[1],1,type.missing); excel1.visible=true;四、重命名excel表名＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ microsoft.office.interop.excel.applicationexcel1=newmicrosoft.office.interop.excel.application(); workbookworkbook1=excel1.workbooks.add(true);6/6.net导出excel并设
6、置格式2010-12 worksheetworksheet1=(worksheet)workbook1.worksheets["sheet1"或1]; worksheet1.name="工作计划表"; excel1.visible=true;五、设置或修改excel表单元格内容＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ microsoft.office.interop.excel.applicationexcel1=newmicrosoft.office.interop.excel.application(); workbookwo
7、rkbook1=excel1.workbooks.add(true); worksheetworksheet1=(worksheet)workbook1.worksheets["sheet1"]; worksheet1.cells[1,1]="姓名"; worksheet1.cells[1,2]="性别"; excel1.visible=true;六、设置excel表行宽和列高＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ microsoft.office.interop.excel.applicationexcel1=newmi
8、crosoft.office.interop.excel.application(); workbookworkbook1=excel1.workbooks.add(true); worksh
