GroupDocs.Conversion for Node.js via Java 24.1 Release Notes

Major Features

There are 5 features and bug fixes in this release:

  • Automatically fit rows when converting spreadsheets
  • Improved Presentation to Word-processing conversion
  • Implemented retrieving sheets names from a spreadsheet
  • Implemented converting sheets by name from a spreadsheet
  • CsvLoadOptions.ShowGridLines now respected

Full List of Issues Covering all Changes in this Release

KeyCategorySummary
CONVERSIONNET‑6181EnhancementIntroduce AutoFitRows property in SpreadsheetLoadOptions class
CONVERSIONNET‑6317EnhancementImprove Presentation to Word-processing conversion
CONVERSIONNET-6315EnhancementDifferentiate with the Sheet Names when converted excel to html
CONVERSIONNET-6460BugCsvLoadOptions.ShowGridLines does not work

Automatically fit rows when converting spreadsheets

To fit the row content of all rows while converting a spreadsheet, use the AutoFitRows property of the SpreadsheetLoadOption class.

const loadOptions = new groupdocs.conversion.SpreadsheetLoadOptions();
loadOptions.setAutoFitRows(true);
try {
    const converter = new groupdocs.conversion.Converter("sample.xlsx", loadOptions)
    const options = new groupdocs.conversion.PdfConvertOptions();
    await converter.convert("converted.pdf", options);
}

Introduced new property Worksheets in SpreadsheetDocumentInfo class.

How to retrieve a spreadsheet sheets names

    const source = "sample.xlsx";
    try {
        const converter = new groupdocs.conversion.Converter(source)
        const documentInfo = converter.getDocumentInfo();
        const sheets = documentInfo.getWorksheets();
    }

Convert a spreadsheet by specifying names of the sheets to be converted

    const source = "sample.xlsx";
    const loadOptions = new groupdocs.conversion.SpreadsheetLoadOptions();
    loadOptions.setSheets(["Sheet1", "Sheet3"]);
    try {
        const converter = new groupdocs.conversion.Converter(source, loadOptions);
        const options = new groupdocs.conversion.WebConvertOptions();
        converter.convert("converted.html", options);
    }

Public API and backward incompatible changes

None