熊仔的部落格

引用參數

using System.Data.SqlClient;//SQL參數

using Excel = Microsoft.Office.Interop.Excel;// 設定EXCEL參數

using System.Reflection;//匯出資料

using System.IO;

 

//引用EXCEL Application類別

 

Excel._Application myExcel = null;

//引用活頁簿類別

Excel._Workbook myBook = null;

//引用工作表類別

Excel._Worksheet mySheet = null;

//設定EXCEL檔案名稱

string OpenName = "Book1.xls";

//開啟一個新的應用程式

myExcel = new Excel.Application();

//設定EXCEL檔案路徑

myBook = myExcel.Workbooks.Open (System.Windows.Forms.Application.StartupPath + @"\" + OpenName);

//停用警告訊息

myExcel.DisplayAlerts = false;

//讓活頁簿可以看見

myExcel.Visible = true;

//引用第一個活頁簿

myBook = myExcel.Workbooks[1];

//設定活頁簿為焦點

myBook.Activate();

//引用一個工作表

 

mySheet = (Excel._Worksheet)myBook.Worksheets[1];

//設定工作表焦點

mySheet.Activate();

//生成Header

 

for (int i = 0; i < dataGridView1.ColumnCount; i++)

{

mySheet.Cells[1, i + 1] = dataGridView1.Columns[i].HeaderText;

}

//迴圈加入內容

for (int i = 0; i < dataGridView1.RowCount - 1; i++)

{

for (int j = 0; j < dataGridView1.ColumnCount; j++)

{

 

if (dataGridView1[j, i].ValueType == typeof(string))

{

mySheet.Cells[i + 2, j + 1] = "'" + dataGridView1[j, i].Value.ToString();

}

else

{

mySheet.Cells[i + 2, j + 1] = dataGridView1[j, i].Value.ToString();

}

}

}

//設定EXCEL範圍

myRange = mySheet.Range[mySheet.Cells[1, 1], mySheet.Cells[dataGridView1.Rows.Count,

dataGridView1.Columns.Count]];

//設定儲存格框線

myRange.Borders.Weight = Excel.XlBorderWeight.xlThin;

//column自動對齊

myRange.EntireColumn.AutoFit();

//row自動對齊

myRange.EntireRow.AutoFit();