Completed
Last Updated: 24 Jun 2021 14:53 by Vili
Release R3 2021
ADMIN
Nikolay Demirev
Created on: 09 Sep 2016 07:52
Category: SpreadProcessing
Type: Feature Request
22
SpreadProcessing: Support for Macro-Enabled Workbooks (xlsm)
Add support for preserving and exporting the macros in a macro-enabled workbook.

Macros are pieces of code written in Visual Basic for Applications (VBA) which are used to automate repetitive tasks in excel. The macros are part of the excel file. When a file contains a macro its extension becomes xlsm.

SpreadProcessing should be able to import and export xlsm files and edit the macros in them.
16 comments
Vili
Posted on: 24 Jun 2021 14:53
Cool. Thanks!
ADMIN
Nikolay Demirev
Posted on: 18 Sep 2020 08:45

Hello,

In fact, this can be more easily achievable, because, in order to modify the macros, we need to implement the whole DOM of the VBA projects and parse them, while preserving the macros would be easier because we could just preserve the VBA project in the memory and export them unmodified after.

While this is a possible solution, the feature is still not planned for a specific release, but when it does, we will update the status of the item.

Regards,
Nikolay Demirev
Progress Telerik

Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive, special prizes, and more, for FREE?! Register now for DevReach 2.0(20).

Oriana
Posted on: 18 Sep 2020 07:56

Hello,

exactly basically we can summarize it in being able to read and write from an Excel file with Macros keeping the macros contained in the original document.

It would be really appreciate.

Thanks

Regards 

Stefan Schmiedl
Posted on: 18 Sep 2020 07:42

My use case is "open .xlsm file, modify worksheets, save as .xslm".

I don't want to execute or in fact "activate" any kind of VBA, but I need to keep macros, if they are in the original document.

 

Thanks,

s.

ADMIN
Nikolay Demirev
Posted on: 18 Sep 2020 07:27

Hi Oriana,

Thank you for your input we will take it into consideration in our research.

Currently, you can import XLSM files and read their contents, but can not export the data back to XLSM.

Regards,
Nikolay Demirev
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Oriana
Posted on: 18 Sep 2020 06:51

Hello,

our requirement is to be able to read and write from the xlsm file, not modifying macros, but being able eventually to call them and make them works from the front-end.

Regards 

ADMIN
Nikolay Demirev
Posted on: 18 Sep 2020 06:21

Hi Oriana,

We are reserching this feature and we are trying to gather more information about the requirements. Could provide us with more information on what you need to import and export form an XLSM file? Do you need to read and write only the cell contents or you need to be able to modify the macros in the file?

Regards,
Nikolay Demirev
Progress Telerik

Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive , special prizes and more, for FREE?! Register now for DevReach 2.0(20).

Oriana
Posted on: 17 Sep 2020 15:03

Hello,

I also strongly suggest to implement almost a functionality to read and write data on .xlsm file soon.

I think that given the variety of components in Telerik it would be crucial to have such possibility without using other external components or writing custom code.

Regards

ADMIN
Dimitar
Posted on: 18 Aug 2020 11:36

Hello Vili,

This item is still not planned for implementation. Indeed it has a lot of votes but the next release is already planned and this is why I cannot provide you with a timeframe.

Thank you for your understanding.

Regards,
Dimitar
Progress Telerik

Vili
Posted on: 18 Aug 2020 03:29

Yes, I also need this feature. I don't intend to create Macros, all I want to do is to open an existing xlsm file, add some data to some cells then write it back as xlsm file.

Is this something that can be done soon?

ADMIN
Tanya
Posted on: 16 Jul 2020 10:03

Hi Stefan,

I am sorry to hear about the inconvenience this missing functionality is causing you. Please, make sure you are following this item so we can notify you about status changes on it.

Regards,
Tanya
Progress Telerik

Stefan Schmiedl
Posted on: 16 Jul 2020 09:13
Same here ... I need to fill Excel files provided by my client's client with data from an ERP system. I can read the "empty" xlsm files and fill the workbook but I can't save the workbook as .xlsm again. So instead of just attaching the workbook to an email, my client has to open the workbook, open an original workbook with the macros, copy the contents, paste the contents, save, close, close and _now_ there is a notebook which can be mailed back.
ADMIN
Dimitar
Posted on: 04 May 2020 09:50

Hello Anjaly,

Thank you for feedback. I will pas it to the team. 

If there's anything else we can do for you, just let us know. 

Regards,
Dimitar
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Anjaly
Posted on: 01 May 2020 14:19

Highly recommend Telerik to bring this feature in your future release. Our client has a requirement to edit xlsm and download xlsm file, for which currently we do not have any option. 

 

Thanks &  Regards,

Anjaly

ADMIN
Nikolay Demirev
Posted on: 08 Apr 2019 11:49
Hi Felipe,

This feature is currently not scheduled for implementation and I cannot provide you with a timeframe when the feature might be available. Please make sure to cast your vote for the implementation of this feature as this directly affects its priority and follow the item, so you can receive updates about changes on its status.

Regards,
Nikolay Demirev
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
FCosta
Posted on: 02 Apr 2019 09:04
The lack of this functionality forces us at ACTIVETECH to use another external component that allows us to read and record a workbook, preserving all the macros already in the workbook.
We would love to be able to use only the components provided by Telerik AJAX.