Converting xlsm to PDF using Aspose.Cells

Aspose.Cells Product Family
1

Is the process of converting an XLSM file to a PDF file using Aspose.Cells the same result as converting an XLSM file to an XLSX file and then converting the XLSX file to a PDF file?

2

@AAAAAAAAAAAAAAAAA

The process of converting an XLSM file directly to a PDF using Aspose.Cells is generally more efficient than converting it first to an XLSX file and then to a PDF. When you convert an XLSM file directly to a PDF, the conversion process handles the macros and any specific features of the XLSM format directly, ensuring that the output PDF accurately reflects the original content and formatting.

In contrast, converting an XLSM file to XLSX first may lead to potential loss of macro functionality or other specific features that are unique to the XLSM format. After converting to XLSX, you would then convert that file to PDF, which could introduce additional steps and potential discrepancies in the final output.

Here’s a simple code example demonstrating how to convert an XLSM file directly to a PDF using Aspose.Cells:

using System;
using Aspose.Cells;

namespace ExcelToPdfConversion
{
    class Program
    {
        static void Main(string[] args)
        {
            // Load the XLSM file
            Workbook workbook = new Workbook("path/to/your/file.xlsm");

            // Save the workbook as a PDF
            workbook.Save("path/to/your/output/file.pdf", SaveFormat.Pdf);

            Console.WriteLine("Conversion completed successfully.");
        }
    }
}

This code snippet shows how to load an XLSM file and save it directly as a PDF, ensuring that all content is preserved accurately without the need for intermediate formats.

For more detailed information on the conversion process and additional functionalities, you can refer to the official documentation.

3

@AAAAAAAAAAAAAAAAA,

Generally both processes should give you same results (PDF). Do you find any issue with the accuracy, fidelity or performance of results for both scenarios/cases or approaches?

  1. XLSM → PDF via Aspose.Cells
  2. XLSM → XLSX → PDF via Aspose.Cells

If you find different results, kindly do provide your input XLSM file (please zip the file first) and share your sample code snippet that you are using. Also, provide your output PDFs. We will check your issue soon.