Write DataTable to Excel gives me error

[Favarelaa (Francisco Augusto Varela Aguirre)]

Hello! The extract Table Data Wizard works great, afterwords I use the Output Data Table, but then when I use Write Data To Excel activity it gives me that error.

Can you guys give me hand to solve it please?

[Yoichi]

Hi,

Can you try to use Range as the following?

 Excel.Sheet("Sheet2").Range("D1")

Regards,

[Favarelaa (Francisco Augusto Varela Aguirre)]

I believe the porblem was that I was using the variable Extract Table 3 times.
When I created a new variable fot the Output Data Table and then used it in the write Data Table to Excel it worked fine.

[Yoichi]

HI,

The error message in your first post shows “Unable to convert ExcelValue to IReadWriteRangeRef”
This is caused by you uses Cell property as the following. So I suggested to use Range property in the above post.

Regards,