快乐人生

private _Workbook _workBook = null;private Worksheet _workSheet = null;private Excel.Application _excelApplicatin = null;_excelApplicatin = new Excel.Application();_excelApplicatin.Visible = t

Microsoft.Office.Interop.Excel._Worksheet MyWorksheet;MyWorksheet.Cells[1,1] = dgvData.Rows[0].Cells[0].Value.ToString();  //填充星期行内容excell 行和列的索引从1开始，datagridview 行和列的索引从0开始Range range

using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Windows.Forms;using System.Reflection;namespace DMS{/// /// C#操作Excel类/// class E

1、设置显示开发工具选项卡EXCEL顶部图标--Excel选项--常用--选中“在功能区显示开发工具选项卡”2、添加控件3、ALT+F11出现代码编辑窗口，编辑代码

range.NumberFormatLocal = "@";     //设置单元格格式为文本range = (Range)worksheet.get_Range("A1", "E1");     //获取Excel多个单元格区域：本例做为Excel表头range.Merge(0);     //单元格合并动作worksheet.Cells[1, 1] = "Excel单元格赋值";

1.导出xls文件，程序这么写的                        Response.ContentType = "application/vnd.ms-excel";                        Response.AddHeader("Content-Disposition", "attachment; filename=\"vehicle.xls\"");

int colStart = 2;            string ColStartName;             //列大于26时，列名称为（如AB列，28/26=1，char(64+1)=A；28%26=2，char(64+2)=B）            char HStart = (char)(64 + (colStart) / 26);

1、问题2、解决