Why is CellRange significantly faster than FullSheet in Read Excel Advanced?

FAQs
1

What users observe

CellRange reads are much faster on large Excel files.

Why this happens

With CellRange:

  • Only required rows are sliced

  • Only required columns are extracted

  • Header resolution is localized

With FullSheet:

  • Entire sheet is scanned

  • All rows and columns are parsed

  • More data flows through inference logic

Performance impact

CellRange:

  • Lower I/O

  • Lower memory usage

  • Faster inference

FullSheet:

  • Higher overhead

  • More flexible

  • Slower on large sheets

Recommendation

Use CellRange whenever:

  • Data is embedded inside reports

  • Sheets contain charts, pivots, or notes

  • Only one table is required