You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a xlsm file that contains drawing objects (buttons), and I would like to be able to edit the visibility of these.
I've been looking around and it looks like this library does not currently expose/parse these objects. (or I've totally missed it)
So I would love to get to a SetDrawingVisible similar to the SetRowVisible command.
Happy to code this if you have some pointers of how best to add this in.
I think it would be roughly:
Somehow lookup the drawing xml file
Create a reader for this file
Walk the tree to find the drawing
Edit
Save changes
Obviously that feels simple and I've been poking around a bit but haven't yet put the concept together, so would love some pointers / if its trivial to do and I'm missing it feel free to tell me that :)
Describe the results you received:
Cant find anything in the existing API to let me edit these
Describe the results you expected:
Was really hoping for a SetDrawingVisible or similar :)
Output of go version:
go version go1.16.6 linux/amd64
Excelize version or commit ID:
f9e9e5d2e07b
Environment details (OS, Microsoft Excel™ version, physical, etc.):
** Example xml content I would like to be able to edit**
Description
I have a xlsm file that contains drawing objects (buttons), and I would like to be able to edit the visibility of these.
I've been looking around and it looks like this library does not currently expose/parse these objects. (or I've totally missed it)
So I would love to get to a
SetDrawingVisible
similar to theSetRowVisible
command.Happy to code this if you have some pointers of how best to add this in.
I think it would be roughly:
Obviously that feels simple and I've been poking around a bit but haven't yet put the concept together, so would love some pointers / if its trivial to do and I'm missing it feel free to tell me that :)
Describe the results you received:
Cant find anything in the existing API to let me edit these
Describe the results you expected:
Was really hoping for a
SetDrawingVisible
or similar :)Output of
go version
:Excelize version or commit ID:
Environment details (OS, Microsoft Excel™ version, physical, etc.):
** Example xml content I would like to be able to edit**
(Some data removed for simplicity)
The text was updated successfully, but these errors were encountered: