程式碼:
class Ex{ private EXCEL.Application _app; private EXCEL.Worksheet _sheet; private EXCEL.Workbook _workbook; 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(){ //列 Console.WriteLine(this._sheet.UsedRange.Cells.Columns.Count); //行 Console.WriteLine(this._sheet.UsedRange.Cells.Rows.Count); } }