Skip to content

Excel File

Excel file allows users to operate Excel spreadsheet with in-memory mode. All operations involving Excel in the task are performed in the background, similar to the operation of a plain text file. In this article you'll learn:

  • Open an Excel document
  • Activate a worksheet
  • Read data from worksheet cells
  • Write data in worksheet cells
  • Read / Write rows
  • Read / Write columns
  • Save Excel

Actions

Open Workbook

Launch an Excel doucment or Open an existing Excel workbook.

  • File path: The full path of the Excel file to open.
  • Open in: Which mode to open the Excel
    • Read-only: The opened Excel files can only be read.
    • Read-write: The opened Excel files can be both read and written.

Switch to Sheet

Activate a specific worksheet of an Excel.

  • Active sheet by: Specify which way to activate the worksheet.
    • Index: The index number of the worksheet to activate. Note that the numbering starts from 0.
    • Name: The name of the worksheet to activate.

Read Cell

Get the value of a cell from the active worksheet of an Excel.

  • Cell position: Cell position is represented by a letter with row number (e.g. A1, B2, C3).
  • Store cell content to: Set the value of the cell to a variable.

Write Cell

Write a value into a cell of an Excel.

  • Cell position: Cell position is represented by a letter with row number (e.g. A1, B2, C3).
  • Cell value: Enter the text, number or variable to insert or update the cell's data.

Read Single Row

Get a row content from the active worksheet of an Excel.

  • Row number: The row's index number which starts from 1.
  • Assign row result to the variable: Set the fetched row content to a variable.

Write Single Row

Write a row content into a specified row in the active worksheet of an Excel.

  • Row number: The row's index number which starts from 1.
  • Row content from variable: The variable of a row content to write.

Read Single Column

Get a column content from the active worksheet of an Excel.

  • Column number: The column's letter.
  • Assign column to the variable: Set the fetched column content to a variable.

Write Single Column

Write a column content into a specified column in the active worksheet of an Excel.

  • Column number: The column's letter.
  • Set column value to the variable: The variable of a column content to write.

Read Multiple Rows

Get multiple rows from the active worksheet of an Excel.

  • From row number: The first row number which starts from 1.
  • To row number: The last row number which starts from 1.
  • Remove empty result: The option used to remove the result rows in which all the data is empty or null. Not selected by default.
  • Assign row result to the variable: Set the fetched rows to a variable.

Write Multiple Rows

Insert or update multiple rows in the active worksheet of an Excel.

  • From row number: The first row number which starts from 1.
  • To row number: The last row number which starts from 1.
  • Rows content from variable: The variable of rows content to write.

Read Multiple Columns

Get multiple columns from the active worksheet of an Excel.

  • From column letter: The first column's letter.
  • To column letter: The last column's letter.
  • Remove empty result: The option used to remove the result columns in which all the data is empty or null. Not selected by default.
  • Assign column to the variable: Set the fetched columns to a variable.

Write Multiple Columns

Insert or update multiple columns in the active worksheet of an Excel.

  • From column letter: The first column's letter.
  • To column letter: The last column's letter.
  • Columns content from variable: The variable of columns content to write.

Read Data Range

Retrieve a range of cells from the active worksheet of an Excel.

  • From row number: The first row number which starts from 1.
  • To row number: The last row number which starts from 1.
  • From column letter: The first column's letter.
  • To column letter: The last column's letter.
  • Remove empty result: The option used to remove the result rows in which all the data is empty or null. Not selected by default.
  • Assign value to the variable: Set the fetched cells ranges to a variable.

Save

Save the currently launched Excel file.

Save As

Save an Excel file to the given path.

  • File path: Choose or enter the target folder path.
  • File name: The target Excel file name.

Close

Close the currently launched Excel workbook.