Tag: excel

Exporting to Excel

You can export reports, searches and lists into various formats. Exporting provides you with additional flexibility in reviewing and analyzing your business’s data. Each export format has its own advantages and limitations as detailed below: Supported Versions – Only XLS files are supported. XLSX files are not supported. Expand/collapse – Settings are not maintained. All rows included… Continue reading Exporting to Excel

How to find the Duplicate values between two columns in NetSuite (Exact match)

Scenario: 2 Excel columns with a large number of data. We need to filter out or find only the common values which is available in both columns. For finding common values Type this formula in the 3rd column =FILTER(1st column data range,COUNTIF(2nd column data range,1st column data range)) Example: Using this formula we can filter… Continue reading How to find the Duplicate values between two columns in NetSuite (Exact match)

Excel Tips

Shift Between Different Excel FilesWhen you have different spreadsheets open, it’s really annoying shifting between different files because sometimes working on the wrong sheet can ruin the whole project. Using Ctrl + Tab you can shift between different files freely. 2. Create a New Shortcut MenuGenerally there are three shortcuts in the top menu, which… Continue reading Excel Tips

Extract xls file to Json

For implementing the function, need to implement excel js library function /** * file Extract function * @param {Number} fileId internal ID * @return {Object} returnDate Json Object */ function extractFileToJSON(fileId) { try { let returnData = []; let excelFile = file.load({ id: fileId }); let workbook = XLSX.read(excelFile.getContents(), {type: ‘base64’}); let firstSheetName = workbook.SheetNames[0];… Continue reading Extract xls file to Json

PROPOSAL FOR DOWNLOADING THE EXCEL FILE FROM QUOTE.

Proposal Summary  Add a new button for quote/estimate records called “Download excel”. In that button’s action, the excel file must be downloaded in excel format. The file must be named in the format “document number.xls”  Requirements  The “PROFORMA INVOICE” excel is downloaded from the quote/estimate record. The excel mockup will look like this.  Our Solution … Continue reading PROPOSAL FOR DOWNLOADING THE EXCEL FILE FROM QUOTE.

The Index Function

The INDEX function returns the value at a given location in a range or array. INDEX is a powerful and versatile function. You can use INDEX to retrieve individual values, or entire rows and columns. INDEX is frequently used together with the MATCH function. In this scenario, the MATCH function locates and feeds a position to the… Continue reading The Index Function