Free Support Forum -

Need help: Can Aspose create buttons?

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
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,