CData Excel Add-In for OData 2019 - Online Help
Questions / Feedback?

Updating Data

CData Excel Add-In for OData 2019 - Build 19.0.7354

After Querying Data to pull data into your sheet, you can edit cells and post the changes to the rows you select. Select the data manipulation operation on the CData ribbon. The add-in only saves the changes in the selected rows. You must also enable data modification options for the connection to save changes. See Establishing a Connection for details.

Update

From the CData ribbon, click Update Rows. Note that not all cells can be updated; read-only cells are marked in their column headers. Also, business rules in your OData data source may prevent you from making certain changes. See Data Model for more notes on updating OData

Insert

To insert a new row, create a new row in the spreadsheet. The data in the columns must match with the respective headers. Select the row and click Insert Row. The CData Excel Add-In for OData 2019 attempts to add a new row in OData.

Delete

To delete one or more rows, select the rows and click Delete Rows.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0