Google Sheet-Write Range: Object Reference not set to an instance of an object

Help Studio
, ,
1

When trying to write on Google Sheet getting the below error:
Capture1

image

2

Hey

it means that any of your variables are null or never initiliazed, maybe your DataTable or your SmartTicketSpreadID variables, you should debug your process and check those

regards!

3

Hey!

Check the output of data table. whether is generating data or not in debug mode.

And no need to mention the range(Starting cell).

Try this and let me know

Regards,
NaNi

4

@THIRU_NANI
Yes I have checked the output datatable, it doesn’t has any null value.
and also remove the starting cell range, but still getting same error.

5

Hey!

Cold you please show us the Data table data?

Regards,
NaNi

6

Yeah sure. @THIRU_NANI
Here is the output datatable result

image

7

Hey!

Take one build data table and create the columns…->Output as ->OutDt

Take one for each row in data table pass the Output as DataTable

  1. Take one add data row…

->in the array of row mention the like this

{CurrentRow(0).ToString.Trim,CurrentRow(1).ToString.Trim,CurrentRow(2).ToString.Trim,CurrentRow(3).ToString.Trim,CurrentRow(4).ToString.Trim}

->Mention the data table as Build data table output->OutDt

outside of the For each row take one write range and mention the dt as ->OutDt

Try this and let me know

Regards,
NaNi

8

@THIRU_NANI , Tried but same error.

9

Hey!

Try to use workbook read range.

Regards,
NaNi

10

I have to store the datatable in Google sheet.

Thanks

11

Hey!

Do you have G-Suite access?

Regards,
NaNi

12

Yes, I have G-suite access. And I have already did this before in another spreadsheet using another datatable, but Don’t know why getting error with this datatable.

Thanks

13

I have copy the datatable into another datatable then pass that datatable to write range. And the error resolved.

Thanks

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.