Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.load(options)

{workbook}.load({id: {string*}})

N/workbook Module
workbook.load()
Method Description: Loads an existing workbook. Once you load a workbook, you can execute a table and view the results.
Returns: workbook.Workbook
Supported Script Types: Server scripts For more information, see SuiteScript 2.0 Script Types.
Governance: 10 units
Module: N/workbook Module
Sibling Module Members: N/workbook Module Members
Since: 2020.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.load(options)

Example:

// Code Example 1
// Add additional code
//...
var myWorkbook = workbook.load({
id: myWorkbookId
});

log.debug({
title: 'myWorkbook id: ',
details: myWorkbook.id
});
log.debug({
title: 'myWorkbook name: ',
details: myWorkbook.name
});
log.debug({
title: 'myWorkbook description: ',
details: myWorkbook.description
});
log.debug({
title: 'myWorkbook char definitions: ',
details: myWorkbook.chartDefinitions
});
log.debug({
title: 'myWorkbook pivot definitions: ',
details: myWorkbook.pivotDefinitions
});
log.debug({
title: 'myWorkbook table definitions: ',
details: myWorkbook.tableDefinitions
});

var myTableView = myWorkbook.runTable({
id: myTableId,
});

log.debug({
title: 'myWorkbook Table',
debug: myTableView
});

var myPagedTableView = myWorkbook.runTablePaged({
id: myTableId,
pageSize: 25
});

log.debug({
title: 'myWorkbook Paged Table',
debug: myPagedTableView
});
//...
// Add additional code

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_159052020752.html