Skip to main content
The headless sheet editor: commands, selection and undo over a workbook. Guide: Headless editor.

XlsxEditor

Home-tab edits of a workbook: every command acts on the selection through the Excel.* facade and is one step of the same undo history the grid’s typing uses. Import from @reductoai/xlsx/editor.

XlsxEditor properties

apply()

arrows()

The tracer arrows on every sheet, as the grid paints them.

cellSizes()

What Row Height, Column Width and Default Width show for the selection.

cfGuess()

cfRules()

Manage Rules’ list: the rules that touch the selection, or every rule on its sheet.

chart()

The Format Chart pane of a chart on a sheet; null when it is not one.

chartData()

Select Data Source’s fields for a chart on a sheet; null when it is not one.

chartSource()

The blocks a chart element reads (a series or its labels), on any sheet; none for other parts.

contextMenu()

Excel’s right-click menu at target, as data; each entry’s command goes back through apply.

filtered()

Whether the active cell’s table or the sheet has a filtered list, for Clear and Reapply.

find()

Find Next (step -1 for Find Previous): the match becomes the active cell; a searched block stays selected.

findAll()

Find All: every match in the scope, in search order.

format()

The active cell’s format.

frozen()

The panes frozen on the selected sheet.

gridlines()

Whether the selected sheet shows its gridlines.

headings()

Whether the selected sheet shows its row and column headings.

inTable()

Whether the active cell sits in a table, so Clear Rules offers This Table.
The active cell’s link, or null.

mergeDiscards()

Whether merging the selection would drop values other than each area’s top-left one.

names()

The names Name Manager lists.

note()

The active cell’s note, or null.

noteShown()

Whether the active cell’s note stays on the sheet; null without a note.

pageSetup()

Page Setup’s values for the active sheet.

read()

Runs a dialog’s reader (advancedFilterGuess, removeDuplicatesGuess) on the session and selection.

sample()

The active cell’s value as code shows it, for Format Cells’ Sample.

scenarios()

Scenario Manager’s list for the active sheet.

scenarioValues()

The current values of changing, as Add Scenario offers them.

slicerSettings()

Slicer Settings for the slicer name; null when there is none.

sortGuess()

What Sort opens with; throws where Excel refuses (a blank cell alone, a pivot).

sparkline()

The active cell’s sparkline group, as the Sparkline tab shows it.

stepNote()

Review > Next (step -1 for Previous): the next note or comment’s cell becomes active.

subtotalGuess()

Data > Subtotal’s list and labels; null when the selection is not in a list.

tableGuess()

Create Table’s range and header guess; throws where Excel refuses (a blank cell alone).

textColumnsPreview()

Text to Columns’ preview rows; null when the selection spans columns.

thread()

The active cell’s comment thread, or null.

usableNames()

The names a formula on the selected sheet can use, as Use in Formula lists them.

validation()

The selection’s rule as Data Validation opens with it.

contextMenu()

Excel’s right-click menu for the target, over the editor’s current selection. Import from @reductoai/xlsx/editor.