How to Load a Spreadsheet in TypeScript
Overview
This article shows how to load existing spreadsheet files into a Workbook object using Aspose.Cells FOSS for TypeScript. The library supports loading XLSX and HTML files.
Load an XLSX File
Use the static Workbook.load() method to open an existing XLSX file:
import { Workbook } from "@aspose/cells";
const workbook = await Workbook.load("input.xlsx");
const worksheet = workbook.worksheets[0]!;
console.log("A1:", worksheet.getCell(0, 0)?.value);
console.log("B1:", worksheet.getCell(0, 1)?.value);Load a Password-Protected Workbook
Pass a password as the second argument to Workbook.load():
const workbook = await Workbook.load("protected.xlsx", "mypassword");
const worksheet = workbook.worksheets[0]!;
console.log("A1:", worksheet.getCell(0, 0)?.value);Load an HTML File
The library can import HTML tables via Workbook.load():
const workbook = await Workbook.load("data.html");
const worksheet = workbook.worksheets[0]!;
console.log("A1:", worksheet.getCell(0, 0)?.value);Read and Modify Loaded Data
After loading, read cell values with getCell() or getCell2(), modify values with putValue(), and save the updated workbook:
const workbook = await Workbook.load("report.xlsx");
const worksheet = workbook.worksheets[0]!;
const currentValue = worksheet.getCell(1, 0)?.value;
console.log("Current A2:", currentValue);
worksheet.putValue("A2", "Updated Value");
await workbook.save("report_updated.xlsx");