Zend_Gdata_Spreadsheets: How to delete and insert 2 columns of new data in efficient way
The case:
Spreadsheets that have 2 columns with data. The columns are named "first name" and "last name". Some examples of datasets: "John Bond" and 开发者_如何学编程"Stive Colins" etc.
I need to delete the above columns data and insert some new data into these columns.
It should be done in an efficient way with Zend_Gdata_Spreadsheets class.
Thanks
You can use updateRow or deleteRow
$updatedListEntry = $spreadsheetService->updateRow($oldListEntry,
$newRowData);
$spreadsheetService->deleteRow($listEntry);
I feel update row is better option as it is one request, in case of delete row u need to delete and reinsert it needs to call api twice
精彩评论