110,533
社区成员
发帖
与我相关
我的任务
分享
Workbook wb = new Workbook();
wb.LoadFromFile(@"1.xlsx");
Worksheet sheet = wb.Worksheets[0];
int[,] arrays = new int[sheet.LastRow, sheet.LastColumn];
for (int i = sheet.FirstRow; i <= sheet.LastRow; i++)
{
for (int j = sheet.FirstColumn; j <= sheet.LastColumn; j++)
{
arrays[i - 1, j - 1] = Convert.ToInt32(sheet.Range[i, j].Value);
}
}
int max; int min; int max_row; int min_row; int max_col; int min_col;
max = min = arrays[0, 0];
max_row = max_col = 1;
min_row = min_col = 1;
for (int i = 0; i < sheet.LastRow; i++)
for (int j = 0; j < sheet.LastColumn; j++)
{
if (max < arrays[i, j])
{
max = arrays[i, j];
max_row = i + 1;
max_col = j + 1;
}
if (min > arrays[i, j])
{
min = arrays[i, j];
min_row = i + 1;
min_col = j + 1;
}
}
Console.WriteLine("最大数为:{0},位置是:第{1}行,第{2}列", max, max_row, max_col);
Console.WriteLine("最小数为:{0},位置是:第{1}行,第{2}列", min, min_row, min_col);