导出excel并设置格式通用方法
5页1、asp教程.net 导出excel并设置格式添加引用:microsoft excel 11.0 object library ;添加:using ;一、打开excel文件 excel1 = new (); workbook workbook1 = 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对象 excel1 = new (); workbook workbook1 = excel1.workbooks.add(xlwbatemplate.xlwbatworksheet或true); worksheet1.activ
2、ate();/激活sheet1表 excel1.visible = true;三、新建excel表 excel1 = new (); workbook workbook1 = excel1.workbooks.add(true); worksheet worksheet1 = (worksheet)workbook1.worksheetssheet1; worksheet worksheet1 =(worksheet)workbook1.worksheets.add(type.missing,workbook1.worksheets1, 1, type.missing); excel1.visible = true;四、重命名excel表名 excel1 = new (); workbook workbook1 = excel1.workbooks.add(true); worksheet worksheet1 = (worksheet)workbook1.worksheetssheet1或1; worksheet1.name = 工作计划表; excel1.visible = tru
3、e;五、设置或修改excel表单元格内容 excel1 = new (); workbook workbook1 = excel1.workbooks.add(true); worksheet worksheet1 = (worksheet)workbook1.worksheetssheet1; worksheet1.cells1, 1 = 姓名; worksheet1.cells1, 2 = 性别; excel1.visible = true;六、设置excel表行宽和列高 excel1 = new (); workbook workbook1 = excel1.workbooks.add(true); worksheet worksheet1 = (worksheet)workbook1.worksheetssheet1; worksheet1.columns.columnwidth = 20;/全局行宽 worksheet1.columns.rowheight = 20;/全局列高 range range1 = (range) worksheet1.cells2, 1; rang
4、e1.columns.columnwidth = 40;/单元格行宽 range1.columns.rowheight = 40;/单元格列高 excel1.visible = true;七、设置excel表单元格边框 excel1 = new (); workbook workbook1 = excel1.workbooks.add(true); worksheet worksheet1 = (worksheet)workbook1.worksheetssheet1; range range1 = (range)worksheet1.cells2, 2; range1.borders.color = (color.red);item(xlbordersindex.xledgetop).linestyle = xllinestyle.xlcontinuous;item(xlbordersindex.xledgeright).linestyle = xllinestyle.xlcontinuous;item(xlbordersindex.xledgebottom).linestyle =
《导出excel并设置格式通用方法》由会员汽***分享,可在线阅读,更多相关《导出excel并设置格式通用方法》请在金锄头文库上搜索。
高三数学一模试卷
煤矿应急救援指挥机构管理机构组织机构及管理职责
智力障碍儿童感知觉发展
污水处理施工方案
谜语小游戏谜语谜底
巴西铁矿石购销合同英语
公司销售员工工作计划标准范本(四篇).doc
以面层底面弯拉应力为控制指标的沥青路面可靠性分析[资料]
小学五年级语文教案少年闰土
二语复习教案
票房及分成常识
发客户邮件的格式范文6篇
舟山关于成立精密轴公司可行性报告(参考范文)
探索语文多媒体教学课件的评价标准
2023年教师转正述职报告_2
镇江消费电子功能性产品项目申请报告(参考模板)
工程造价实习鉴定
扬州市房地产抵押按揭合同书
恐艾症产生的原因及脱恐方法
新病案首页填写范例及填写说明
2023-02-19 3页
2023-09-11 2页
2024-01-30 11页
2023-02-12 1页
2023-02-02 3页
2022-08-01 7页
2022-08-24 85页
2024-01-22 2页
2023-01-16 6页
2023-08-04 12页