I need to generate an Excel report using Java where there are a dynamic number of columns going across the top, and some of the columns are like “master” columns with one or more subordinate columns to it. And they want a button which you can press to expand/collapse the subordinate columns.
The code for the buttons just does this, as an example:
Private Sub cboExCo15_Click()
If Columns(“EP:EV”).EntireColumn.Hidden = True Then
Columns(“EP:EV”).EntireColumn.Hidden = False
Else
Columns(“EP:EV”).EntireColumn.Hidden = True
End If
End Sub
So this is for one column group.
On the actual spread sheet the cell says “=EMBED(“Forms.CommandButton.1”,”")"
and the name is "cboExCol5"
Can Aspose handle generating these buttons programmatically?
If so, would you please explain how?
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Aspose.Cells does not support to create buttons with macos / VBA codes. You may try to use the Grouping Rows / Column option if it fits your need. Please see the following documentation link for details:
Thank You & Best Regards,