Google spreadsheet copy/paste?

AllPaoTeam has asked for the wisdom of the Perl Monks concerning the following question:

good morning Perl Monks, I am looking for a more efficient way to write this code. I am copying huge amount of data from Excel spreadsheet with multiple tabs into a Google spreadsheet with multiple tabs but it takes a long time because I am updating it cell by cell, is there a way I can copy the whole worksheet/range of cells and paste it into Google spreadsheet? To make it easier for me, I converted the spreadsheet into cvs files. Any help would be greatly appreciated. Below is the code I am using:

Nevermind.... I found the batchupdate_cell which is alot faster. Sorry..

Comment on Google spreadsheet copy/paste?

Replies are listed 'Best First'.
Re: Google spreadsheet copy/paste? by thanos1983 (Parson) on Aug 29, 2014 at 19:10 UTC
Hello AllPaoTeam, It is nice that you found your answer. Just for future reference if someone else maybe encountering the same problem it would be better to provide a link, like batchupdate_cell(@args) part of the Net::Google::Spreadsheets::Worksheet. Best of luck with the rest of your task. Seeking for Perl wisdom...on the process of learning...not there...yet!	[reply] [d/l] [select]