vs2005生成excel

1. using System;
2. using System.Data;
3. using System.Configuration;
4. using System.Collections;
5. using System.Web;
6. using System.Web.Security;
7. using System.Web.UI;
8. using System.Web.UI.WebControls;
9. using System.Web.UI.WebControls.WebParts;
10. using System.Web.UI.HtmlControls;
11. using Excel=Microsoft.Office.Interop.Excel;
12. using System.Text;
13. using System.IO;
14. using System.Reflection;
17. public partial class workbook : System.Web.UI.Page
18. {
19.     protected void Page_Load(object sender, EventArgs e)
20.     {
21.         CreateExcel();
23.     }
24.     private void CreateExcel()
25.     {
26.         //ExcelOperate excelOperate = new ExcelOperate();
27.         Excel.Application app = new Excel.Application();
28.         if (app == null)
29.         {
30.             return;
31.         }
32.         app.Visible = false;
33.         app.UserControl = true;
34.         Excel.Workbooks workbooks = app.Workbooks; //工作薄集合
35.         Excel._Workbook workbook = workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);//这里的Add方法里的参数就相当于继承了一个空模板(暂这样理解吧) 工作薄
36.         Excel.Sheets sheets = workbook.Worksheets;//工作表集合
37.         Excel._Worksheet worksheet = (Excel._Worksheet)sheets.get_Item(1);//工作表
38.         worksheet.Copy(Missing.Value,workbook.Sheets.get_Item(1)); //复制工作表
39.         worksheet.Copy(Missing.Value, worksheet);//复制工作表
40.         Excel._Worksheet worksheet1= (Excel._Worksheet)sheets.get_Item(2);//工作表2
41.        
42.         worksheet1.Name = "工作表2";
43.         if (worksheet == null)
44.         {
45.             return;
46.         }
48.         worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, 4]).Merge(Missing.Value); //横向合并
49.         worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, 1]).Value2 = "导出EXCEL测试一";
51.         //excelOperate.SetBold(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1]); //黑体
52.         //excelOperate.SetHAlignCenter(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1]);//居中
53.         //excelOperate.SetBgColor(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1], System.Drawing.Color.Red);//背景色
54.         //excelOperate.SetFontSize(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1], 16);//字体大小
55.         //excelOperate.SetRowHeight(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1], 32.25);//行高
56.         worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, 1]).Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);//黑色连续边框
58.         worksheet.Cells[2, 1] = "序号";
59.         worksheet.Cells[2, 2] = "公司";
60.         worksheet.Cells[2, 3] = "部门";
61.         //excelOperate.SetBold(worksheet, worksheet.Cells[2, 1], worksheet.Cells[2, 3]); //黑体
62.         worksheet.get_Range(worksheet.Cells[2, 1], worksheet.Cells[2, 3]).Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);
63.         //excelOperate.SetHAlignRight(worksheet, worksheet.Cells[2, 1], worksheet.Cells[2, 3]);
64.         //excelOperate.SetBgColor(worksheet, worksheet.Cells[2, 1], worksheet.Cells[2, 3], System.Drawing.Color.Silver);//背景色
65.         int rowNum = 0;
66.         //for (int i = 0; i < dv.Count; i++)
67.         //{
68.         int i = 0;
69.             rowNum = i + 1;
70.             worksheet.Cells[3 + i, 1] = 1;
71.             worksheet.Cells[3 + i, 2] = "test";
72.             worksheet.Cells[3 + i, 3] = "测试12345";
74.             //excelOperate.SetBold(worksheet, worksheet.Cells[3 + i, 1], worksheet.Cells[3 + i, 1]); //黑体
75.             //excelOperate.SetHAlignCenter(worksheet, worksheet.Cells[3 + i, 1], worksheet.Cells[3 + i, 3]);//居中
76.             worksheet.get_Range(worksheet.Cells[3 + i, 1], worksheet.Cells[3 + i, 3]).Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);//设置边框颜色，不然打印预览，会非常不雅观
78.         //}
79.         //excelOperate.SetColumnWidth(worksheet, "A", 10);
80.         //excelOperate.SetColumnWidth(worksheet, "B", 20);
81.         //excelOperate.SetColumnWidth(worksheet, "C", 20);
83.             worksheet.get_Range(worksheet.Cells[4, 1], worksheet.Cells[5, 1]).Merge(Missing.Value); //纵向合并
84.             worksheet.get_Range(worksheet.Cells[4, 1], worksheet.Cells[5, 1]).Value2 = "测试纵向合并";
85.             worksheet.get_Range(worksheet.Cells[4, 1], worksheet.Cells[5, 1]).Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);
86.           
87.         worksheet.Name = "导出EXCEL测试一"; //表命名
88.         
90.         worksheet1.get_Range(worksheet1.Cells[1,1],worksheet1.Cells[1,4]).Merge(Missing.Value);
91.         worksheet1.get_Range(worksheet1.Cells[1,1],worksheet1.Cells[1,4]).Value2="工作表2";
92.         worksheet1.get_Range(worksheet1.Cells[1, 1], worksheet1.Cells[1, 4]).Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);
94.         string tick = DateTime.Now.Ticks.ToString();
95.         
96.         //save_path = temp_path + "//" + tick + ".xls";
97.         string save_path = "~/"+tick + ".xls";
98.         workbook.SaveAs(Server.MapPath(save_path),Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
99.         //excelOperate.Dispose(worksheet, workbook, app);//关闭Excel进程
100.         app.Quit();
101.     }
102.       
103.     
104. }