欧美性猛交XXXX免费看蜜桃,成人网18免费韩国,亚洲国产成人精品区综合,欧美日韩一区二区三区高清不卡,亚洲综合一区二区精品久久

using Excel = Microsoft.Office.Interop.Excel;using System.IO;

 //實(shí)例化一個(gè)datatable用來(lái)存儲數據 DataTable dt = new DataTable();
 //指定excel所在路徑 string excelPath = "d:\\1.xlsx"; //可以用來(lái)表示type中的缺省值 //object missing = System.Reflection.Missing.Value; //打開(kāi)excel的時(shí)候可以指定數據類(lèi)型 //如：excel.Application.Workbooks.Open(excelPath,missing,typeof(decimal),typeof(int));
 //打開(kāi)excel文件 Excel.Application excel = new Excel.Application(); Excel.Workbook workbook = excel.Application.Workbooks.Open(excelPath); //獲取所有sheet頁(yè) Excel.Sheets sheets = workbook.Worksheets; //取第一個(gè)sheet Excel.Worksheet sheet = sheets[1]; //獲取excel的列數 int columnCount = sheet.UsedRange.Columns.Count; //獲取excel的行數 int rowCount = sheet.UsedRange.Rows.Count; 
 #region 區域讀取，效率相對較高 //將第一行作為表頭 Excel.Range rangeColumn = sheet.get_Range((Excel.Range)sheet.Cells[1, 1], (Excel.Range)sheet.Cells[1, columnCount]); object[,] arrColumn = rangeColumn.Value as object[,]; foreach (object obj in arrColumn) {     string value = Convert.ToString(obj);     dt.Columns.Add(value); }
 //將所有數據全部讀取出來(lái)。然后轉化為二維數組。 //數據量很多時(shí)可以考慮分批/多線(xiàn)程讀取 Excel.Range rangeRow = sheet.get_Range((Excel.Range)sheet.Cells[2, 1], (Excel.Range)sheet.Cells[rowCount, columnCount]); object[,] arrRow = rangeRow.Value as object[,]; for (int i = 1; i <= arrRow.GetLength(0); i++) {     DataRow dr = dt.NewRow();     for (int c = 1; c <= dt.Columns.Count; c++)     {         string value = Convert.ToString(arrRow[i, c]);         dr[c - 1] = value;     }     dt.Rows.Add(dr); }
 #endregion
 #region 單元格逐個(gè)讀取，效率很低 /* //將第一行作為表頭 for (int j = 1; j <= columnCount; j++) {     string value = Convert.ToString(((Excel.Range)sheet.Cells[1, j]).Value);     dt.Columns.Add(value);
 } for (int i = 2; i <= rowCount; i++) {     DataRow dr = dt.NewRow();     for (int j = 1; j <= columnCount; j++)     {         string value = Convert.ToString(((Excel.Range)sheet.Cells[i, j]).Value);         for (int c = 0; c < dt.Columns.Count; c++)         {             dr[j - 1] = value;         }     }     dt.Rows.Add(dr); } */
 #endregion //釋放資源 workbook.Close(); excel.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excel); GC.Collect(); //若有必要，可以使用Process殺進(jìn)程進(jìn)行資源釋放 //顯示到頁(yè)面 dataGridView1.DataSource = dt;

//修改第二行第二列的數據為Hellosheet.Cells[2, 2] = "Hello";//保存workbook.Save(); //釋放資源 workbook.Close(); excel.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excel); GC.Collect(); //若有必要，可以使用Process殺進(jìn)程進(jìn)行資源釋放