Write range blank despite dtb having rows

[MikeBlades]

Hello all,

Got a strange one here and i can’t figure it out, hoping someone smart here can.

I have got data rows from calculation (using ADD DATAROW).
I have a WRITELINE “dtbSupp.rows.count.tostring” which returns 645 rows
i use Write range to add 645 lines to XL
then i re run Write line and get same 645 result

But when i open the XL there is only the header info there. the scope for dtbSupp is the whole Workflow, so it’s not that.

I have tried putting the Write Range in an XL app scope, but no joy either.

Here is a photo to show the write lines…WHAT AM I MISSING???

[Yoichi]

Hi,

For now, can you check content of the datatable using the following expression with WriteLine, for example?

String.Join(",",dbtSupp.rows(0).ItemArray)

Regards,

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@MikeBlades

Chances are there will be blank rows. Just check the rows have data in the data table.

[MikeBlades]

So you were right…blank data rows…The reason: the initial XL file had HIDDEN columns, which lined up with what i thought were the columns with variables.

Simple solution, but over looked by me until i read your comment. THANKS