Create Microsoft Office Word Document Reference

Contents:

• Creating the document object
• The document object's settings

Creating the document object:

First, if you didn't have it yet, get access to the officegen module:

const officegen = require('officegen')

Now you have few ways to use it to create a xlsx based document. The simple way is to use this code:

let xlsx = officegen('xlsx')

But if you want to pass some settings then you should use the following format:

let xlsx = officegen({
	type: 'xlsx', // We want to create a Microsoft Excel document.
	... // Extra options goes here.
})

The document object's settings:

• author (string) - The document's author (part of the Document's Properties in Office).
• creator (string) - Alias. The document's author (part of the Document's Properties in Office).
• description (string) - The document's properties comments (part of the Document's Properties in Office).
• keywords (string) - The document's keywords (part of the Document's Properties in Office).
• orientation (string) - Either 'landscape' or 'portrait'. The default is 'portrait'.
• pageMargins (object) - Set document page margins. The default is { top: 1800, right: 1440, bottom: 1800, left: 1440 }
• subject (string) - The document's subject (part of the Document's Properties in Office).
• title (string) - The document's title (part of the Document's Properties in Office).

You can always change some of these settings after creating the xlsx object using there methods:

xlsx.setDocTitle('...')
xlsx.setDocSubject('...')
xlsx.setDocKeywords('...')
xlsx.setDescription( '...')
xlsx.setDocCategory('...')
xlsx.setDocStatus('...')

Fill cells:

// Using setCell:
sheet.setCell ( 'E7', 340 );
sheet.setCell ( 'G102', 'Hello World!' );

// Direct way:
sheet.data[0] = [];
sheet.data[0][0] = 1;
sheet.data[0][1] = 2;
sheet.data[1] = [];
sheet.data[1][3] = 'abc';