如何使用.NET wrapper for MS Office了解Excel文件单元格计数

using Microsoft.Office.Interop.Excel;

// 创建Excel应用程序对象
Application excelApp = new Application();

// 打开Excel文件
Workbook workbook = excelApp.Workbooks.Open("path_to_excel_file");

// 获取第一个工作表
Worksheet worksheet = workbook.Worksheets[1];

// 获取单元格A1的值
Range cellA1 = worksheet.Cells[1, 1];
string valueA1 = cellA1.Value.ToString();

// 获取整个工作表的范围
Range range = worksheet.UsedRange;

// 获取工作表中的行数和列数
int rowCount = range.Rows.Count;
int columnCount = range.Columns.Count;

int cellCount = rowCount * columnCount;

// 关闭工作簿
workbook.Close();

// 关闭Excel应用程序
excelApp.Quit();

// 释放资源
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);