Skip to content

Proof of concept Suitelet that exports Saved Search rows to Excel (XLSX file format) using xlsx.js library

License

Notifications You must be signed in to change notification settings

gmihaylov/netsuite-saved-search-export-excel-xlsx

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

NetSuite Saved Search Export in Excel (XLSX)

Proof of concept Suitelet that exports Saved Search rows to Excel (XLSX file format) using xlsx.js library

Script flow

  • Rows & Column data is taken from saved search
  • Array of sheets is created, each sheet has feed array (see Example feed array)

Options / Features

  • Saved search column labels are used for sheet headers
  • xlsx.js & jszip libraries are used for excel file generation (both located in sheetjs folder)
  • Concept can be used in Scheduled / MAP Reduce Scripts

Performance

  • Tested up to ~50k rows (5 columns)

More info

Check SheetJS https://docs.sheetjs.com/docs/demos/cloud/netsuite/

Example feed array (array of arrays):

[["Name","Document Number"],["1221","1"],["267","1"],["998","1"],["1249","1"],["83","1"],["472","1"],["842","1"],["1149","1"],["824","1"],["748","1"],["907","1"],["631","1"],["92","1"],["1044","1"],["823","1"],["630","1"],["1508","1"],["1049","1"],["1036","1"],["562","1"],["512","1"],["1670","2"],["1668","2"],["-5","2"]]

Screenshots

App Screenshot App Screenshot App Screenshot

About

Proof of concept Suitelet that exports Saved Search rows to Excel (XLSX file format) using xlsx.js library

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published