.Net常用技巧_傳入DataGrid直接匯出成Excel

標籤：datagridview   style   blog   color   os   檔案   

註：非調用OFFICE的DLL方法。

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;using Utility;using System.IO;namespace MyTool{    public class SaveAsExcel    {        /// <summary>        /// 存為EXCEL(參數為傳過來的DataGridView表格)        /// </summary>        /// <param name="dgv"></param>        public static void DataGridViewToExcel(DataGridView dgv)        {            SaveFileDialog dlg = new SaveFileDialog();            dlg.Filter = "Execl files (*.xls)|*.xls";            dlg.FilterIndex = 0;            dlg.RestoreDirectory = true;            dlg.CreatePrompt = true;            dlg.Title = "儲存為Excel檔案";            if (dlg.ShowDialog() == DialogResult.OK)            {                Stream myStream;                myStream = dlg.OpenFile();                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));                string columnTitle = "";                try                {                    //寫入欄位標題                    for (int i = 0; i < dgv.ColumnCount; i++)                    {                        if (i > 0)                        {                            columnTitle += "\t";                        }                        columnTitle += dgv.Columns[i].HeaderText;                    }                    sw.WriteLine(columnTitle);                    //寫入列內容                    for (int j = 0; j < dgv.Rows.Count; j++)                    {                        string columnValue = "";                        for (int k = 0; k < dgv.Columns.Count; k++)                        {                            if (k > 0)                            {                                columnValue += "\t";                            }                            if (dgv.Rows[j].Cells[k].Value == null)                                columnValue += "";                            else                                columnValue += dgv.Rows[j].Cells[k].Value.ToString().Trim();                        }                        sw.WriteLine(columnValue);                    }                    sw.Close();                    myStream.Close();                }                catch (Exception e)                {                    MessageBox.Show(e.ToString());                }                finally                {                    sw.Close();                    myStream.Close();                }            }        }    }}