class Ex{
private EXCEL.Application _app;
private EXCEL.Worksheet _sheet;
private EXCEL.Workbook _workbook;
private int _rowCount = 5;
private int _columnCount = 5;
public Ex(String fileName){
//調用EXCEL
this._app = new EXCEL.Application();
//隱藏EXCEL
this._app.Visible = false;
//開啟檔案
this._workbook = this._app.Workbooks.Open(fileName, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing);
this._sheet = (EXCEL.Worksheet)_workbook.Worksheets[1];
}
public void Show(){
var cells = this._sheet.Cells;
for (int r = 1; r <= _rowCount; r++) {
for (int c = 1; c <= _columnCount; c++){
//初始行列為1
var content = (Object)(cells[r, c] as EXCEL.Range).Value;
if (content != null)
if (String.IsNullOrEmpty(content.ToString()) != true)
Console.WriteLine(content);
}
}
}
}
2016/06/15
C#.Net 讀取行列資料
程式碼: