I saw a post here saying that you support roundtrip on an Excel macro(s). I'm wondering where in the workbook object it is stored?
I need to apply a macro to a workbook because no combination of existing Excel functions (including the new Office365) will complete the kind of analysis and reporting I require within our application, as it requires grabbing a lot of information from several sheets before being able to calculate a response in the final sheet of the workbook.
I am currently using the code from your loading data example to analyze the object returned, in an attempt to locate the branch that might hold the Macro code, so that I can reproduce and attach it to the application in the appropriate spot.
A basic overview of the information is this:
The formula for the projected input requires backtracking a number of columns (based on the output date and time from sheet 4), where time periods in sheet 6 cover the beginning of production for the max time period.
The logic for any cell in sheet 6 reads something like this:
if (sheet4cell = sheet4max) { sheet1cell/sheet3cell }else { sheet1cell (column - (sheet4max - sheet4rowMax) / sheet3cell (column - (sheet4max - sheet4rowMax) }
If there is now a way to add a macro in a more legitimate way, please let me know how. This is ASP.NET MVC with Ignite UI (RAZOR).
Hello,
Thank you for posting in our community.
Currently, the excel library does not provide public properties or methods for the workbook macros. What I can suggest in order to see this functionality implemented is logging a new product idea. You can suggest new product ideas for future versions (or vote for existing ones) at https://ko.infragistics.com/community/ideas.
Submitting your idea will allow you to communicate directly with our product management team, track the progress of your idea at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
Remember when submitting your idea to explain the context in which a feature would be used and why it is needed as well as anything that would prevent you from accomplishing this today. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. You can also link back to this thread for additional details.
I'm well aware that Macros aren't an embedded feature. I was asking if there's anyone knowledgeable enough about the way the Workbook object is constructed during an UPLOAD that they might be able to point me in the direction of the correct branch where any Macros uploaded WITH the workbook might be located. My idea was to copy the contents of that branch, and graft it onto a workbook object created within the UI of our application.
This is decidedly not the answer I was looking for.
My assumption was that I could trigger the Macro in the UI, but this has proven not to be the case. Additionally, the round trip on the Macro is not as accurate as simply sharing the workbook or supplying it to our users via the Personal Macro Workbook.
Unfortunately, Infragistics has not been helpful in resolving our needs in this situation. I will have to refactor the UI page in question so that the logic introduced into the Macro is calculated in the back-end.
Thanks anyway.
After investigating this further with our development team, the current workaround would be to load the workbook that contains the macros and then add the 5 worksheets and data to it.
Unfortunately, it is not possible to edit the macros since they are stored in an excel file as a blob with its own custom format/specification. More information can be found here.
Please let me know if you need any further assistance with this matter.