In terms of performance which method is preferable to get the cell count for the larger file:
worksheet.Cells.CountLarge
Or
Calculate using: worksheet.Cells.MinRow - MinColumn - MaxRow - MaxColumn
Or
worksheet.Cells.MaxDisplayRange.CellCount
In terms of performance which method is preferable to get the cell count for the larger file:
worksheet.Cells.CountLarge
Or
Calculate using: worksheet.Cells.MinRow - MinColumn - MaxRow - MaxColumn
Or
worksheet.Cells.MaxDisplayRange.CellCount
Thanks for the detail.