BusinessFacade/ExcelControl.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Office.Interop.Excel;
using System.Reflection;
using System.IO;


namespace DAL
{
    public class ExcelControl
    {
        public static bool SaveDataTableToExcel(System.Data.DataTable excelTable, string filePath) 
        {
            Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.ApplicationClass(); 
            try 
            { 
                app.Visible = false; 
                Workbook wBook = app.Workbooks.Add(true); 
                Worksheet wSheet = wBook.Worksheets[1] as Worksheet; 
                if (excelTable.Rows.Count > 0) 
                { 
                    int row = 0; 
                    row = excelTable.Rows.Count; 
                    int col = excelTable.Columns.Count;
                    wSheet.Cells.NumberFormatLocal = "@";
                    for (int i = 0; i < row; i++) 
                    { 
                        for (int j = 0; j < col; j++) 
                        { 
                            string str = excelTable.Rows[i][j].ToString(); 
                            wSheet.Cells[i + 2, j + 1] = str;
                        } 
                    } 
                } 

                int size = excelTable.Columns.Count; 
                for (int i = 0; i < size; i++) 
                { 
                    wSheet.Cells[1, 1 + i] = excelTable.Columns[i].ColumnName; 
                } 
                //设置禁止弹出保存和覆盖的询问提示框 
                app.DisplayAlerts = false; 
                app.AlertBeforeOverwriting = false; 
                //保存工作簿
                wBook.Save(); 
                //保存excel文件 
                app.Save(filePath); 
                app.SaveWorkspace(filePath); 
                app.Quit(); 
                app = null; 
                return true; 
            } 
            catch (Exception err) 
            {
                throw err; 
                return false; 
            } 
        }