@sheetkit/node / Workbook
Class: Workbook
Defined in: packages/sheetkit/index.ts:1641
Excel workbook for reading and writing .xlsx files.
Constructors
Constructor
new Workbook():
Workbook
Defined in: packages/sheetkit/index.ts:1644
Returns
Workbook
Accessors
sheetNames
Get Signature
get sheetNames():
string[]
Defined in: packages/sheetkit/index.ts:1732
Get the names of all sheets in workbook order.
Returns
string[]
Methods
addChart()
addChart(
sheet,fromCell,toCell,config):void
Defined in: packages/sheetkit/index.ts:1987
Add a chart to a sheet.
Parameters
sheet
string
fromCell
string
toCell
string
config
Returns
void
addComment()
addComment(
sheet,config):void
Defined in: packages/sheetkit/index.ts:2082
Add a comment to a cell.
Parameters
sheet
string
config
Returns
void
addDataValidation()
addDataValidation(
sheet,config):void
Defined in: packages/sheetkit/index.ts:2052
Add a data validation rule to a sheet.
Parameters
sheet
string
config
Returns
void
addFormControl()
addFormControl(
sheet,config):void
Defined in: packages/sheetkit/index.ts:2022
Add a form control to a sheet.
Parameters
sheet
string
config
Returns
void
addImage()
addImage(
sheet,config):void
Defined in: packages/sheetkit/index.ts:1992
Add an image to a sheet.
Parameters
sheet
string
config
Returns
void
addPerson()
addPerson(
input):string
Defined in: packages/sheetkit/index.ts:2122
Add a person to the person list. Returns the person ID.
Parameters
input
Returns
string
addPivotTable()
addPivotTable(
config,options?):void
Defined in: packages/sheetkit/index.ts:2428
Add a pivot table using finite dense source traversal limits.
Parameters
config
options?
Returns
void
addShape()
addShape(
sheet,config):void
Defined in: packages/sheetkit/index.ts:1997
Add a shape to a sheet, anchored between two cells.
Parameters
sheet
string
config
Returns
void
addSlicer()
addSlicer(
sheet,config):void
Defined in: packages/sheetkit/index.ts:2473
Add a slicer to a sheet targeting a table column.
Parameters
sheet
string
config
Returns
void
addSparkline()
addSparkline(
sheet,config):void
Defined in: packages/sheetkit/index.ts:2443
Add a sparkline to a worksheet.
Parameters
sheet
string
config
Returns
void
addStyle()
addStyle(
style):number
Defined in: packages/sheetkit/index.ts:1952
Add a style definition. Returns the style ID for use with setCellStyle.
Parameters
style
Returns
number
addTable()
addTable(
sheet,config):void
Defined in: packages/sheetkit/index.ts:2458
Register a table in the workbook.
Parameters
sheet
string
config
Returns
void
addThreadedComment()
addThreadedComment(
sheet,cell,input):string
Defined in: packages/sheetkit/index.ts:2097
Add a threaded comment to a cell. Returns the comment ID.
Parameters
sheet
string
cell
string
input
Returns
string
applyStreamWriter()
applyStreamWriter(
writer):number
Defined in: packages/sheetkit/index.ts:2147
Apply a stream writer's output to the workbook. Returns the sheet index.
Parameters
writer
Returns
number
calculateAll()
calculateAll(
limits?):void
Defined in: packages/sheetkit/index.ts:2423
Recalculate all formula cells in the workbook.
Parameters
limits?
Returns
void
copySheet()
copySheet(
source,target):number
Defined in: packages/sheetkit/index.ts:1847
Copy a sheet. Returns the new sheet's 0-based index.
Parameters
source
string
target
string
Returns
number
deleteCellHyperlink()
deleteCellHyperlink(
sheet,cell):void
Defined in: packages/sheetkit/index.ts:2298
Delete a hyperlink from a cell.
Parameters
sheet
string
cell
string
Returns
void
deleteChart()
deleteChart(
sheet,cell):void
Defined in: packages/sheetkit/index.ts:2002
Delete a chart anchored at the given cell.
Parameters
sheet
string
cell
string
Returns
void
deleteConditionalFormat()
deleteConditionalFormat(
sheet,sqref):void
Defined in: packages/sheetkit/index.ts:2077
Delete conditional formatting for a specific cell range.
Parameters
sheet
string
sqref
string
Returns
void
deleteCustomProperty()
deleteCustomProperty(
name):boolean
Defined in: packages/sheetkit/index.ts:2194
Delete a custom property. Returns true if it existed.
Parameters
name
string
Returns
boolean
deleteDefinedName()
deleteDefinedName(
name,scope?):void
Defined in: packages/sheetkit/index.ts:2518
Delete a defined name by name and optional scope.
Parameters
name
string
scope?
string | null
Returns
void
deleteFormControl()
deleteFormControl(
sheet,index):void
Defined in: packages/sheetkit/index.ts:2032
Delete a form control by index.
Parameters
sheet
string
index
number
Returns
void
deletePicture()
deletePicture(
sheet,cell):void
Defined in: packages/sheetkit/index.ts:2007
Delete a picture anchored at the given cell.
Parameters
sheet
string
cell
string
Returns
void
deletePivotTable()
deletePivotTable(
name):void
Defined in: packages/sheetkit/index.ts:2438
Delete a pivot table by name.
Parameters
name
string
Returns
void
deleteSheet()
deleteSheet(
name):void
Defined in: packages/sheetkit/index.ts:1837
Delete a sheet by name.
Parameters
name
string
Returns
void
deleteSlicer()
deleteSlicer(
sheet,name):void
Defined in: packages/sheetkit/index.ts:2483
Delete a slicer by name from a sheet.
Parameters
sheet
string
name
string
Returns
void
deleteTable()
deleteTable(
sheet,name):void
Defined in: packages/sheetkit/index.ts:2468
Delete a table from a sheet by name.
Parameters
sheet
string
name
string
Returns
void
deleteThreadedComment()
deleteThreadedComment(
sheet,commentId):void
Defined in: packages/sheetkit/index.ts:2112
Delete a threaded comment by ID.
Parameters
sheet
string
commentId
string
Returns
void
duplicateRow()
duplicateRow(
sheet,row):void
Defined in: packages/sheetkit/index.ts:1877
Duplicate a row (1-based).
Parameters
sheet
string
row
number
Returns
void
evaluateFormula()
evaluateFormula(
sheet,formula,limits?):CellValue
Defined in: packages/sheetkit/index.ts:2415
Evaluate a formula string against the current workbook data.
Parameters
sheet
string
formula
string
limits?
Returns
fillFormula()
fillFormula(
sheet,range,formula,limits?):void
Defined in: packages/sheetkit/index.ts:2410
Fill a range with a formula using finite mutation limits.
Parameters
sheet
string
range
string
formula
string
limits?
Returns
void
fromJSON()
fromJSON(
sheet,data,options?):void
Defined in: packages/sheetkit/index.ts:2741
Write an array of JSON objects to a sheet.
Parameters
sheet
string
data
Record<string, CellValue>[]
options?
Returns
void
getActiveSheet()
getActiveSheet():
string
Defined in: packages/sheetkit/index.ts:1857
Get the name of the active sheet.
Returns
string
getAppProps()
getAppProps():
JsAppProperties
Defined in: packages/sheetkit/index.ts:2179
Get application properties.
Returns
getCellFormattedValue()
getCellFormattedValue(
sheet,cell):string
Defined in: packages/sheetkit/index.ts:1796
Get the formatted display text for a cell, applying its number format.
Parameters
sheet
string
cell
string
Returns
string
getCellHyperlink()
getCellHyperlink(
sheet,cell):JsHyperlinkInfo|null
Defined in: packages/sheetkit/index.ts:2293
Get hyperlink information for a cell, or null if no hyperlink exists.
Parameters
sheet
string
cell
string
Returns
JsHyperlinkInfo | null
getCellRichText()
getCellRichText(
sheet,cell):JsRichTextRun[] |null
Defined in: packages/sheetkit/index.ts:2493
Get rich text runs for a cell, or null if not rich text.
Parameters
sheet
string
cell
string
Returns
JsRichTextRun[] | null
getCellStyle()
getCellStyle(
sheet,cell):number|null
Defined in: packages/sheetkit/index.ts:1957
Get the style ID applied to a cell, or null if default.
Parameters
sheet
string
cell
string
Returns
number | null
getCellValue()
getCellValue(
sheet,cell):CellValue
Defined in: packages/sheetkit/index.ts:1785
Get the value of a cell. A formula cell returns a FormulaValue with its cached result.
Parameters
sheet
string
cell
string
Returns
getColOutlineLevel()
getColOutlineLevel(
sheet,col):number
Defined in: packages/sheetkit/index.ts:1937
Get the outline level of a column. Returns 0 if not set.
Parameters
sheet
string
col
string
Returns
number
getCols()
getCols(
sheet,options?):JsColData[]
Defined in: packages/sheetkit/index.ts:2400
Get all occupied columns using finite sparse traversal limits.
Parameters
sheet
string
options?
Returns
getColStyle()
getColStyle(
sheet,col):number
Defined in: packages/sheetkit/index.ts:1982
Get the style ID for a column. Returns 0 if not set.
Parameters
sheet
string
col
string
Returns
number
getColVisible()
getColVisible(
sheet,col):boolean
Defined in: packages/sheetkit/index.ts:1927
Get whether a column is visible.
Parameters
sheet
string
col
string
Returns
boolean
getColWidth()
getColWidth(
sheet,col):number|null
Defined in: packages/sheetkit/index.ts:1917
Get the width of a column, or null if not explicitly set.
Parameters
sheet
string
col
string
Returns
number | null
getComments()
getComments(
sheet):JsCommentConfig[]
Defined in: packages/sheetkit/index.ts:2087
Get all comments on a sheet.
Parameters
sheet
string
Returns
getConditionalFormats()
getConditionalFormats(
sheet):JsConditionalFormatEntry[]
Defined in: packages/sheetkit/index.ts:2072
Get all conditional formatting rules for a sheet.
Parameters
sheet
string
Returns
getCustomProperty()
getCustomProperty(
name):string|number|boolean|null
Defined in: packages/sheetkit/index.ts:2189
Get a custom property value, or null if not found.
Parameters
name
string
Returns
string | number | boolean | null
getDataValidations()
getDataValidations(
sheet):JsDataValidationConfig[]
Defined in: packages/sheetkit/index.ts:2057
Get all data validations on a sheet.
Parameters
sheet
string
Returns
getDefinedName()
getDefinedName(
name,scope?):JsDefinedNameInfo|null
Defined in: packages/sheetkit/index.ts:2508
Get a defined name by name and optional scope.
Parameters
name
string
scope?
string | null
Returns
JsDefinedNameInfo | null
getDefinedNames()
getDefinedNames():
JsDefinedNameInfo[]
Defined in: packages/sheetkit/index.ts:2513
Get all defined names in the workbook.
Returns
getDocProps()
getDocProps():
JsDocProperties
Defined in: packages/sheetkit/index.ts:2169
Get core document properties.
Returns
getFormat()
getFormat():
string
Defined in: packages/sheetkit/index.ts:2889
Get the workbook format ("xlsx", "xlsm", "xltx", "xltm", "xlam").
Returns
string
getFormControls()
getFormControls(
sheet):JsFormControlInfo[]
Defined in: packages/sheetkit/index.ts:2027
Get all form controls on a sheet.
Parameters
sheet
string
Returns
getHeaderFooter()
getHeaderFooter(
sheet):JsHeaderFooter
Defined in: packages/sheetkit/index.ts:2258
Get the header and footer text for a sheet.
Parameters
sheet
string
Returns
getMergeCells()
getMergeCells(
sheet):string[]
Defined in: packages/sheetkit/index.ts:2047
Get all merged cell ranges on a sheet.
Parameters
sheet
string
Returns
string[]
getPageBreaks()
getPageBreaks(
sheet):number[]
Defined in: packages/sheetkit/index.ts:2283
Get all row page break positions (1-based row numbers).
Parameters
sheet
string
Returns
number[]
getPageMargins()
getPageMargins(
sheet):JsPageMargins
Defined in: packages/sheetkit/index.ts:2234
Get page margins for a sheet. Returns defaults if not explicitly set.
Parameters
sheet
string
Returns
getPageSetup()
getPageSetup(
sheet):JsPageSetup
Defined in: packages/sheetkit/index.ts:2244
Get the page setup for a sheet.
Parameters
sheet
string
Returns
getPanes()
getPanes(
sheet):string|null
Defined in: packages/sheetkit/index.ts:2224
Get the current freeze pane cell reference for a sheet, or null if none.
Parameters
sheet
string
Returns
string | null
getPersons()
getPersons():
JsPersonData[]
Defined in: packages/sheetkit/index.ts:2127
Get all persons in the person list.
Returns
getPictureCells()
getPictureCells(
sheet):string[]
Defined in: packages/sheetkit/index.ts:2017
Get all cells that have pictures anchored to them on the given sheet.
Parameters
sheet
string
Returns
string[]
getPictures()
getPictures(
sheet,cell):JsPictureInfo[]
Defined in: packages/sheetkit/index.ts:2012
Get all pictures anchored at the given cell.
Parameters
sheet
string
cell
string
Returns
getPivotTables()
getPivotTables():
JsPivotTableInfo[]
Defined in: packages/sheetkit/index.ts:2433
Get all pivot tables in the workbook.
Returns
getPrintOptions()
getPrintOptions(
sheet):JsPrintOptions
Defined in: packages/sheetkit/index.ts:2268
Get print options for a sheet.
Parameters
sheet
string
Returns
getRowHeight()
getRowHeight(
sheet,row):number|null
Defined in: packages/sheetkit/index.ts:1887
Get the height of a row, or null if not explicitly set.
Parameters
sheet
string
row
number
Returns
number | null
getRowOutlineLevel()
getRowOutlineLevel(
sheet,row):number
Defined in: packages/sheetkit/index.ts:1907
Get the outline level of a row. Returns 0 if not set.
Parameters
sheet
string
row
number
Returns
number
getRows()
getRows(
sheet,options?):JsRowData[]
Defined in: packages/sheetkit/index.ts:2337
Get all rows with their data from a sheet using buffer-based transfer. Formula cells carry formula with the expression and cached result.
Parameters
sheet
string
options?
Returns
getRowsBuffer()
getRowsBuffer(
sheet,options?):Buffer
Defined in: packages/sheetkit/index.ts:2351
Serialize a sheet's cell data into a compact binary buffer (v1 format).
Parameters
sheet
string
options?
Returns
Buffer
getRowsBufferV2()
getRowsBufferV2(
sheet,options?):Buffer
Defined in: packages/sheetkit/index.ts:2360
Serialize a sheet's cell data into a v2 binary buffer with inline strings. The v2 format eliminates the global string table, enabling incremental row-by-row decoding without eagerly materializing all strings.
Parameters
sheet
string
options?
Returns
Buffer
getRowsIterator()
getRowsIterator(
sheet,options?):Generator<JsRowData>
Defined in: packages/sheetkit/index.ts:2381
Get a generator that yields one row at a time from the sheet, avoiding materializing the entire result array in memory at once. Formula cells carry formula with the expression and cached result.
Parameters
sheet
string
options?
Returns
Generator<JsRowData>
getRowsRaw()
getRowsRaw(
sheet,options?):RawRowsResult
Defined in: packages/sheetkit/index.ts:2370
Get all rows as typed arrays with minimal JS object creation. Returns column numbers (not names), cell types, and values in parallel typed arrays. Use this when processing large sheets where object creation overhead matters.
Parameters
sheet
string
options?
Returns
getRowStyle()
getRowStyle(
sheet,row):number
Defined in: packages/sheetkit/index.ts:1972
Get the style ID for a row. Returns 0 if not set.
Parameters
sheet
string
row
number
Returns
number
getRowVisible()
getRowVisible(
sheet,row):boolean
Defined in: packages/sheetkit/index.ts:1897
Get whether a row is visible.
Parameters
sheet
string
row
number
Returns
boolean
getSheetIndex()
getSheetIndex(
name):number|null
Defined in: packages/sheetkit/index.ts:1852
Get the 0-based index of a sheet, or null if not found.
Parameters
name
string
Returns
number | null
getSheetViewOptions()
getSheetViewOptions(
sheet):JsSheetViewOptions
Defined in: packages/sheetkit/index.ts:2899
Get sheet view options.
Parameters
sheet
string
Returns
getSheetVisibility()
getSheetVisibility(
sheet):string
Defined in: packages/sheetkit/index.ts:2909
Get sheet visibility. Returns "visible", "hidden", or "veryHidden".
Parameters
sheet
string
Returns
string
getSlicers()
getSlicers(
sheet):JsSlicerInfo[]
Defined in: packages/sheetkit/index.ts:2478
Get all slicers on a sheet.
Parameters
sheet
string
Returns
getSparklines()
getSparklines(
sheet):JsSparklineConfig[]
Defined in: packages/sheetkit/index.ts:2448
Get all sparklines for a worksheet.
Parameters
sheet
string
Returns
getTables()
getTables(
sheet):JsTableInfo[]
Defined in: packages/sheetkit/index.ts:2463
Get all tables on a sheet.
Parameters
sheet
string
Returns
getThemeColor()
getThemeColor(
index,tint?):string|null
Defined in: packages/sheetkit/index.ts:2498
Resolve a theme color by index (0-11) with optional tint.
Parameters
index
number
tint?
number | null
Returns
string | null
getThreadedComments()
getThreadedComments(
sheet):JsThreadedCommentData[]
Defined in: packages/sheetkit/index.ts:2102
Get all threaded comments on a sheet.
Parameters
sheet
string
Returns
getThreadedCommentsByCell()
getThreadedCommentsByCell(
sheet,cell):JsThreadedCommentData[]
Defined in: packages/sheetkit/index.ts:2107
Get threaded comments for a specific cell on a sheet.
Parameters
sheet
string
cell
string
Returns
getVbaModules()
getVbaModules(
limits?):JsVbaProject|null
Defined in: packages/sheetkit/index.ts:2924
Extract VBA module source code from the workbook's VBA project. Returns null if no VBA project.
Parameters
limits?
Returns
JsVbaProject | null
getVbaProject()
getVbaProject():
Buffer<ArrayBufferLike> |null
Defined in: packages/sheetkit/index.ts:2919
Get the raw VBA project binary (xl/vbaProject.bin), or null if not present.
Returns
Buffer<ArrayBufferLike> | null
insertCols()
insertCols(
sheet,col,count):void
Defined in: packages/sheetkit/index.ts:1942
Insert empty columns starting at the given column letter.
Parameters
sheet
string
col
string
count
number
Returns
void
insertPageBreak()
insertPageBreak(
sheet,row):void
Defined in: packages/sheetkit/index.ts:2273
Insert a horizontal page break before the given 1-based row.
Parameters
sheet
string
row
number
Returns
void
insertRows()
insertRows(
sheet,startRow,count):void
Defined in: packages/sheetkit/index.ts:1867
Insert empty rows starting at the given 1-based row number.
Parameters
sheet
string
startRow
number
count
number
Returns
void
isSheetProtected()
isSheetProtected(
sheet):boolean
Defined in: packages/sheetkit/index.ts:2533
Check if a sheet is protected.
Parameters
sheet
string
Returns
boolean
isWorkbookProtected()
isWorkbookProtected():
boolean
Defined in: packages/sheetkit/index.ts:2209
Check if the workbook is protected.
Returns
boolean
mergeCells()
mergeCells(
sheet,topLeft,bottomRight):void
Defined in: packages/sheetkit/index.ts:2037
Merge a range of cells on a sheet.
Parameters
sheet
string
topLeft
string
bottomRight
string
Returns
void
newSheet()
newSheet(
name):number
Defined in: packages/sheetkit/index.ts:1832
Create a new empty sheet. Returns the 0-based sheet index.
Parameters
name
string
Returns
number
newStreamWriter()
newStreamWriter(
sheetName,limits?):JsStreamWriter
Defined in: packages/sheetkit/index.ts:2142
Create a new stream writer for a new sheet.
Parameters
sheetName
string
limits?
Returns
openSheetReader()
openSheetReader(
sheet,opts?):Promise<SheetStreamReader>
Defined in: packages/sheetkit/index.ts:2156
Open a forward-only streaming reader for the named sheet. Reads rows from a bounded incremental source without loading the entire worksheet into memory.
Parameters
sheet
string
opts?
batchSize?
number
Returns
Promise<SheetStreamReader>
protectSheet()
protectSheet(
sheet,config?):void
Defined in: packages/sheetkit/index.ts:2523
Protect a sheet with optional password and permission settings.
Parameters
sheet
string
config?
JsSheetProtectionConfig | null
Returns
void
protectWorkbook()
protectWorkbook(
config):void
Defined in: packages/sheetkit/index.ts:2199
Protect the workbook structure/windows with optional password.
Parameters
config
Returns
void
removeAutoFilter()
removeAutoFilter(
sheet):void
Defined in: packages/sheetkit/index.ts:2137
Remove the auto-filter from a sheet.
Parameters
sheet
string
Returns
void
removeCol()
removeCol(
sheet,col):void
Defined in: packages/sheetkit/index.ts:1947
Remove a column by letter.
Parameters
sheet
string
col
string
Returns
void
removeComment()
removeComment(
sheet,cell):void
Defined in: packages/sheetkit/index.ts:2092
Remove a comment from a cell.
Parameters
sheet
string
cell
string
Returns
void
removeDataValidation()
removeDataValidation(
sheet,sqref):void
Defined in: packages/sheetkit/index.ts:2062
Remove a data validation by sqref.
Parameters
sheet
string
sqref
string
Returns
void
removePageBreak()
removePageBreak(
sheet,row):void
Defined in: packages/sheetkit/index.ts:2278
Remove a horizontal page break at the given 1-based row.
Parameters
sheet
string
row
number
Returns
void
removeRow()
removeRow(
sheet,row):void
Defined in: packages/sheetkit/index.ts:1872
Remove a row (1-based).
Parameters
sheet
string
row
number
Returns
void
removeSparkline()
removeSparkline(
sheet,location):void
Defined in: packages/sheetkit/index.ts:2453
Remove a sparkline by its location cell reference.
Parameters
sheet
string
location
string
Returns
void
renderToSvg()
renderToSvg(
options,traversal?):string
Defined in: packages/sheetkit/index.ts:2914
Render a worksheet to SVG using finite dense traversal limits.
Parameters
options
traversal?
Returns
string
resolveThreadedComment()
resolveThreadedComment(
sheet,commentId,done):void
Defined in: packages/sheetkit/index.ts:2117
Set the resolved (done) state of a threaded comment.
Parameters
sheet
string
commentId
string
done
boolean
Returns
void
save()
save(
path,limits?,options?):Promise<void>
Defined in: packages/sheetkit/index.ts:1746
Save the workbook using destination-preserving atomic replacement. See SaveOptions.
Parameters
path
string
limits?
options?
Returns
Promise<void>
saveSync()
saveSync(
path,limits?,options?):void
Defined in: packages/sheetkit/index.ts:1737
Save the workbook to a .xlsx file using atomic replacement. See SaveOptions.
Parameters
path
string
limits?
options?
Returns
void
saveWithPassword()
saveWithPassword(
path,password,limits?,options?):Promise<void>
Defined in: packages/sheetkit/index.ts:1775
Save the workbook as an encrypted .xlsx file asynchronously. Both sync and async encrypted saves buffer in memory before encrypting, so peak memory is similar.
Parameters
path
string
password
string
limits?
options?
Returns
Promise<void>
saveWithPasswordSync()
saveWithPasswordSync(
path,password,limits?,options?):void
Defined in: packages/sheetkit/index.ts:1765
Save the workbook as an encrypted .xlsx file. See SaveOptions.
Parameters
path
string
password
string
limits?
options?
Returns
void
setActiveSheet()
setActiveSheet(
name):void
Defined in: packages/sheetkit/index.ts:1862
Set the active sheet by name.
Parameters
name
string
Returns
void
setAppProps()
setAppProps(
props):void
Defined in: packages/sheetkit/index.ts:2174
Set application properties (company, app version, etc.).
Parameters
props
Returns
void
setAutoFilter()
setAutoFilter(
sheet,range):void
Defined in: packages/sheetkit/index.ts:2132
Set an auto-filter on a sheet.
Parameters
sheet
string
range
string
Returns
void
setCellFormula()
setCellFormula(
sheet,cell,formula,limits?):void
Defined in: packages/sheetkit/index.ts:2405
Set a formula on a cell using finite mutation limits.
Parameters
sheet
string
cell
string
formula
string
limits?
Returns
void
setCellHyperlink()
setCellHyperlink(
sheet,cell,opts):void
Defined in: packages/sheetkit/index.ts:2288
Set a hyperlink on a cell.
Parameters
sheet
string
cell
string
opts
Returns
void
setCellRichText()
setCellRichText(
sheet,cell,runs):void
Defined in: packages/sheetkit/index.ts:2488
Set a cell to a rich text value with multiple formatted runs.
Parameters
sheet
string
cell
string
runs
Returns
void
setCellStyle()
setCellStyle(
sheet,cell,styleId):void
Defined in: packages/sheetkit/index.ts:1962
Apply a style ID to a cell.
Parameters
sheet
string
cell
string
styleId
number
Returns
void
setCellValue()
setCellValue(
sheet,cell,value):void
Defined in: packages/sheetkit/index.ts:1801
Set the value of a cell. Pass string, number, boolean, DateValue, or null to clear.
Parameters
sheet
string
cell
string
value
Returns
void
setCellValues()
setCellValues(
sheet,cells):void
Defined in: packages/sheetkit/index.ts:1806
Set multiple cell values at once.
Parameters
sheet
string
cells
Returns
void
setColOutlineLevel()
setColOutlineLevel(
sheet,col,level):void
Defined in: packages/sheetkit/index.ts:1932
Set the outline level of a column (0-7).
Parameters
sheet
string
col
string
level
number
Returns
void
setColStyle()
setColStyle(
sheet,col,styleId):void
Defined in: packages/sheetkit/index.ts:1977
Apply a style ID to an entire column.
Parameters
sheet
string
col
string
styleId
number
Returns
void
setColVisible()
setColVisible(
sheet,col,visible):void
Defined in: packages/sheetkit/index.ts:1922
Set whether a column is visible.
Parameters
sheet
string
col
string
visible
boolean
Returns
void
setColWidth()
setColWidth(
sheet,col,width):void
Defined in: packages/sheetkit/index.ts:1912
Set the width of a column (e.g., "A", "B", "AA").
Parameters
sheet
string
col
string
width
number
Returns
void
setConditionalFormat()
setConditionalFormat(
sheet,sqref,rules):void
Defined in: packages/sheetkit/index.ts:2067
Set conditional formatting rules on a cell range.
Parameters
sheet
string
sqref
string
rules
Returns
void
setCustomProperty()
setCustomProperty(
name,value):void
Defined in: packages/sheetkit/index.ts:2184
Set a custom property. Value can be string, number, or boolean.
Parameters
name
string
value
string | number | boolean
Returns
void
setDefinedName()
setDefinedName(
config):void
Defined in: packages/sheetkit/index.ts:2503
Add or update a defined name.
Parameters
config
Returns
void
setDocProps()
setDocProps(
props):void
Defined in: packages/sheetkit/index.ts:2164
Set core document properties (title, creator, etc.).
Parameters
props
Returns
void
setHeaderFooter()
setHeaderFooter(
sheet,header?,footer?):void
Defined in: packages/sheetkit/index.ts:2249
Set header and footer text for printing.
Parameters
sheet
string
header?
string | null
footer?
string | null
Returns
void
setPageMargins()
setPageMargins(
sheet,margins):void
Defined in: packages/sheetkit/index.ts:2229
Set page margins on a sheet (values in inches).
Parameters
sheet
string
margins
Returns
void
setPageSetup()
setPageSetup(
sheet,setup):void
Defined in: packages/sheetkit/index.ts:2239
Set page setup options (paper size, orientation, scale, fit-to-page).
Parameters
sheet
string
setup
Returns
void
setPanes()
setPanes(
sheet,cell):void
Defined in: packages/sheetkit/index.ts:2214
Set freeze panes on a sheet.
Parameters
sheet
string
cell
string
Returns
void
setPrintOptions()
setPrintOptions(
sheet,opts):void
Defined in: packages/sheetkit/index.ts:2263
Set print options on a sheet.
Parameters
sheet
string
opts
Returns
void
setRowHeight()
setRowHeight(
sheet,row,height):void
Defined in: packages/sheetkit/index.ts:1882
Set the height of a row (1-based).
Parameters
sheet
string
row
number
height
number
Returns
void
setRowOutlineLevel()
setRowOutlineLevel(
sheet,row,level):void
Defined in: packages/sheetkit/index.ts:1902
Set the outline level of a row (0-7).
Parameters
sheet
string
row
number
level
number
Returns
void
setRowStyle()
setRowStyle(
sheet,row,styleId):void
Defined in: packages/sheetkit/index.ts:1967
Apply a style ID to an entire row.
Parameters
sheet
string
row
number
styleId
number
Returns
void
setRowValues()
setRowValues(
sheet,row,startCol,values):void
Defined in: packages/sheetkit/index.ts:1814
Set values in a single row starting from the given column.
Parameters
sheet
string
row
number
startCol
string
values
Returns
void
setRowVisible()
setRowVisible(
sheet,row,visible):void
Defined in: packages/sheetkit/index.ts:1892
Set whether a row is visible.
Parameters
sheet
string
row
number
visible
boolean
Returns
void
setSheetData()
setSheetData(
sheet,data,startCell?):void
Defined in: packages/sheetkit/index.ts:1819
Set a block of cell values from a 2D array.
Parameters
sheet
string
data
CellValue[][]
startCell?
string | null
Returns
void
setSheetDataBuffer()
setSheetDataBuffer(
sheet,buf,startCell?):void
Defined in: packages/sheetkit/index.ts:2395
Apply cell data from a binary buffer to a sheet.
Parameters
sheet
string
buf
Buffer
startCell?
string | null
Returns
void
setSheetName()
setSheetName(
oldName,newName):void
Defined in: packages/sheetkit/index.ts:1842
Rename a sheet.
Parameters
oldName
string
newName
string
Returns
void
setSheetViewOptions()
setSheetViewOptions(
sheet,opts):void
Defined in: packages/sheetkit/index.ts:2894
Set sheet view options (gridlines, zoom, view mode, etc.).
Parameters
sheet
string
opts
Returns
void
setSheetVisibility()
setSheetVisibility(
sheet,visibility):void
Defined in: packages/sheetkit/index.ts:2904
Set sheet visibility ("visible", "hidden", or "veryHidden").
Parameters
sheet
string
visibility
string
Returns
void
toCSV()
toCSV(
sheet,options?):string
Defined in: packages/sheetkit/index.ts:2666
Convert sheet data to CSV. Formula cells export expressions regardless of cached results. Records use LF by default without a trailing terminator.
Parameters
sheet
string
options?
Returns
string
toHTML()
toHTML(
sheet,options?):string
Defined in: packages/sheetkit/index.ts:2705
Convert sheet data to an HTML table string.
Parameters
sheet
string
options?
Returns
string
toJSON()
toJSON(
sheet,options?):Record<string,CellValue>[]
Defined in: packages/sheetkit/index.ts:2538
Convert sheet data to an array of JSON objects.
Parameters
sheet
string
options?
Returns
Record<string, CellValue>[]
unmergeCell()
unmergeCell(
sheet,reference):void
Defined in: packages/sheetkit/index.ts:2042
Remove a merged cell range from a sheet.
Parameters
sheet
string
reference
string
Returns
void
unprotectSheet()
unprotectSheet(
sheet):void
Defined in: packages/sheetkit/index.ts:2528
Remove sheet protection.
Parameters
sheet
string
Returns
void
unprotectWorkbook()
unprotectWorkbook():
void
Defined in: packages/sheetkit/index.ts:2204
Remove workbook protection.
Returns
void
unsetPanes()
unsetPanes(
sheet):void
Defined in: packages/sheetkit/index.ts:2219
Remove any freeze or split panes from a sheet.
Parameters
sheet
string
Returns
void
writeBuffer()
writeBuffer(
limits?):Promise<Buffer<ArrayBufferLike>>
Defined in: packages/sheetkit/index.ts:1760
Serialize the workbook to an in-memory Buffer asynchronously.
Parameters
limits?
Returns
Promise<Buffer<ArrayBufferLike>>
writeBufferSync()
writeBufferSync(
limits?):Buffer
Defined in: packages/sheetkit/index.ts:1755
Serialize the workbook to an in-memory Buffer.
Parameters
limits?
Returns
Buffer
open()
staticopen(path,options?):Promise<Workbook>
Defined in: packages/sheetkit/index.ts:1664
Open an existing .xlsx file from disk asynchronously.
Parameters
path
string
options?
OpenOptions | JsOpenOptions | null
Returns
Promise<Workbook>
openBuffer()
staticopenBuffer(data,options?):Promise<Workbook>
Defined in: packages/sheetkit/index.ts:1680
Open a workbook from an in-memory Buffer asynchronously.
Parameters
data
Buffer
options?
OpenOptions | JsOpenOptions | null
Returns
Promise<Workbook>
openBufferSync()
staticopenBufferSync(data,options?):Workbook
Defined in: packages/sheetkit/index.ts:1672
Open a workbook from an in-memory Buffer.
Parameters
data
Buffer
options?
OpenOptions | JsOpenOptions | null
Returns
Workbook
openBufferWithPassword()
staticopenBufferWithPassword(data,password,options?):Promise<Workbook>
Defined in: packages/sheetkit/index.ts:1721
Open an encrypted in-memory Buffer asynchronously.
Parameters
data
Buffer
password
string
options?
OpenOptions | JsOpenOptions | null
Returns
Promise<Workbook>
openBufferWithPasswordSync()
staticopenBufferWithPasswordSync(data,password,options?):Workbook
Defined in: packages/sheetkit/index.ts:1710
Open an encrypted workbook from an in-memory Buffer.
Parameters
data
Buffer
password
string
options?
OpenOptions | JsOpenOptions | null
Returns
Workbook
openSync()
staticopenSync(path,options?):Workbook
Defined in: packages/sheetkit/index.ts:1656
Open an existing .xlsx file from disk.
Parameters
path
string
options?
OpenOptions | JsOpenOptions | null
Returns
Workbook
openWithPassword()
staticopenWithPassword(path,password,options?):Promise<Workbook>
Defined in: packages/sheetkit/index.ts:1699
Open an encrypted .xlsx file using a password asynchronously.
Parameters
path
string
password
string
options?
OpenOptions | JsOpenOptions | null
Returns
Promise<Workbook>
openWithPasswordSync()
staticopenWithPasswordSync(path,password,options?):Workbook
Defined in: packages/sheetkit/index.ts:1688
Open an encrypted .xlsx file using a password.
Parameters
path
string
password
string
options?
OpenOptions | JsOpenOptions | null
Returns
Workbook