Hello,
is there any way to open an existing Excel document that contains macros and control elements (such as buttons) and preserve them until the document is being saved again?
Dim wb As Infragistics.Excel.Workbook = Infragistics.Excel.Workbook.Load("MyExcel.xls")wb.Save("MyExcel2.xls")
=> All macros, buttons etc. lost in MyExcel2.xls.
Thanks
Max
Unfortunately, there is no way to round-trip these items. You can submit a feature request for this here: http://devcenter.infragistics.com/Protected/RequestFeature.aspx.
Hi,
I need to have buttons, labels in the excel file. Has this feature been implemented.
REgards,
Yamini
The macros are now round-tripped, but forms such as buttons and labels are not. I have forwarded this post to the Developer Support Manager to create a feature request on your behalf.
Yamini,
I've just submitted feature request FR12066 for the functionality to round-trip the contents of forms (such as buttons and labels) when loading and subsequently saving an Excel file through our Excel engine to be added to a future version of the toolset.
For anyone else who is interested in seeing similar functionality in a future version of the NetAdvantage for .NET toolset, you can submit a feature request here. Remember, the number of requests we receive for a given feature is one of the tools we use to prioritize what functionaltiy goes in to a given release.
I ask again; Has the presence of forms such as buttons and comboboxes been roundtripped ?
Please answer as it is urgent and necessary for my companys product.
I love the infragistics excel component but if you need more heavy duty charts/macros etc roundtripping you might have to invest in something like gembox spreadsheet maybe? Hope infragistics improves their excel component soon.