熊仔的部落格

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
this.button1.Click +=new EventHandler(button1_Click);

//使用ComboBox加入數字1~9
for (int i = 1; i <= 9; i++)
{
comboBox1.Items.Add(i);
comboBox2.Items.Add(i);
//讓起始值固定在數字1，
comboBox1.SelectedIndex = 0;
comboBox2.SelectedIndex = 0;
}
}
void button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();

//加入column欄位
dt.Columns.Add("Columns1", typeof(int));
dt.Columns.Add("Columns2", typeof(int));
dt.Columns.Add("Columns3", typeof(int));

//DataTable資料來源為dt
dataGridView1.DataSource = dt;
//使用迴圈將數字輸入到DataGridView

for (int i = 1; i <= int.Parse(comboBox1.Text); i++)

{

for (int j = 1; j <= int.Parse(comboBox2.Text); j++)

{

DataRow row;

row = dt.NewRow();
row["Columns1"] = i;
row["Columns2"] =j;
row["Columns3"] = i*j;
dt.Rows.Add(row);
}

}
}
}
}

引用參數

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();