作者:乔山办公网日期:
返回目录:excel表格制作
在你的导入事复件中加
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/ms-excel";
因为你没有对制内容进百行编码,所以出来的就度会有乱码问,
试一试,祝你成功!答
excel.Application.Workbooks.Add(true);
这一行改zd成下面专的
Workbook workbook1= excel.Application.Workbooks.Add(true);
Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];
worksheet1.Name = "工作属计划表";
按下ATL+F11,菜单:知插入-模块,复制下面道代码,然后按F5运行。会在最前面回加张总表,显示工作表名答称。
Sub AAA()
Sheets.Add bEFORE:=Sheets(1)
For X = 2 To Sheets.Count
Cells(X - 1, 1) = Sheets(X).Name
Next
End Sub
http://wenku.baidu.com/view/1a0a0d2f4b73f242336c5f7b.html这个百是度用第问三答方版库权