Skip to main content
  • EN

Hi!

I have a work process that writes into googlesheete, I get quite a few errors:

Python Exception <ApiError>: API Error 400 INVALID_ARGUMENT: 'This action would increase the number of cells in the workbook above the limit of 10000000 cells.'

I saw what was being done here:

https://community.safe.com/s/article/Known-Issue-Cell-limit-error-when-writing-to-Google-Sheets

What can solve my problem is the ability to delete the sheet by fme..

Is there such a possibility?

The Worksheet Handling parameter on the writer feature type has the option to delete (drop) an existing sheet and create a new one, or truncate an existing sheet (remove all rows)

Screenshot 2023-01-23 at 09.50.34

Thanks!

Reply


Community Stats

30,163
Posts
114,500
Replies
37,813
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.