Class WorkBook

WorkBook

Class Summary
Constructor Attributes Constructor Name and Description
 
A Class to handle with all Nexcel WorkBook data related functionalities with Some UI for the Modals

Method Summary

Class Detail

WorkBook()
A Class to handle with all Nexcel WorkBook data related functionalities with Some UI for the Modals
require('WorkBook')

Method Detail

  • <static> WorkBook.addWorkBook(folderId, callBack)
    It opens the MDI for add workbook, this method contains the action listeners for the Ok and cancel Buttons.
    require('WorkBook').addWorkBook()
    Parameters:
    {Integer} folderId
    The folder id where which the workbook is created.
    {Function(wsId)} callBack
    the function will be called back after the workbook created, once the new id is recieved through Ajax, the call back will called through WorkBookDataService @example require('WorkBook').openWorkBook(wsId)
  • <static> WorkBook.duplicateWorkBook(callBack)
    It duplicates the workbook to a new workbook exactly the same hseet and data with groups.
    require('WorkBook').duplicateWorkBook()
    Parameters:
    {Function(wsId)} callBack
    the function will be called back after the workbook created, once the new id is recieved through Ajax, the call back will called through WorkBookDataService @example require('WorkBook').openWorkBook(wsId)
  • <static> WorkBook.getServiceURL()
    It returns the the web service URL,
    require('WorkBook').getServiceURL()
  • <static> WorkBook.getSheetObj(sheetId)
    It returns the sheet object by passing the sheetId.
    require('WorkBook').getSheetObj(sheetId)
    Parameters:
    {integer} sheetId
  • <static> WorkBook.getSheetObjByName(sheetName)
    It returns the the sheet Object by passing the name of the sheet.
    Parameters:
    {String} sheetName
  • <static> WorkBook.loadWorkBookSheetsCallBack(result)
    This is the call back function called after loading the list of Sheet present in the WorkBook, from the method NexcelController.init
    Parameters:
    {JSON} result
    the Ajx response from sheet request.
  • <static> WorkBook.openWorkBook(wsId)
    It opens new workbook with the provided workbook Id, It uses
    require('WorkBook').openWorkBook(12)
    Parameters:
    {Integer} wsId
    The workBook Id
  • <static> WorkBook.switchSheet(tab)
    UI Bases swich sheet action handler, once the user clicks on any sheet other than the active sheet, it will switch to the new sheet. It uses WorkBook.switchSheetAction(sheetId)
    Parameters:
    {DIV} tab
    The sheet Tab HTML Object
  • <static> WorkBook.switchSheetAction(sheetId)
    This function supports programmatic switching of the sheet by passing the sheetId
    Parameters:
    {Integer} sheetId
    The sheet Id