Write Range Workbook: Value cannot be null. (Parameter 'source)

Help Studio
, ,
1

image
image1920×1080 310 KB

If I write on a new file it doesn’t show any error . But when I tried to write on a previouly created file it shows this error, also tried Append . Same error.

The Datatable got data. How to solve this ??

2

@Michelle_Wong_ik_Tein

Welcome to the community

As per error value cannot be null comes when any of the variable value is null …

Can you please check the same

Also i see you are using a shared location instead try with a local location

Cheers

3

Hi,
The same variable when I do Write Range Workbook on the local project location it doesn’t show any error.
Again If I use Modern Excel (Use Excel Scope ), it doesn’t show any error on the shared location file.

Only when I try to use shared location and Write Range workbook it gives me that error.

The variable doesn’t have any null value.

4

@Michelle_Wong_ik_Tein

As mentioned please copy file to local do your modifications and then copy back to shared location

Generally due to shared location syncing with remote server it would cause these ossues

Cheers