Nascent Plasticine Materialist
    Have ideas to improve npm?Join in the discussion! »

    object-to-csv

    1.0.5 • Public • Published

    object-to-csv

    Travis CI Build Status NPM version NPM downloads Dependency Status Dev Dependency Status

    A lightweight, robust & dependency-less Node.js module to convert JSON objects to CSV format.

    • Installation

    Latest version: 1.0.5

    npm install object-to-csv

    • Quick Start Example

    //1. Import the module
    const ObjectToCSV = require('object-to-csv');
     
    //2. Set data
    let data = [
        { 
          'make': 'Ford',
          'model': 'Mustang',
          'new': true
        },
    ];
     
    //3. Set up CSV
    let otc = new ObjectToCSV({ data });
     
    //4. Get CSV
    let csv = otc.getCSV();
     
    //Outputs:
    // "Make","Model","Is The Car New"
    // "Ford","Mustang","TRUE"
     

    • Tests

    npm test

    • Usage

    Using the ObjectToCSV module is easy. The setter methods return this which enables chaining functions. Warnings are presented when values are given which may cause issues with the module. Find everything else you need to know below.

    • Constructor

    The constructor of the ObjectToCSV module allows you to set all of the options up front in key/value format.

    Usage Example:

    let otc = new ObjectToCSV({
        'keys': [],
        'data': [],
        'fileName': 'test-file-name',
        'shouldExpandObjects': true,
        'endOfLineValue': '\n',
        'delimiter': ',',
        'quote': '"',
        'booleanValues': {'true':'Yes', 'false':'No'},
    });

    • Options


    keys

    Keys for first row of csv. Set the keys in an array of objects according to the format below. Using the key/as format allows for you to set the key in the data object and display the as within the final csv as a proper title for example.

    If empty, the keys in the first object of the array will be used as column names.

    • Type: Array
    • Default: []
    • Format: [ {key: '', as: ''}, ... ]

    Usage Example:

    let keys = [
        {
            key: 'make',
            as: 'Make',
        }
    ];
     
    //Set keys in 3 different ways
    let otc = new ObjectToCSV({ keys });
    // otc.setKeys(keys);
    // otc.keys = keys;
     
    //Get
    keys = otc.keys;

    data

    The data that fills the csv

    • Type: Array
    • Default: []
    • Format: [ {...}, ... ]

    Usage Example:

    let data = [
        { 
          'make': 'Ford',
          'model': 'Mustang',
          'new': true
        },
    ];
     
    //Set data in 3 different ways
    let otc = new ObjectToCSV({ data });
    // otc.setData(data);
    // otc.data = data;
     
    //Get
    data = otc.data;

    fileName

    The file name for downloading the csv.

    • Type: String
    • Default: file

    Usage Example:

    let fileName = 'file-name';
     
    //Set file name in 3 different ways
    let otc = new ObjectToCSV({ fileName });
    // otc.setFileName(fileName);
    // otc.fileName = fileName;
     
    //Get
    fileName = otc.fileName;

    shouldExpandObjects

    Should flatten nested objects. This is a boolean to check if JSON.stringify() should be used on arrays and objects within the data.

    • Type: Boolean
    • Default: false

    Usage Example:

    let shouldExpandObjects = false;
     
    //Set shouldExpandObjects in 3 different ways
    let otc = new ObjectToCSV({ shouldExpandObjects });
    // otc.setShouldExpandObjects(shouldExpandObjects);
    // otc.shouldExpandObjects = shouldExpandObjects;
     
    //Get
    shouldExpandObjects = otc.shouldExpandObjects;

    endOfLineValue

    Specify an end of line value for separating rows other than the default line ending.

    • Type: String
    • Default: \n

    Usage Example:

    let endOfLineValue = '\n';
     
    //Set endOfLineValue in 3 different ways
    let otc = new ObjectToCSV({ endOfLineValue });
    // otc.setEndOfLineValue(endOfLineValue);
    // otc.endOfLineValue = endOfLineValue;
     
    //Get
    endOfLineValue = otc.endOfLineValue;

    delimiter

    CSV delimiter of columns

    • Type: String
    • Default: ,

    Usage Example:

    let delimiter = ',';
     
    //Set delimiter in 3 different ways
    let otc = new ObjectToCSV({ delimiter });
    // otc.setDelimiter(delimiter);
    // otc.delimiter = delimiter;
     
    //Get
    delimiter = otc.delimiter;

    quote

    The quote around cell values and column names.

    • Type: String
    • Default: "

    Usage Example:

    let quote = '"';
     
    //Set quote in 3 different ways
    let otc = new ObjectToCSV({ quote });
    // otc.setQuote(quote);
    // otc.quote = quote;
     
    //Get
    quote = otc.quote;

    booleanValues

    The values to show if a boolean value is present in the data for the csv.

    • Type: Object
    • Default: { 'true': 'TRUE', 'false': 'FALSE' }
    • Format: { 'true': 'Yes', 'false': 'No' }

    Usage Example:

    let booleanValues = { 'true': 'Yes', 'false': 'No'  };
     
    //Set quote in 3 different ways
    let otc = new ObjectToCSV({ booleanValues });
    // otc.setBooleanValues(booleanValues);
    // otc.booleanValues = booleanValues;
     
    //Get
    booleanValues = otc.booleanValues;

    • Commands


    getCSV()

    Get CSV as a string from given attributes

    • Returns: String

    Usage Example:

    let otc = new ObjectToCSV();
    let csv = otc.getCSV();

    getResponseHeaders()

    Get response headers for sending a CSV download to the client

    • Returns: Object
    • Format: {'Content-Disposition': '...', 'Content-Type': '...'}

    Usage Example:

    let otc = new ObjectToCSV();
    let responseHeaders = otc.getResponseHeaders();
    let csv = otc.getCSV();
     
    //Example
    //1. Set up your server
    //In this case, we're just going to use the http module
    const http = require('http');
     
    //2. Create server
    http.createServer((req, res) => {
        const url = req.url;
     
        //3. Set up a route on your sever to download a test csv
        if (url == '/download') {
            res.setHeader('Content-Type', responseHeaders['Content-Type']);
            res.setHeader('Content-Disposition', responseHeaders['Content-Disposition']);
            res.write(csv, 'text/csv');
            res.end();
        }
    }).listen(8080);

    • Say Hi

    Tweet at me: @markmiscavage.

    • License

    MIT License

    Copyright (c) 2020 Mark Miscavage

    Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

    The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

    THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

    Install

    npm i object-to-csv

    DownloadsWeekly Downloads

    258

    Version

    1.0.5

    License

    MIT

    Unpacked Size

    34.1 kB

    Total Files

    9

    Last publish

    Collaborators

    • avatar