Read range issue with Excel if data only on cell A1


#1

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


#2

Hi,

Can confirm the same behaviour (NRE on OutArgument).
Used workaround:

  1. Wrap ReadRange with TryCatch (Ctrl+T)
  2. Add a catch for NRE.
  3. Use ReadCell to check for A1!=null
  4. Depending on next steps, use the value directly or build a DT with it “manually” using BuildDT and AddRow.

Regards.


#3

Hi,

Just tested the scenario again and this has been fixed. The workflow worked fine and gave me the correct output.

Thanks & Regards,
Sachin