@rodewitsch/carbone

This is a fork of the carbone module. Added support for images, improved work with tables, formulas, graphs.

Original README.md

---

Fast, Simple and Powerful report generator in any format PDF, DOCX, XLSX, ODT, PPTX, ODS, XML, CSV...

... using your JSON data as input !

Table of content

• Features
• How it works?
• Minimum Requirements
  • Optional
• Getting started
  • Basic sample
  • PDF generation, document conversion
• More examples
• API Reference
• Command line tools
• Performance
• Licenses and editions
• Philosophy
• Roadmap
• Contributors

Features

• Extremely simple : Use only LibreOffice™, OpenOffice™ or Microsoft Office™ to draw your report
• Unlimited design : The limit is your document editor: pagination, headers, footers, tables...
• Convert documents : thanks to the integrated document converter
• Unique template engine : Insert JSON-like markers {d.companyName} directly in your document
• Flexible : Use any XML documents as a template: docx, odt, ods, xlsx, html, pptx, odp, custom xml files...
• Future-proof : A powerful XML-agnostic algorithm understands what to do without knowing XML document specifications
• Multilingual : One template, multiple languages. Update translation files automatically
• Format data : Use built-in date and number formatters or create your own in Javascript
• Fast : Manage multiple LibreOffice threads for document conversion, optimized code generation for each report

How it works?

Carbone is a mustache-like template engine {d.companyName}.

Template language documentation : https://carbone.io/documentation.html

• The template can be any XML-document coming from LibreOffice™ or Microsoft Office™ (ods, docx, odt, xslx...)
• The injected data must be a JSON object or array, coming directly from your existing APIs for example

Carbone analyzes your template and inject data in the document. The generated document can be exported as is, or converted to another format (PDF, ...) using LibreOffice if it is installed on the system. Carbone is working only on the server-side.

Minimum Requirements

• NodeJS 8.x+
• Runs on OSX, Linux (servers and desktop), and coming soon on Windows

Optional

• LibreOffice server if you want to use the document converter and generate PDF. Without LibreOffice, you can still generate docx, xlsx, pptx, odt, ods, odp, html as long as your template is in the same format.

Getting started

Basic sample

1 - Install it

  npm install carbone

2 - Copy-paste this code in a new JS file, and execute it with node

  const fs = require('fs');
  const carbone = require('carbone');

  // Data to inject
  var data = {
    firstname : 'John',
    lastname : 'Doe'
  };

  // Generate a report using the sample template provided by carbone module
  // This LibreOffice template contains "Hello {d.firstname} {d.lastname} !"
  // Of course, you can create your own templates!
  carbone.render('./node_modules/carbone/examples/simple.odt', data, function(err, result){
    if (err) {
      return console.log(err);
    }
    // write the result
    fs.writeFileSync('result.odt', result);
  });

PDF generation, document conversion

Carbone uses efficiently LibreOffice to convert documents. Among all tested solutions, it is the most reliable and stable one in production for now.

Carbone does a lot of thing for you behind the scene:

• starts LibreOffice in "server-mode": headless, no User Interface loaded
• manages multiple LibreOffice workers to maximize performance (configurable number of workers)
• automatically restarts LibreOffice worker if it crashes or does not respond
• job queue, re-try conversion three times if something bad happen

1 - install LibreOffice

on OSX

• Install LibreOffice normally using the stable version from https://www.libreoffice.org/

on Ubuntu Server & Ubuntu desktop

Be careful, LibreOffice which is provided by the PPA libreoffice/ppa does not bundled python (mandatory for Carbone). The best solution is to download the LibreOffice Package from the official website and install it manually:

  # remove all old version of LibreOffice
  sudo apt remove --purge libreoffice*
  sudo apt autoremove --purge

  # Download LibreOffice debian package. Select the right one (64-bit or 32-bit) for your OS.
  # Get the latest from http://download.documentfoundation.org/libreoffice/stable
  # or download the version currently "carbone-tested":
  wget https://downloadarchive.documentfoundation.org/libreoffice/old/5.3.2.2/deb/x86_64/LibreOffice_5.3.2.2_Linux_x86-64_deb.tar.gz

  # Install required dependencies on ubuntu server for LibreOffice 5.0+
  sudo apt install libxinerama1 libfontconfig1 libdbus-glib-1-2 libcairo2 libcups2 libglu1-mesa libsm6

  # Uncompress package
  tar -zxvf LibreOffice_5.3.2.2_Linux_x86-64_deb.tar.gz
  cd LibreOffice_5.3.2.2_Linux_x86-64_deb/DEBS

  # Install LibreOffice
  sudo dpkg -i *.deb

  # If you want to use Microsoft fonts in reports, you must install the fonts
  # Andale Mono, Arial Black, Arial, Comic Sans MS, Courier New, Georgia, Impact,
  # Times New Roman, Trebuchet, Verdana,Webdings)
  sudo apt install ttf-mscorefonts-installer

  # If you want to use special characters, such as chinese ideograms, you must install a font that support them
  # For example:
  sudo apt install fonts-wqy-zenhei

2 - generate PDF

And now, you can use the converter, by passing options to render method.

Don't panic, only the first conversion is slow because LibreOffice must starts Once started, LibreOffice stays on to make new conversions faster

  var data = {
    firstname : 'John',
    lastname : 'Doe'
  };

  var options = {
    convertTo : 'pdf' //can be docx, txt, ...
  };

  carbone.render('./node_modules/carbone/examples/simple.odt', data, options, function(err, result){
    if (err) return console.log(err);
    fs.writeFileSync('result.pdf', result);
    process.exit(); // to kill automatically LibreOffice workers
  });

More examples

Nested repetition in a docx document and spreadsheet

  var data = [
    {
      movieName : 'Matrix',
      actors    : [{
        firstname : 'Keanu',
        lastname  : 'Reeves'
      },{
        firstname : 'Laurence',
        lastname  : 'Fishburne'
      },{
        firstname : 'Carrie-Anne',
        lastname  : 'Moss'
      }]
    },
    {
      movieName : 'Back To The Future',
      actors    : [{
        firstname : 'Michael',
        lastname  : 'J. Fox'
      },{
        firstname : 'Christopher',
        lastname  : 'Lloyd'
      }]
    }
  ];

  carbone.render('./node_modules/carbone/examples/movies.docx', data, function(err, result){
    if (err) return console.log(err);
    fs.writeFileSync('movies_result.docx', result);
  });

  carbone.render('./node_modules/carbone/examples/flat_table.ods', data, function(err, result){
    if (err) return console.log(err);
    fs.writeFileSync('flat_table_result.ods', result);
  });

API Reference

To check out the api reference and the documentation, visit carbone.io.

Command line tools

To checkout out the Carbone CLI documentation, visit carbone.io

Issues

If you're facing any issues, search a similar issue to ensure it doesn't already exist on Github. Otherwhise, create an issue to help us.

Roadmap

The roadmap is pinned on on the github issues list.

Performance

Report generation speed (without network latency), using a basic one-page DOCX template:

• ~ 10 ms / report without document conversion (analyzing, injection, rendering)
• ~ 50 ms / report with a PDF conversion (100 loops, 3 LibreOffice workers, without cold-start)

On a MacBook Pro Mid-2015, 2,2 Ghz i7, 16Go.

It could be even better when "code cache" will be activated. Coming soon...

Licenses and editions

There are two editions of Carbone:

• Carbone Community Edition is available freely under the Apache v2 license
• Carbone Enterprise Edition (hosted and on-premise) includes extra features like a user interface.

We want to follow the model of Gitlab. The free version must be and must stay generous.

Philosophy

Our ultimate goal

2% percent of our hosted solution revenues will go to charity in three domains: open source software we love, education and environment.

We already know that beneficiaries will be, at least :heart:

• LibreOffice foundation
• PostgreSQL foundation
• An innovative child school in France

Contributors

Thanks to all Ideolys's direct contributors (random order)

• Florian Bezagu
• Matthieu Robin
• Arnaud Lelièvre
• Maxime Vincent
• Enzo Ghemard
• Jordan Nourry
• Etienne Rouillard
• Guillaume Chevaux
• Fabien Bigant
• Maxime Magne
• Vincent Bertin
• Léo Labruyère
• Aurélien Kermabon
• Steeve Payraudeau

Thanks to all French citizens (Crédit Impôt Recherche, Jeune Entreprise Innovante, BPI)!

Changes:

API:

Usage (callback style):

carbone.renderCallback('template.docx', data, (err, result, templateName) => {
  if(err) {
    console.error(err);
  } else {
    fs.writeFileSync('result.docx', result);
  }
});

or:

carbone.render('template.docx', data, (err, result, templateName) => {
  if(err) {
    console.error(err);
  } else {
    fs.writeFileSync('result.docx', result);
  }
});

Usage (promise style):

carbone.renderPromise('template.docx', data))
.then(({ result }) => {
   fs.writeFileSync('result.docx', result);
})
.catch((err) => console.error(err));

or

carbone.render('template.docx', data))
.then(({ result }) => {
   fs.writeFileSync('result.docx', result);
})
.catch((err) => console.error(err));

Usage (promise style, executes in worker):

carbone.renderParallel('template.docx', data))
.then(({ result }) => {
   fs.writeFileSync('result.docx', result);
})
.catch((err) => console.error(err));

DOCX:

HTML (minimal)

---

Added formatter :html()

Example: {d.html:html()}

Original	Current

IMAGES

---

Added formatter :imageSize(width[,height])

Example: {d.image:imageSize(100,200)}

Original	Current

XLSX:

IMAGES

---

Added formatter :imageSize(width[,height])

Example: {d.image:imageSize(100,200)}

Original	Current

CHARTS

---

Original	Current

FORMULAS

---

Original	Current

MERGED CELLS

---

Original	Current

PRINTING AREA

---

Original	Current