Hi,
If I have an excel, which has only one column (no headers) but can have only one row or multiple rows (its dynamic). If I now use a read range activity and there is data present only in A1 cell (only 1 row of data), the output does not come out to be correct. The output comes out as System.Object[,]
Does anyone has face any issue similar to this or have a workaround?
Thanks & Regards,
Sachin
1 Like
Hi,
Can confirm the same behaviour (NRE on OutArgument).
Used workaround:
- Wrap ReadRange with TryCatch (Ctrl+T)
- Add a catch for NRE.
- Use ReadCell to check for A1!=null
- Depending on next steps, use the value directly or build a DT with it “manually” using BuildDT and AddRow.
Regards.
1 Like
Hi,
Just tested the scenario again and this has been fixed. The workflow worked fine and gave me the correct output.
Thanks & Regards,
Sachin