当前位置：文档之家 › .net 导出excel并设置格式

.net 导出excel并设置格式

  • 格式：docx
  • 大小：21.85 KB
  • 文档页数：5

下载文档原格式

  / 5

合集下载

  1. 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
  2. 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
  3. 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

asp教程.net 导出excel并设置格式

添加引用：microsoft excel 11.0 object library ;

添加：using microsoft.office.interop.excel;

一、打开excel文件＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

microsoft.office.interop.excel.application excel1 = new microsoft.office.interop.excel.application();

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对象＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

microsoft.office.interop.excel.application excel1 = new microsoft.office.interop.excel.application();

workbook workbook1 = excel1.workbooks.add(xlwbatemplate.xlwbatworksheet或true);

worksheet1.activate();//激活sheet1表

excel1.visible = true;

三、新建excel表＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

microsoft.office.interop.excel.application excel1 = new microsoft.office.interop.excel.application();

workbook workbook1 = excel1.workbooks.add(true);

worksheet worksheet1 = (worksheet)workbook1.worksheets["sheet1"];

worksheet worksheet1 =(worksheet)workbook1.worksheets.add(type.missing,workbook1.worksheets[1], 1, type.missing);

excel1.visible = true;

四、重命名excel表名＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

microsoft.office.interop.excel.application excel1 = new microsoft.office.interop.excel.application();

workbook workbook1 = excel1.workbooks.add(true);

worksheet worksheet1 = (worksheet)workbook1.worksheets["sheet1"或1];

= "工作计划表";

excel1.visible = true;

五、设置或修改excel表单元格内容＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝microsoft.office.interop.excel.application excel1 = new microsoft.office.interop.excel.application(); workbook workbook1 = excel1.workbooks.add(true);

worksheet worksheet1 = (worksheet)workbook1.worksheets["sheet1"];

worksheet1.cells[1, 1] = "姓名";

worksheet1.cells[1, 2] = "性别";

excel1.visible = true;

六、设置excel表行宽和列高＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝microsoft.office.interop.excel.application excel1 = new microsoft.office.interop.excel.application(); workbook workbook1 = excel1.workbooks.add(true);

worksheet worksheet1 = (worksheet)workbook1.worksheets["sheet1"];

worksheet1.columns.columnwidth = 20;//全局行宽

worksheet1.columns.rowheight = 20;//全局列高

range range1 = (range) worksheet1.cells[2, 1];

range1.columns.columnwidth = 40;//单元格行宽

range1.columns.rowheight = 40;//单元格列高

excel1.visible = true;

七、设置excel表单元格边框＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝microsoft.office.interop.excel.application excel1 = new microsoft.office.interop.excel.application(); workbook workbook1 = excel1.workbooks.add(true);

worksheet worksheet1 = (worksheet)workbook1.worksheets["sheet1"];

range range1 = (range)worksheet1.cells[2, 2];

range1.borders.color = system.drawing.colortranslator.toole(color.red);