My Task Pane add-in for Excel gets tabular data from an external data source, renders it in a table in the worksheet, allows the end-user to edit the data, and then sends the edited data back to the external data source. Some of the data rendered in
the worksheet table is for reference only and cannot be changed by the end-user. A simple example might be a Sales Forecast table with columns: Customer, Q1 Forecast Amt, Q1 Actual Amt etc. In this case, we'd want the end-user to be able to edit
the Forecast Amt but not the Customer name. Since all this data is coming from the external data source, the add-in's java script code would need to be able to write the Customer names into the worksheet.
Is there a way to make certain cells read-only for the end-user?
In a VSTO/COM add-in, we could do this by programmatically controlling the worksheet's Protection property (turning it off, writing the company names, then turning it back on).
Even with the
Excel 2016 enhanced APIs available, I don't see a way to achieve this.
Any suggestions would be appreciated.
Thanks.
Shaun Logan - Oracle