Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
Programming / Google sheets - Error 2
« on: October 05, 2021, 01:13:43 PM »
Using the Google Sheets API I am able to update sheets repeatedly, but on a limited number of occasions I receive an Error 2 - End of File when writing a row of data.
I am using SetRangeRow to select the row then passing the data with SEP characters on a Write. The data being written is modest, about 6 columns, no large text.
On rerunning the program the error will not occur, or sometimes occur on a totally different row, it has never yet occurred on the same row, but they're not that frequent.
Setting a WAIT between rows reduces the frequency of the error significantly.
The Google connection is via a 450Mb VPLS circuit, so a fast connection.
On a large sheet (2900 rows) some rows appeared as a blank row, until the WAIT statement was introduced. Running with the WAIT in place allowed the data to appear. The correct number of rows had been created, they were just empty, until the slower process filled them in.
Is there a better way of doing large bulk uploads than row by row or handling the error condition ?
It feels as though it may relate to the way Google receives the data.
I am using SetRangeRow to select the row then passing the data with SEP characters on a Write. The data being written is modest, about 6 columns, no large text.
On rerunning the program the error will not occur, or sometimes occur on a totally different row, it has never yet occurred on the same row, but they're not that frequent.
Setting a WAIT between rows reduces the frequency of the error significantly.
The Google connection is via a 450Mb VPLS circuit, so a fast connection.
On a large sheet (2900 rows) some rows appeared as a blank row, until the WAIT statement was introduced. Running with the WAIT in place allowed the data to appear. The correct number of rows had been created, they were just empty, until the slower process filled them in.
Is there a better way of doing large bulk uploads than row by row or handling the error condition ?
It feels as though it may relate to the way Google receives the data.
Pages: [1]