使用嵌入的 VBA 代碼管理 XLSM 檔

.NET spreadsheet components with VBA code and macro support empower developers to integrate existing Excel automation functionalities within their applications. This unlocks the benefits of the .NET framework, enhancing performance, security, and scalability of spreadsheet operations. Developers can access, modify, and save embedded VBA scripts, ensuring seamless operation in environments that support VBA execution. This fosters continued automation and functionality even when legacy systems or non-VBA-enabled environments are involved, while also enabling code updates, debugging, and preparation for code-execution-friendly settings.

Several .NET spreadsheet components offer VBA code/macro support, including:

• Aspose.Cells for .NET is an Excel spreadsheet programming API that allows you to modify macros and VBA code in the template file to streamline spreadsheet tasks in .NET apps.
• Document Solutions for Excel, .NET Edition by MESCIUS allows users to load and save macro-enabled XLSM files.
• EPPlus is a .NET library for managing Office Open XML spreadsheets. It is capable of creating, reading, deleting, and modifying VBA code.
• Infragistics Excel Framework (part of Infragistics Ultimate UI for Windows Forms) supports workbooks in XLSM format with VBA code, enhancing .NET application development.

For an in-depth analysis of features and price, visit our comparison of .NET spreadsheet components.

Compare .NET Spreadsheet Components