Timeline for How to delete a row from an Excel Table using the client-side Ewa object in a SharePoint Excel Web Part
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 16, 2015 at 6:17 | comment | added | zumalifeguard | Thank you ExcelAnalyst, but what i really need is for the rows to be removed from the table because the table is a data-source to a pivot-report on another sheet. The current workaround I'm planning on is clearing all the data in the rows and then filtering out blank rows in the pivot report. Also take a look at this question about Ewa. stackoverflow.com/questions/33621787/… | |
| Dec 16, 2015 at 4:29 | comment | added | Andrew Hall | I have no way to delete rows, but I did develop a hacky/fragile way to hide rows based on cell/formula values. It involves using an Excel filter and jquery to monitor html div values and to navigate through the filter dialogs to update the filter. | |
| Dec 16, 2015 at 4:17 | comment | added | Andrew Hall | Hopefully that means Microsoft is considering adding new capabilities to EWA. | |
| Dec 15, 2015 at 22:44 | comment | added | zumalifeguard | I can't use the new API because it's designed for Office AddIns. The API si not compatible with Ewa. What's worse, the Ewa API does make calls to the server side, to an internal API which does support it, because the same API is used from the full Excel WebApp. You can see it in the browser's debugger. The method is called something like InsertDeleteRow or something. I asked them to give me the to non minimized version of Ewa, but they can't. | |
| Dec 14, 2015 at 16:47 | review | Late answers | |||
| Dec 14, 2015 at 16:52 | |||||
| Dec 14, 2015 at 16:27 | history | answered | Andrew Hall | CC BY-SA 3.0 |