FSheetsNoteWorksheet

GitHubEdit on GitHub
packages@univerjs/sheets-note

APIs

getNotes

Get all annotations in the worksheet

Signature

getNotes(): ISheetNoteInfo[]

Returns

  • (ISheetNoteInfo[]) — An array of all annotations in the worksheet

Examples

const fWorkbook = univerAPI.getActiveWorkbook()
const fWorksheet = fWorkbook.getActiveSheet()
const notes = fWorksheet.getNotes()
console.log(notes)

notes.forEach((item) => {
  const { row, col, note } = item
  console.log(`Cell ${fWorksheet.getRange(row, col).getA1Notation()} has a note: ${note}`)
})

Table of Contents

Capalyze