Forms and Macros
GemBox.Spreadsheet is a .NET component that enables developers to read, write, convert and print spreadsheet files (XLSX, XLS, ODS, CSV, HTML, PDF or XPS) from their .NET applications using one simple API. GemBox.Spreadsheet Free is free of charge while GemBox.Spreadsheet Professional is a commercial version licensed per developer.
GemBox.Spreadsheet preserves Form Controls and Macros when reading XLSX file format.
Screenshot
See the full code below, use RUN EXAMPLE to execute.
1using System;
2using GemBox.Spreadsheet;
3
4class Sample
5{
6 [STAThread]
7 static void Main(string[] args)
8 {
9 // If using Professional version, put your serial key below.
10 SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
11
12 ExcelFile ef = ExcelFile.Load("FormsAndMacros.xlsm");
13
14 ef.Save("Forms and Macros.xlsm");
15 }
16}
1Imports GemBox.Spreadsheet
2
3Module Samples
4
5 Sub Main()
6
7 ' If using Professional version, put your serial key below.
8 SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")
9
10 Dim ef As ExcelFile = ExcelFile.Load("FormsAndMacros.xlsm")
11
12 ef.Save("Forms and Macros.xlsm")
13
14 End Sub
15
16End Module
Check next sample or find out more about GemBox.Spreadsheet and GemBox Software.