Hey David, Can you give me some details about the "corrupt" spreadsheet you encountered? What is its size? How many formulas does it have? etc.
Thanks, Vic On Wed, May 8, 2013 at 6:17 AM, David Hodge <[email protected]>wrote: > 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. > > > -- 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.
