资源描述：
《导出excel并设置格式通用方法.docx》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、.net导出excel并设置格式2010-12asp教程.net导出excel并设置格式添加引用：microsoftexcel11.0objectlibrary;添加：usingmicrosoft.office.interop.excel;一、打开excel文件＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ microsoft.office.interop.excel.applicationexcel1=newmicrosoft.office.interop.excel.application(); workbookworkbook1
2、=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表＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ mi
4、crosoft.office.interop.excel.applicationexcel1=newmicrosoft.office.interop.excel.application(); workbookworkbook1=excel1.workbooks.add(true); worksheetworksheet1=(worksheet)workbook1.worksheets["sheet1"]; worksheetworksheet1=(worksheet)workbook1.worksheets.add(type.missing,w
5、orkbook1.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并设置格式2010-12 work
6、sheetworksheet1=(worksheet)workbook1.worksheets["sheet1"或1]; worksheet1.name="工作计划表"; excel1.visible=true;五、设置或修改excel表单元格内容＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ microsoft.office.interop.excel.applicationexcel1=newmicrosoft.office.interop.excel.application(); workbookworkbook1=excel1.wor
7、kbooks.add(true); worksheetworksheet1=(worksheet)workbook1.worksheets["sheet1"]; worksheet1.cells[1,1]="姓名"; worksheet1.cells[1,2]="性别"; excel1.visible=true;六、设置excel表行宽和列高＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ microsoft.office.interop.excel.applicationexcel1=newmicrosoft.office.intero
8、p.excel.application(); workbookworkbook1=excel1.workbooks.add(true); worksh
