PDFMake-To-Excel

Excel generation from Pdfmake tables _{Made by Patrick}

Main Purpose

The purpose of this package was to easily generate an Excel file from the Pdfmake library. Therefore, by providing the payload used to generate PDFs using pdfmake, you should be able to get an Excel file, without malformed cells or incorrectly structured cols and rows.

Here is the documentation to build pdfmake payloads: PDFMake Playground

This library don't require pdfmake.

Here is what this library brings:

• Merge rows and cols
• Sheet protection by password
• Front-end excel download
• Server-side excel download by streaming

❯ Installation

Install pdfmake-to-excel with npm

  npm install pdfmake-to-excel

❯ Usage/Examples

Import the ExcelConverter class from pdfmake-to-excel, instanciate it with the name of your excel file and your pdfmake table content definition object, then call the downloadExcel() method.

Pass the following arguments to the constructor

• The Excel filename
• The PDFMake table content definition object
• An optional configuration object including
  • A sheet protection password
  • A default Options Excel configuration

import {ExcelConverter} from 'pdfmake-to-excel';

function downloadFile() {
    const exporter = new ExcelConverter(
        'Export test',
        contentDefinition,
        {
            protection: 'p@ssw0rd',
            defaultOptions: {defaultColWidth: 20}
        }
    );
    exporter.downloadExcel();
}

❯ Content Definition Object Format

Here is the documentation to build pdfmake payloads: PDFMake Playground. Here is how you should format your table content definition object

{
  "title": "Title displayed on your Excel file", //OPTIONAL
  "logo": "base64 of your image here" //OPTIONAL
  "data": [
    [ // LINE 01
      {
        "text": "Cell 01",  // CELL 01 spanned accross 2 rows
        "rowSpan": 2
      },
      {
        "text": "Cell 02", // CELL 02 Spanned accross 2 cells
        "colSpan": 2
      },
      {
        "text": ""
      }
    ],
    [ // Empty line from the first line rowSpan
      {
        "text": "" // Empty cell from the first line rowSpan
      }
    ]
  ]
}

❯ Multiple Sheets

To generate an Excel file with multiple sheets and a table on each sheet, all you have to do is to provide the ExcelConverter Class with a content definition object where the data attribute is an array of sheets, each sheets being an object with the name (sheetName property) and the table content definition's "data" (See content definition object format) property (sheetData property)

const exporter = new ExcelConverter(
    'File_name',
    {
        data: [
            {sheetName: 'Sheet_name 01', sheetData: contentDefinitionData1},
            {sheetName: 'Sheet_name 02', sheetData: contentDefinitionData2},
            {sheetName: 'Sheet_name 03', sheetData: contentDefinitionData3},
        ]
    }
);

❯ Streaming

In case you want to export your Excel file server-side, pdfmake-to-excel provides the getStream() method which takes in an optionnal argument which is your response as the first argument.

• When the response argument is provided, the excel file is created and directly piped to your response.
• When the response argument is not provided, you'll get the stream itself. Up to you to pipe it wherever you want

❯ Example Using NestJS

@Get('/export-excel-file')
async exportReportExcel(@Res() response:Response):Promise < any > {
    const exporter = new ExcelConverter('FileTest', contentDefinition);

    // Automatic pipe to response
    await exporter.getStream(response);


    // Get the stream
    const stream = await exporter.getStream();

    // Then pipe it if you want
    stream.pipe(response);
}

❯ Example Using AdonisJS

const ExportService = use('App/Services/ExportService');

const {ExcelConverter} = require('pdfmake-to-excel')

class ExportController{
  async exportAction({request, response}){

    const executor = ExportService(request.all());
    const excelConverter = new ExcelConverter('test-filename.png', await executor.getData());

    response.implicitEnd = false;
    response.header('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
    response.header('Content-Transfer-Encoding', 'binary');
    response.header('Content-Disposition', `attachment; filename="fichier.xlsx"`)

    excelConverter.getStream().pipe(response.response);
  }
}
module.exports = ExportController;