Excel

Fill a source cell's formula or value across a range, adjusting relative references like dragging the Excel fill handle. Absolute references (with $) stay pinned.

Save and close the Excel file

Export the workbook (or a single sheet) to PDF, preserving layout, charts, and conditional formatting.

Add a new blank sheet to the workbook

Create a summary table to analyze data

Remove a sheet from an Excel workbook

Remove specific columns from a sheet

Remove specific rows from a sheet

Make a copy of an existing sheet

Run an automated macro inside Excel

Open an Excel file to read or edit it

Import data from a comma-separated values file

Get data from cells or ranges in a spreadsheet

Read the value from a specific cell in an Excel worksheet

Open an encrypted .xlsx with a password and read the sheet contents into a DataTable. Use this when the file uses ECMA-376 encryption that plain Excel readers cannot decrypt.

Force Excel to recalculate formulas and save the workbook. Use after writing values whose downstream formulas depend on them — exceljs stores cached results that may be stale until Excel re-evaluates.

Save data to cells or ranges in a spreadsheet

Write a value to a specific cell in an Excel worksheet