search

jpillora / node-edit-google-spreadsheet

A simple API for editing Google Spreadsheets
304 stars 101 forks source link

Spreadsheet Size #61

Closed doguhanokumus closed 9 years ago

doguhanokumus commented 9 years ago

Hi again,

It's now over a week I'm getting used to this library and most of my script is using automated flow and at the initialization of a document I'm having a small problem.

When the script run, let's say I have 50 columns to send, but the document has only 30 columns. I'm getting errors in this case regarding cell_id does not exist, which is a correct warning.

I can manually add columns and cells into the Sheet, but it could be a cool feature if this library could auto-expand the sheet so that my 'updates' could fit into the sheet.

jofomah commented 9 years ago

try

spreadsheet.send( [options,] callback( err ) )

Sends off the batch of add()ed cells. Clears all cells once complete.

options.autoSize When required, increase the worksheet size (rows and columns) in order to fit the batch - NOTE: When enabled, this will trigger an extra request on every send() (default false).

spreadsheet.send({autpSize: true}, callback)

On Tue, Feb 17, 2015 at 3:01 PM, Doguhan Okumus notifications@github.com wrote:

Hi again,

It's now over a week I'm getting used to this library and most of my script is using automated flow and at the initialization of a document I'm having a small problem.

When the script run, let's say I have 50 columns to send, but the document has only 30 columns. I'm getting errors in this case regarding cell_id does not exist, which is a correct warning.

I can manually add columns and cells into the Sheet, but it could be a cool feature if this library could auto-expand the sheet so that my 'updates' could fit into the sheet.

— Reply to this email directly or view it on GitHub https://github.com/jpillora/node-edit-google-spreadsheet/issues/61.

doguhanokumus commented 9 years ago

Thank you @jofomah and I'm sorry that I skipped it at the documentation.

In my case, since I need it only at initialization of a document (i.e. importing the headers), I'm actually calling it only once for each page without any rows.