.net中使用微软类库 导出excel（源代码）

 
/// <summary>
        ///
        /// </summary>
        /// <param name="ds">要导出的DataTable（包含列头）</param>
        /// <param name="strPath">Excel保存地址</param>
        public static void ExportExcelMethod(System.Data.DataTable ds, string strPath)
        {
            if (ds != null && !ds.Equals(""))
            {
                return;
            }

            Excel.ApplicationClass _x = new ApplicationClass();
            Excel.WorkbookClass wb = (Excel.WorkbookClass)_x.Workbooks.Add(System.Reflection.Missing.Value);
            System.Data.DataTable dt = ds;
            for (int i = 0; i < dt.Columns.Count; i++)
            {
                _x.Cells[1, i + 1] = dt.Columns[i].ColumnName;
            }

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    _x.Cells[2 + i, j + 1] = dt.Rows[i][j].ToString();
                }
            }

            wb.Saved = true;
            _x.ActiveWorkbook.SaveCopyAs(strPath);
        }