Jetformat

Read an Excel cell value and formula

Use jetformat excel get to read an Excel cell value and formula.

By Jetformat

Use the exact worksheet name and a cell address such as B12. This read operation is useful for checking a value before and after an automated update.

Steps

  1. Start with a local XLSX. Replace the sample paths and identifiers with your own.
  2. Run the command below. Read the returned data before choosing a follow-up edit.
  3. Check the result as described below before using it in another job.
jetformat excel get finance.xlsx --sheet Summary --cell B12

Options for this task

Option Meaning
--cell Cell reference such as A1 (required)
--sheet Worksheet name (required)

Check the result

Compare the value and formula returned; a missing cached result may require recalc rather than another read.

Notes and limits

This is a free utility or read operation. It does not need a paid conversion to inspect the result.

Run jetformat excel get --help to compare options with your installed version.

See the excel command reference for the surrounding workflow.

Last updated