Ein Range muss als Range Objekt definiert sein Gesendet von Mail für Windows 10
Von: 'Eric Koleda' via Google Spreadsheets API Gesendet: Montag, 4. Dezember 2017 18:17 An: Google Spreadsheets API Betreff: Re: How to apply filter/query specific condition in Google Sheetsusing Sheets API Unfortunately the API doesn't support retrieving values based on filters. The filters control how the spreadsheet data is presented in the application, but the underlying cells remain in place, and that is what the API operates on. - Eric On Monday, December 4, 2017 at 10:06:37 AM UTC-5, Arun wrote: I have tried to use SheetsAPI to interact with my google sheets and i could do that. API brings in all the records based on my range.Now i would like to apply filter while reading the sheets and retrieve the data based on my query not the whole records. Is there a way to do it? I am using the get() to retrieve the records. String spreadsheetId = "someId"; String range = "CSP!A2:AF"; ValueRange response = service.spreadsheets().values().get(spreadsheetId, range).execute(); -- 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/d/optout. -- 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/d/optout.
