Why did my header shift when using CellRange with PREVIOUS_ROW in Excel Reading?

FAQs
1

Headers appear offset or misaligned when using:

  • CellRange

  • PREVIOUS_ROW header option

Why this happens

With CellRange:

  • Data is sliced first

  • Header resolution depends on range boundaries

When using PREVIOUS_ROW:

  • Sparkflows explicitly reads the row above the selected range

  • That row becomes the header source

  • The range itself is treated as pure data

Important distinction

PREVIOUS_ROW refers to the Excel row, not the first row inside the range.

Recommendation

When using CellRange:

  • Double-check header row position

  • Prefer FIRST_ROW if headers are inside the range