This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello everyone,
How to read data using Suitelet from an Excel file present in File cabinate and manipulate data by applying some filters using Suitelet script??

try very hard to not accept excel as an input

otherwise you will have to learn <https://sheetjs.com/>

Would be much better if the excel was converted to a CSV format before adding to the file cabinet. This can easily be done with your spreadsheet program.
I have successfully loaded <https://www.papaparse.com/|Papa Parse> as a module and used within scripts to parse CSV files.
Then when you have in the file cabinet you would use the 'N/file' to read the file contents and pass to the parser.

Thanks <@U5TF1GQ20> &amp; <@U03LV2A09JQ> I’ll go with Papa Parse!! it looks good

<@U03LV2A09JQ> can I directly load this Papa Parse library in suitelet script and use it?? to show csv file data in suitelet and can manupulate that data??

This is how I load it in.

```/**
 * @NApiVersion 2.1
 * @NScriptType ScheduledScript
 */
// eslint-disable-next-line no-undef
define(['../cafb-scripts/modules/papaparse.min'],
    /**
     * @param Papa
     */
    (Papa) =&gt; {```
As far as loading it into a suitelet you can do that through a JSON object for manipulation. Then convert back to CSV using Papa Parse.

There is supposed to be a way to load third-party scripts using a JSON config and the following.
```@NAmdConfig  ./JsLibraryConfig.json```
but I have never got it to work.

I was thinking of using below code instead!!

```define(["N/file"], function (f) {

    /**
     * Custom module for executing N/file cookbook examples
     *
     * @NApiVersion 2.0
     * @NModuleScope SameAccount
     */
    var exports = {};

    function readFile(response) {
        var weatherFile = f.load({id: "SuiteScripts/weather.csv"});

        var weatherData = [];
        weatherFile.lines.iterator().each(function (line) {
            var w = line.value.split(",");
            weatherData.push({date: w[0], low: w[1], high: w[2]});
            return true;
        });

        response.write({output: JSON.stringify(weatherData)});
    }

    exports.readFile = readFile;
    return exports;
});```