Hi!
Have you looked on https://metacpan.org/pod/Net::Google::Spreadsheets::V4?
It's newer, so probably It can give you a bit more data from modern
Google API
On 16/08/2019 14:18, James Kerwin wrote:
Thanks Dave and Mike,
I am using Net::Google::Spreadsheets and all the associated modules
and yeah there
I slept on this and then managed to see what could be seen this morning:
print Dumper($ws[0]{atom});
print Dumper($ws[0]{container});
I should have been a bit clearer on what I was hoping to do (although
I think it can't be easily done) by digging around for what was there
and you're right that I should use the methods provided. I did start
with a method that allowed me to grab a list of the worksheet names,
so I thought if I looked around I might find a list of worksheet "gid's"
It's just that the methods provided don't seem to do what I want. Each
worksheet within a spreadsheet has its own "gid" in the URL of that
particular worksheet. I was trying to find either the URL or gid value
in order to provide a link directly to a newly created worksheet. At
the moment I've used a link to the spreadsheet and the user must
navigate to the new worksheet. It's not a huge issue, but it would
have been a nice finish for what I was doing.
It's already better than it was. Previously a user had to log on via
the command line. Run a series of scripts, mv/cp files around, then
download a csv file from the server and then copy the content to the
Google Sheet. Now a user goes to the website, clicks a button and then
a few seconds later receives a link to the spreadsheet.
I'm currently looking around Worksheet.pm to see if there's any
module/function I could create that could get help me, but I think I
may need to admit that it's quite a bit beyond me.
Thanks,
James
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/
