Vic, The spreadsheet is a "template" which is used to create other spreadsheets, so it is only read from. On occasion, it may be manually updated. The spreadsheet has about 10 worksheets with 4 of the worksheets containing formulas and the rest used for lookups. The worksheets that do have formulas have about 7 formulas, 1 row, 20 columns, although some times there are few more rows to test formula changes.
In short, the process I have is to read from the template spreadsheet using certain worksheets and create a new spreadsheet with data from a particular template worksheet and new data. This process occurs at regular intervals every 20 minutes, if there is something to process. I first noticed the issue in a qa environment and after some time debugging, tried to copy the template spreadsheet and that fixed the issue. Regards, David Hodge On Wednesday, May 8, 2013 12:09:29 PM UTC-4, Vic Fryzel wrote: > > 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]<javascript:> > > 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]<javascript:> >> . >> 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.
