C# API to Render CGM to XLSM
Export CGM File to XLSM via C# without using Microsoft® Excel or Adobe® Acrobat Reader
Aspose.Total for .NET is a comprehensive suite of components that enables developers to easily convert CGM files to XLSM within any .NET, C#, ASP.NET and VB.NET applications. This suite of components provides a powerful and reliable solution for developers who need to quickly and accurately convert CGM files to XLSM.
The process of converting CGM to XLSM involves two steps. Firstly, Aspose.PDF for .NET is used to export the CGM file to XLSX. This component provides a comprehensive set of features for manipulating PDF documents, including the ability to export CGM files to XLSX.
Once the CGM file has been exported to XLSX, Aspose.Cells for .NET can be used to convert the XLSX file to XLSM. Aspose.Cells for .NET is a powerful spreadsheet programming API that enables developers to create, manipulate and convert spreadsheets in a variety of formats, including XLSX and XLSM. It provides a comprehensive set of features for working with spreadsheets, including the ability to convert XLSX to XLSM.
Using Aspose.Total for .NET, developers can easily and quickly convert CGM files to XLSM within any .NET, C#, ASP.NET and VB.NET applications. This suite of components provides a reliable and powerful solution for developers who need to quickly and accurately convert CGM files to XLSM.
.NET API to Convert CGM to XLSM
Conversion Requirements
Install from command line as nuget install Aspose.Total or via Package Manager Console of Visual Studio with Install-Package Aspose.Total.
Alternatively, get the offline MSI installer or DLLs in a ZIP file from downloads .
| // supports PDF, CGM, EPUB, TeX, PCL, PS, SVG, XPS, MD, MHTML, XML, and XSLFO file format | |
| // load PDF as input file format with an instance of Document class | |
| var document = new Document("template.pdf"); | |
| // save document in XLSX format | |
| document.Save("excel_output.xlsx", Aspose.Pdf.SaveFormat.Xlsx); | |
| // load the XLSX file in an instance of Workbook | |
| var book = new Workbook("excel_output.xlsx"); | |
| // supports XLSB, XLSM, XLT, XLTX, XLTM, XLAM, CSV, TSV, TXT, ODS, DIF, MD, SXC, and FODS file format | |
| // save input document as CSV | |
| book.Save("output.csv", Aspose.Cells.SaveFormat.Auto); |
Convert Protected CGM to XLSM via C#
If your CGM document is password protected, you cannot convert it to XLSM without the password. Using the API, you can first open the protected document using a valid password and convert it after it. In order to open the encrypted file, you can initialize a new instance of the Document class and pass the filename and password as arguments.
| // supports PDF, CGM, EPUB, TeX, PCL, PS, SVG, XPS, MD, MHTML, XML, and XSLFO input file formats | |
| // open password protected PDF document | |
| Document doc = new Document("input.pdf", "Your@Password"); | |
| // save document in XLSX format | |
| document.Save("excel_output.xlsx", Aspose.Pdf.SaveFormat.Xlsx); | |
| // load the XLSX file in an instance of Workbook | |
| var book = new Workbook("excel_output.xlsx"); | |
| // supports XLSB, XLSM, XLT, XLTX, XLTM, XLAM, CSV, TSV, TXT, ODS, DIF, MD, SXC, and FODS file format | |
| // save input document as CSV | |
| book.Save("output.csv", Aspose.Cells.SaveFormat.Auto); |
Convert CGM File to XLSM with Watermark via C#
While converting CGM file to XLSM, you can also add watermark to your output XLSM file format. In order to add a watermark, you can create a new Workbook object and open the converted XLSX document, select Worksheet via its index, create a Shape and use its AddTextEffect function. After that you can save your XLSX document as XLSM with Watermark.
| // supports PDF, CGM, EPUB, TeX, PCL, PS, SVG, XPS, MD, MHTML, XML, and XSLFO file format | |
| // load PDF as input file format with an instance of Document class | |
| var document = new Document("template.pdf"); | |
| // save document in XLSX format | |
| document.Save("excel_output.xlsx", Aspose.Pdf.SaveFormat.Xlsx); | |
| // load the XLSX file in an instance of Workbook | |
| var book = new Workbook("excel_output.xlsx"); | |
| // get the first default sheet | |
| var sheet = book.Worksheets[0]; | |
| // add a new shape to ShapesCollection of Worksheet | |
| var wordart = sheet.Shapes.AddTextEffect(Aspose.Cells.Drawing.MsoPresetTextEffect.TextEffect1, | |
| "CONFIDENTIAL", "Arial Black", 50, false, true, 18, 8, 1, 1, 130, 800); | |
| // supports XLSB, XLSM, XLT, XLTX, XLTM, XLAM, CSV, TSV, TXT, ODS, DIF, MD, SXC, and FODS file format | |
| // save input document as CSV | |
| book.Save("output.csv", Aspose.Cells.SaveFormat.Auto); |
Transforming CGM File to XLSM Programmatically : Use Cases
Converting CGM (Computer Graphics Metafile) files into XLSM (Excel Smart Document) formats unlocks the full potential of your data visualization and analysis capabilities. This conversion enables you to:
Use Cases:
- Product Design and Prototyping: Convert CGM files to create interactive 3D product models, simulate user experiences, and validate design concepts in Excel.
- Scientific Research and Analysis: Use XLSM to visualize complex scientific data, such as experimental results, simulation outputs, and 3D models, facilitating better understanding and decision-making.
- Business Intelligence and Reporting: Convert CGM files to create interactive dashboards, reports, and visualizations for stakeholders in Excel Smart Documents.
- Marketing and Sales Visualization: Use XLSM to visualize customer behavior data, track sales trends, and identify patterns in marketing campaign performance.
- Architecture and Engineering Design: Convert CGM files to create interactive building models, simulate structural integrity, and analyze performance metrics in Excel.