c#excel导出

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Collections;

namespace Tech.Web.Common
{
    public class DataToExcel
    {
        //生成Excel文件的代码
        public void ExportExcel(DataSet ds ,ArrayList names,ArrayList values,string fileName)
        {
            string desktop = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
            Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
            Microsoft.Office.Interop.Excel.Workbook wb = excel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);    // 创建工作簿
            Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1];                          // 创建工作页
            //读取临时文件
            int iMaxRow = ds.Tables[0].Rows.Count;
            int iMaxCol = names.Count;

            // 设置标题
            for (int i = 0; i < names.Count; i++)
            {              
                excel.Cells[1, i+1] = names[i].ToString();
            }


            // 填充数据
            for (int iRow = 0; iRow < iMaxRow; iRow++)
            {
                for (int iCol = 0; iCol < iMaxCol; iCol++)
                {
                    excel.Cells[iRow + 2, iCol + 1] = ds.Tables[0].Rows[iRow][values[iCol].ToString()].ToString();
                }
            }
            // 保存Excel
            wb.SaveAs(desktop+"\\"+fileName+".xlsx");
            wb.Close();
        }
    }
}

用这个方法时，要注意excel的引用。