Load Spreadsheet

如何在字体中加载电子表格

Overview

本文说明如何将现有电子表格文件加载到一个 Workbook 库支持加载XLSX和HTML文件.

载入一个XLSX文件

使用静态 Workbook.load() 打开现有XLSX文件的方法:

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);

装载一个密码保护的工作簿

将密码作为第二个参数传递给 Workbook.load():

const workbook = await Workbook.load("protected.xlsx", "mypassword");
const worksheet = workbook.worksheets[0]!;
console.log("A1:", worksheet.getCell(0, 0)?.value);

载入一个HTML文件

库可以通过导入HTML表. Workbook.load():

const workbook = await Workbook.load("data.html");
const worksheet = workbook.worksheets[0]!;
console.log("A1:", worksheet.getCell(0, 0)?.value);

阅读和修改加载数据

载入后,读取单元格值与 getCell() 或是 getCell2(), 修改值以 putValue(), 并保存更新的工作簿:

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");