[問題]從Data Grid view 作EXCE 讀寫存檔

看板C_Sharp (C#)作者cowuabc (阿辰)時間7年前 (2018/07/03 14:18)推噓1(1推 0噓 0→)

留言1則, 1人參與討論串1/1

想請問各路高手..小弟在Data gridview 想做原有excel 的檔案讀取/編輯/儲存但是每次儲存後,開啟Excel 都會是Data gridview 裡面顯示的格式... 想請問各位高手有沒有辦法可以作保持原有excel 的格式又可以在Datagridview 作編輯以及寫入原有格式...下列是小弟的練習sample... SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.Filter = "Text files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; saveFileDialog1.Title = "Save as"; saveFileDialog1.ShowDialog(); // System.IO.FileStream fs = (System.IO.FileStream)saveFileDialog1.OpenFile(); //switch(saveFileDialog1.FilterIndex) { Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; Int16 i, j; xlApp = new Excel.ApplicationClass(); xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); for (i = 0; i <= dataGridView1.RowCount - 2; i++) { for (j = 0; j <= dataGridView1.ColumnCount - 1; j++) { xlWorkSheet.Cells[i + 1, j + 1] = dataGridView1[j, i].Value.ToString(); } } xlWorkBook.SaveAs(saveFileDialog1.FileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); releaseObject(xlWorkSheet); releaseObject(xlWorkBook); releaseObject(xlApp); -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 211.23.76.67 ※ 文章網址: https://www.ptt.cc/bbs/C_Sharp/M.1530598715.A.042.html