Nightmarish Pawnshop Mystic

    xlconverter

    2.0.0 • Public • Published

    Nowdays everything is easly maintain if we are dealing with objects .As I have face many problems while in uploading excel file ,taking data from excel and play with each Cell of excel file .This Converter is just a interface which helps to get objects from excel Or excel from objects.

    link https://github.com/hardy12994/xlconverter

    Here are the two Converters and Some Getters (define below) present in it :

    • Excel to Objects
    • Objects to Excel

    Excel to Objects

     
    let xlconverter = require('xlconverter');
     
     let path="abv/cac/ac/ac.xlsx";
     let sheet="sheet1";
     
     
     // xlToObjects, will provide objects of all the sheets present in xl sheet;
     
      xlconverter.xlToObjects(path, function (err, data) {
          console.log(err);
          console.log(data);
      });
     
     
     /**
     * data-
     *
     * [{},{},{}]
     * // object as rows
     */
     
     
     // xlToObjectsOfSheet, will provide objects of perticular sheet present in xl sheet;
     
      xlconverter.xlToObjectsOfSheet(path, sheet, function (err, data) {
          console.log(err);
          console.log(data);
      });
     
       /**
       * data -
       * {
       *   sheet1: [{},{},{}],
       *   sheet2: [{},{},{}]
       * }
       * // object as rows
       */
      
     

    Objects to Excel

     
         let headers=["name","age"];
         let rows=[{ name:"hardy",age:21 },{ name:"hardy",age:21 }];
         let path="abc/cac/";
         let fileName="myNewSheet"; //.xlsx is by default
         let sheetName="sheet1";
     
         xlconverter.objectsToXl(headers, rows, path, fileName, sheetName, function (err, data) {
             console.log(err);
             console.log(data); 
         });
     
          /**
          * if error -`sheetName` sheet not created
          * data -
          * `sheetName` sheet successfully created.
          */
     

    Getters

    We can use Excel Sheet as a very small Database as we can do Extractions from that by putting some queries, The query can be made in form of Objects, Arrays Thing can be achive like:

    • Any Perticular Row.
    • Any Perticular Column.
    • Get Number of Rows.
    • Get Number of Columns.
    • Get Data as Objects of Perticular Columns.

    Get Row

    • Accept Query as Object Eg- {name:"Jhon",age:"21"}.
    • and type of query will be done.
    • Return Single Row which matches both Conditions First.
     
         let rowQuery= {name:"Jhon",age:"21"};
         let filePath="abc/cac/";
         let sheetName="sheet1";
         
         xlconverter.getters.row(filePath, rowQuery, sheetName, function (err, data) {
             console.log(err);
             console.log(data); 
         });
     
        /**
        * data-
        *
        * {name:"Jhon", age:"21", f_name:"D_Jhon"}
        * // object as rows
        */
     
     

    Get Rows

    • Accept Parameters as Object Eg- {name:"Jhon",age:"21"}.
    • and type of query will be done.
    • Return Multiple Rows which matches both Conditions.
     
         let rowQuery= {name:"Jhon",age:"21"};
         let filePath="abc/cac/";
         let sheetName="sheet1";
         
         xlconverter.getters.rows(filePath, rowQuery, sheetName, function (err, data) {
             console.log(err);
             console.log(data); 
         });
     
        /**
        * data-
        *
        * [{name:"Jhon", age:"21", f_name:"D_Jhon"},
        * {name:"Jhon", age:"21", f_name:"D_Jhonee"}]
        * // object as rows
        */
     

    Get Column

    • Accept Parameters as String Eg- "name".
    • Return Array of Strings which is Present in that Column.
     
         let colQuery= "name";
         let filePath="abc/cac/";
         let sheetName="sheet1";
         
         xlconverter.getters.coloumn(filePath, colQuery, sheetName, function (err, data) {
             console.log(err);
             console.log(data); 
         });
     
        /**
        * data-
        *
        * ["Jhon","Jhon2","Jhon3"]
        * // as coloumn cells
        */
     

    Get Columns

    • Accept Parameters as String in Array Eg- ["name","age"].
    • Return Object with Keys name and age and both of them have Array of Strings which is Present in respective Column.
     
         let colQuery= ["name","age"];
         let filePath="abc/cac/";
         let sheetName="sheet1";
         
         xlconverter.getters.coloumns(filePath, colQuery, sheetName, function (err, data) {
             console.log(err);
             console.log(data); 
         });
     
        /**
        * data-
        *
        * {
        *  name:["Jhon","Jhon2","Jhon3"],
        *  age:[21,33,13]
        * }
        * // as coloumn cells
        */
     

    Get Rows from Selective Columns

    • Accept Parameters as String in Array Eg- ["name","age"].
    • Return all Rows with Selected Columns name and age as Objects in Array
    • Getting Selective Coloumns of Rows.
     
         let colQuery= ["name","age"];
         let filePath="abc/cac/";
         let sheetName="sheet1";
         
         xlconverter.getters.selectiveColoumnsOfRows(filePath, colQuery, sheetName, function (err, data) {
             console.log(err);
             console.log(data); 
         });
     
        /**
        * data-
        *
        * [
        *   {name: "hardy", age: 12},
        *   {name: "pery", age: 41},
        *   {name: "bob", age: 42}
        *  ]
        * // 
        */
     

    N O T E :

    • callback function is required in all methods.
    • getters are using xlToObjectsOfSheet function that's why sheet name is required.

    Contributions are most wellcome

    Install

    npm i xlconverter

    DownloadsWeekly Downloads

    6

    Version

    2.0.0

    License

    ISC

    Unpacked Size

    16.3 kB

    Total Files

    7

    Last publish

    Collaborators

    • hardeep.singh