I have currently use the Spreadsheet API to find worksheets by name and it
seems every so often there is a problem with the worksheet that is found.
It seems somehow the Spreadsheet or worksheet becomes corrupt because to
fix the issue I found I can simple copy the Spreadsheet with the original
name and get rid of the original or rename. The issue does not happen
frequently but after months of reading a "template" worksheet daily. Any
thoughts? Here is the code I am using:
public WorksheetEntry getWorksheet(final List<WorksheetEntry> worksheets,
final String worksheetName)
{
WorksheetEntry worksheetToFind = new WorksheetEntry();
for (WorksheetEntry currentWorksheet : worksheets)
{
if
(worksheetName.equalsIgnoreCase(currentWorksheet.getTitle().getPlainText()))
{
worksheetToFind = currentWorksheet;
break;
}
}
logger.info("\n\n\n Get Worksheet URL: " +
worksheetToFind.getListFeedUrl());
return worksheetToFind;
}
------
Regards,
David Hodge
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
