资源描述:
《导出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(); workbookworkboo
2、k1=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(type.m
5、issing,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); worksheetworksheet1=
6、(worksheet)workbook1.worksheets["sheet1"或1];beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedontheterminalstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacin
7、gisgenerally100mm;branchofficesshallbebindingonbothends,eachcore5/5.net导出excel并设置格式2010-12 worksheet1.name="工作计划表"; excel1.visible=true;五、设置或修改excel表单元格内容======================== microsoft.office.interop.excel.applicationexcel1=newmicrosoft.office.interop.excel.application
8、(); workbookworkbook1=excel1.workbooks.add(true); worksheetworksheet1=(worksheet)workbook