Past column A (AA >)

[tomdowning82]

It seems the sheet only loads columns A-Z. I have a sheet with AA, AB, AC etc.. Any ideas?

[theoephraim]

The sheet is flat, nothing exists after Z, just monsters...

Perhaps it is just an oversight it how it figures out the column address.

Can you give a little more detail - are you using the row-based methods or cell-based methods?

[tomdowning82]

ha monsters 😈 Using row based method:

//Get total sheet using framework
state.doc = new GoogleSpreadsheet(state.docID);
await state.doc.useServiceAccountAuth(state.creds);
await state.doc.loadInfo(); 
			
state.originalSheet = state.doc.sheetsById[state.sheetID];			
await state.originalSheet.loadHeaderRow(3);
state.title = state.originalSheet.title;
state.originalRows = await state.originalSheet.getRows({
   offset: 1
});