Cannot populate sheet if columns are less than fields.
-
Hi There.
A default new sheet has 26 columns (A-Z)
My form had 30 fields, which caused the sheet to not populate since it cant update a nonexistent cell.To fix this, on line 85 of
./lib/google-sheets.php
I added a check for the column count and the number of field, then updated the columns in the sheet to match.if( count( $data ) > $worksheet->getColCount() ){ $worksheet->update( null, count( $data ) ); }
All the best,
~ David
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
- The topic ‘Cannot populate sheet if columns are less than fields.’ is closed to new replies.