Delete All Sheet Records

[pardeepnadha]

Dear

I want to remove all records exist in sheet. is there any way to do it?
let me know.

Thanks

[alavry]

check out ListEntry.php, public function delete().

run a foreach on the sheet to delete each row except header

[pardeepnadha]

Thanks Its working but not properly
please check my code below
$listFeed = $worksheet->getListFeed();
foreach ($listFeed->getEntries() as $entry) {
$entry->delete();
}
when the loop is run it delete first row and then skip 2nd and then delete 3rd and skip 4th
only deleting odd rows
Is there any way to delete all rows once?

[alavry]

although it should theoretically work, i tried running it in my own script and got the same result as you. i tried debugging it, and think it's an issue/bug with the wrapper. i moved onto using the official google php api, which is on v4 and is much more powerful than what is available here. i recommend you do the same:

https://github.com/google/google-api-php-client
https://developers.google.com/resources/api-libraries/documentation/sheets/v4/php/latest/