Values Populated in Incorrect Fields - Web Form

[Gintaras]

I would not use Tabs to select Excel cells. Now it seems you use CellsToArray to get 1 cell. With it you can get whole row or whole table.

Macro Macro2937

Code:

Copy      Help

ExcelSheet es.Init

;get range: single row of 16 cells that starts from the selected cell
int c0 r0; es.GetRangeInfo("<sel>" c0 r0)
str strRange=ExcelSheet.ExcelRange(c0 r0 c0+15 r0) ;;like A1:P1
ARRAY(str) row; es.CellsToArray(row strRange)

out strRange
out row[0 0]
out row[1 0]
out row[2 0]