Node.js: create an excel file with multiple tabs.

-



This article is a sample code to generate an excel file with multiple tabs using excel4node module.

Install: npm i excel4node

Let's see the sample code,

var excel = require('excel4node');

// Create a new instance of a Workbook class
var workbook = new excel.Workbook();

// Add Worksheets to the workbook
var worksheet = workbook.addWorksheet('Buy order types');
var worksheet1 = workbook.addWorksheet('Sell order types');

// Style for headers
var style = workbook.createStyle({
  font: {
    color: '#EA3A14',
    size: 18
  },
  numberFormat: '$#,##0.00; ($#,##0.00); -'
});

var styleForData = workbook.createStyle({
  font: {
    color: '#47180E',
    size: 12
  },
  alignment: {
    wrapText: true,
    horizontal: 'center',
  },
  numberFormat: '$#,##0.00; ($#,##0.00); -'
});

let buyOrderTypes=[
{name:"buy",id:"1",comment:"Normal Buy Order"},

{name:"sip",id:"2",comment:"Sip Buy Order"},

{name:"buy",id:"3",comment:"ETF Buy Order"},
]

let sellOrderTypes=[
  {name:"sell",id:"1",comment:"Normal Sell Order"},

  {name:"emergencysell",id:"2",comment:"Emergency sell order"},
  
  {name:"coin",id:"3",comment:"Coin orders"},
  {name:"jewellery",id:"4",comment:"Jewellery orders"},

]


//Tab 1 headers
worksheet.cell(1,1).string('Type').style(style);
worksheet.cell(1,2).string('Id').style(style);
worksheet.cell(1,3).string('Description').style(style);


//Tab 2 headers
worksheet1.cell(1,1).string('Type').style(style);
worksheet1.cell(1,2).string('Id').style(style);
worksheet1.cell(1,3).string('Description').style(style);

//Some logic
function generateExcelSheet(array,worksheet){
  let row=2;//Row starts from 2 as 1st row is for headers.
  for(let i in array){
    let o=1;
    //This depends on numbers of columns to fill.
    worksheet.cell(row,o).string(array[i].name).style(styleForData);
    worksheet.cell(row,o+1).string(array[i].id).style(styleForData);
    worksheet.cell(row,o+2).string(array[i].comment).style(styleForData);

    row=row+1;
  }
}

generateExcelSheet(buyOrderTypes,worksheet);

generateExcelSheet(sellOrderTypes,worksheet1)
workbook.write('Excel.xlsx');


I hope you like this article and if any doubts please let me know in the comment section.


Don't forget to subscribe to this blog.
You can also follow me on Twitter or Linkedin for the latest updates.

Written By:



Saurabh Joshi






Comments

Post a Comment

Popular posts from this blog

Node JS:Understanding bin in package.json.

-
Image
Well as a Node Js developer we know package.json as dependency file where we keep a note of all dependencies of our project. Here we will be looking at what is bin in package.json? To understand this we first need to understand command line application and it's purpose. CLI applications are mostly used to automate things such as deployments of application,running tests,building reports and the list goes on and on. So lets start with creating our first CLI application. First, let’s make sure you have the tools required. To complete this tutorial, you will need the following: 1)A recent version of Node.js downloaded and installed 2)A good text editor, such as Visual Studio Code Next, open your computer’s command prompt (Windows) or terminal (macOS/Linux). Change the current directory to the folder where you save your documents or projects. Enter the following commands to create a new project folder and initialize the project. mkdir hello-cli cd hello-cli npm init Nex
Read more

Node.js: Downloading a xml file from given url and reading its data elements.

-
Image
In this article, we will see how we can download an XML file from a given URL and then access its elements. This can be used in many cases, for example, scraping data from a site which has data in the XML file or multiple files. The article is pretty short and most of it is just self-explanatory code. Also nowadays, you can get a lot of freelance jobs in data scrapping as data is the new oil today so this might be helpful. So let's begin with the code, var fs = require('fs') var https = require('https');//For accessing https url we need this module instead of http. var xml2js = require('xml2js');//Required for xml parsing. var file_name = 'data.xml'//This will be the name of file we will be generating. var DOWNLOAD_DIR =__dirname+'/'; //This function reads data from URL and writes data into new file //with respect to the given name and directory path. function download(){  var file_url='https://www.w3schools.com/xml/n
Read more