Introduction

This module contains functions to deal with excel files.

Installation

Install via npm:

npm i os-excel-handler

Usage

Require excel handler:

var eh = require("os-excel-handler")

Functions and signatures:

/**
 * Will merge a few cells together.
 *
 * @param sheet -> the sheet you work on
 * @param cellIdStart -> like A1
 * @param cellIdEnd -> like A2
 */
mergeCells(sheet, cellIdStart, cellIdEnd)

/**
 * Will set a default font to all of the empty cells in the sheet.
 */
setFontInAllEmptyCells(sheet, name='Arial', size=12, bold=false, italic=false)

/**
 * Will fit the column width to be in the size of the biggest line in the column
 */
fitColumnWidthToText(sheet, colLetter)

/**
 * Also called wrap text. Will set the height of the line to be in the size of the cell content.
 */
wrapText(sheet, cellId) 

/**
 * Will align the text in the cell to be in the middle and center
 */
alignCenter(sheet, cellId)

/**
 * Will read a value from a given cell identifier
 *
 * @param sheet -> the current sheet obj
 * @param cellId -> row and column identifier. Like A4
 */
readValue(sheet, cellId)

/**
 * Will set a value in a given cell id
 *
 * @param sheet -> the current sheet obj
 * @param cellId -> row and column identifier. Like A4
 * @param value -> the value you would like to write
 * @param fontName -> the name of the font in the cell
 * @param fontSize -> the font size in the cell
 * @param bold -> font bold toggle
 * @param italic -> font italic toggle
 */
setValue(sheet, cellId, value, fontName='Arial', fontSize=12, bold=false, italic=false)

/**
 * Will add a sheet to the workbook
 */
createSheet(wb, sheetName, rtl = false)

/**
 * Will create a new workbook to start the work on
 */
createWorkbook()

/**
 *  Will save the workbook in a given path
 */
saveWorkbook: async function (wb, workbookPath)

/**
 * Will set the background color of a given cell
 */
setCellBackgroundColor(sheet, cellId, hexColor)

/**
 * Will set the text color of the text in a given cell
 */
setCellTextColor(sheet, cellId, hexColor)

And more...

Links -> see more tools

• os-tools-npm -> This module contains fundamental functions to implement in an npm project
• os-file-handler-npm -> This module contains fundamental files manipulation functions to implement in an npm project
• os-file-stream-handler-npm -> This module contains read/write and more advanced operations on files
• os-xml-handler-npm -> This module will build, read and manipulate an xml file. Other handy stuff is also available, like search for specific nodes

GitHub - osfunappsapps

Licence

ISC