开发者

Zend_Gdata_Spreadsheets: How to delete and insert 2 columns of new data in efficient way

开发者 https://www.devze.com 2023-03-18 09:50 出处:网络
The case: Spreadsheets that have 2 columns with data. The columns are named \"first name\" and \"last name\".

The case:

  1. 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.

  2. I need to delete the above columns data and insert some new data into these columns.

  3. 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

0

精彩评论

暂无评论...
验证码 换一张
取 消