string filepath = @"D:\wAngran's\文档\Desktop\tempS\亲情1+1_isProc.xlsx";
Microsoft.Office.Interop.Excel.Application ea = new ApplicationClass();
ea.Workbooks.Open(filepath, 3, true, 2, string.Empty, string.Empty, true, XlPlatform.xlWindows, ";", null, null, null, null, null, null);
Workbook wb = ea.Workbooks[1];
Worksheet ws = (Worksheet)wb.Sheets[2];
Microsoft.Office.Interop.Excel.Range re = ws.UsedRange;
int down = re.get_End(Microsoft.Office.Interop.Excel.XlDirection.xlDown).Row;
int right = re.get_End(Microsoft.Office.Interop.Excel.XlDirection.xlToRight).Column;
for (int row_index = 1; row_index < down; row_index++)
{
for (int cel_index = 1; cel
在控制台读取Excel的方法,可根据自身需要修改使用以适应其它平台使用。
最新推荐文章于 2023-05-18 23:40:21 发布