Package Exports

html-to-xlsx

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (html-to-xlsx) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

html-to-xlsx

node.js html to xlsx transformation

Transformation only supports html table and several basic style properties. No images or charts are currently supported.

var conversion = require("html-to-xlsx")();
conversion("<table><tr><td>cell value</td></tr></table>" }, function(err, stream){
  //readable stream to xlsx file
  stream.pipe(res);
});

Supported properties

background-color - cell background color
color - cell foreground color
border-left-style - as well as positions will be transformed into excel cells borders
text-align - text horizontal align in the excel cell
vertical-align - vertical align in the excel cell
width - the excel column will get the highest width, it can be little bit inaccurate because of pixel to excel points conversion
height - the excel row will get the highest height
font-size - font size
colspan - numeric value that merges current column with columns to the right
rowspan - numeric value that merges current row with rows below.
overflow - the excel cell will have text wrap enabled if this is set to scoll.

Options

var conversion = require("html-to-xlsx")({
  /* use rather dedicated process for every phantom printing,
      "dedicated-process" strategy is quite slower but can solve some bugs
      with corporate proxy, default is "phantom-server" */
  strategy: 'phantom-server', // 'dedicated-process' or 'phantom-server'
  /* number of allocated phantomjs processes */
    numberOfWorkers: 2,
    /* timeout in ms for html conversion, when the timeout is reached, the phantom process is recycled */
    timeout: 5000,
    /* directory where are stored temporary html and pdf files, use something like npm package reaper to clean this up */
    tmpDir: "os/tmpdir",
    /* optional port range where to start phantomjs server */
  portLeftBoundary: 1000,
  portRightBoundary: 2000,
  /* optional hostname where to start phantomjs server */
  host: '127.0.0.1'
});

Kill workers

// kill all phantomjs workers when using phantom-server strategy
conversion.kill();

License

See license