Nattily Primped Monster

    This package has been deprecated

    Author message:

    Please use @momsfriendlydevco/spreadsheet-templater

    @momsfriendlydevco/spreadsheet-handlebars

    0.0.0 • Public • Published

    Spreadsheet-Handlebars

    Handlebars integration for spreadhssets (via XLSX).

    This plugin allows a spreadsheet to use handlebars notation to replace cell contents which enables an input spreadsheet to act as a template for incomming data.

    var SpreadsheetHandlebars = require('@momsfriendlydevco/spreadsheet-handlebars');
    
    new SpreadsheetHandlebars('input.xlsx')
    	.data({...})
    	.apply()
    	.write('output.xlsx')

    API

    The module exposes a single object.

    Constructor(options | filename)

    Setup the object either with an options object or a template filename to use.

    set(key, [val])

    Set a single or multiple options (if key is an object). Lodash array and dotted notation is supported for the key.

    readTemplate()

    Parse the input template file. This function is automatically called if constructor is given a filename when initialized.

    apply([data])

    Apply the given data (or the data specified in options.data) to the loaded template.

    json()

    Convenience function to return the workbook as a JSON object This will return an object with each key as the sheet ID and a 2D array of cells

    Install

    npm i @momsfriendlydevco/spreadsheet-handlebars

    DownloadsWeekly Downloads

    1

    Version

    0.0.0

    License

    MIT

    Unpacked Size

    6.35 kB

    Total Files

    4

    Last publish

    Collaborators

    • mr-yellow
    • melromero
    • hash-bang
    • 1watt
    • eekthecat