private void button2_Click(object sender, EventArgs e)
{
Excel.Application objApp = new Excel.Application(); //实例化Excle对象
Excel.Workbooks workbooks = objApp.Workbooks;//实例化工作簿
object missing = Missing.Value;
workbooks.Open(@"d:\\ceshi.xls", missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);//打开Excle表的模板
objSheet = (Excel._Worksheet)objSheets.get_Item(1);//导出sheet1模板
for (int i = 0; i <10; i++)
{
objApp.Cells[9 + i, 1] = i.ToString();//dataGridView2["GetDate", i].Value;
objApp.
{
Excel.Application objApp = new Excel.Application(); //实例化Excle对象
Excel.Workbooks workbooks = objApp.Workbooks;//实例化工作簿
object missing = Missing.Value;
workbooks.Open(@"d:\\ceshi.xls", missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);//打开Excle表的模板
Excel.Sheets objSheets = objApp.Worksheets;//实例化sheet工作表的集合
Excel._Worksheet objSheet;objSheet = (Excel._Worksheet)objSheets.get_Item(1);//导出sheet1模板
for (int i = 0; i <10; i++)
{
objApp.Cells[9 + i, 1] = i.ToString();//dataGridView2["GetDate", i].Value;
objApp.