Function buildWorksheetRangeUrl

apps/sim/tools/microsoft_excel/utils.ts:193–202

(
  basePath: string,
  address: string | undefined,
  sheetName?: string
)

 * `/format/fill`, `/format/font`, or nothing for the range object itself.
 */
export function buildWorksheetRangeUrl(
  basePath: string,
  address: string | undefined,
  sheetName?: string
): string {
  const resolved = resolveSheetAndAddress(address, sheetName)
  const encodedSheet = encodeURIComponent(escapeODataString(resolved.sheetName))
  const encodedAddress = encodeURIComponent(resolved.address)
  return `${basePath}/workbook/worksheets('${encodedSheet}')/range(address='${encodedAddress}')`
}

export function trimTrailingEmptyRowsAndColumns(matrix: ExcelCellValue[][]): ExcelCellValue[][] {
  if (!Array.isArray(matrix) || matrix.length === 0) return []