Hi, let's say I have images on my excel sheet, how can I remove / remove them from the sheet using C #,
the following code gives me an exception
Excel.Worksheet ws = Globals.ThisAddIn.GetActiveWorksheet(); foreach (Excel.Shape sh in ws.Shapes) { sh.Delete(); }
thanks!
It doesn't matter, I forgot that my sheet is protected,
Excel.Worksheet ws = Globals.ThisAddIn.GetActiveWorksheet(); ws.Unprotect("PASSWORD"); foreach (Excel.Shape sh in ws.Shapes) { sh.Delete(); }
it works great!
Source: https://habr.com/ru/post/1712780/More articles:Esper and SQS - cloudSending email with MS Access. Third Party Permission Allowed. - vbaHow to create parameterized XPath queries on SQL server? - securityRecover Deleted Problem in Mantis? - mantisWeb Services in classic asp - web-servicesMySQL query to calculate the previous week - mysqlQuestion about the installer in objective-c - memoryUnderstanding a double pointer in a doubly linked list in C - chttps://translate.googleusercontent.com/translate_c?depth=1&pto=aue&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=https://fooobar.com/questions/1712784/what-files-to-keep-under-version-control-on-iphone-projects&usg=ALkJrhifNZJyOhWLbp6ahX91ly0jclrWfQWhy don't stored procedures support INSERT / EXECUTE INTO? - sql-serverAll Articles