资源描述:
《导出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