Jump to a Section

Overview

Authorizing an Excel Online Account

The first time you use an Excel Online card in your FLO, you will need to authorize an account.

  1. Add an Account Nickname. This should be unique, so that in the case that your teammates authorize multiple accounts, you will be able to tell them apart.
  2. Click “Create” to launch a pop-up window to sign into your account and save this configuration.

    Events

    • New Worksheet

      This card will start FLO when a new worksheet on you workbook.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.

      Output Fields

      • Worksheet
        • Worksheet ID (text) : The worksheet unique identification.
        • Worksheet Name (text) : The worksheet name.
        • Position (text) : The worksheet position, this is displayed as the tab number of the sheet specified by the name that you type.
        • Visibility (text) : The visibility of the worksheet.Visibility ?
      • context
        • Execution ID (text) : the context execution indentification.
    • Row Added or Updated

      Start the FLO when a new row is added or updated to the worksheet.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.

      Output Fields

      • Row
        • Row Number (number): Number of the row Added or Updated; this is the number displayed in Excel to the left of the first column.
      • Values (text) : a list that represent each column in the row that was added or updated.
      • context
        • Execution ID (text) : The context execution identification.
    • Table Row Added or Updated

      Start the FLO when a new row is added to a Table.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
      • Table (dropdown): a list of tables available in the selected worksheet. Table in Excel is a formatted series of worksheets rows and column which have additional function.

      Output Fields

      • Table
        • Row Number (number) : the table row number.
      • Values (text) : Dynamically generated list of column headers based on the selected table.
    • Updated Cell

      Start the FLO when data within a cell is updated.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
      • Cell Reference (text) : forexample “A1, for the first cell in the spreadsheet.

      Output Fields

      Cell Explanation
      Cell Text (text) The text in the specified cell.
      Cell Value (text) The value of the cell.
      Type _(text) _type
      Format (text) number format
      Column Hidden _(T/F) _If the column is hidden
      Row Hidden _(T/F) _If the row is hidden
      Hidden _(T/F) _If the cell is hidden
      Formula _(text) _Excel online formula
      • context
        • Execution ID (text) : the execution context unique identifier.

    Actions

    • Add Row

      Add Row

      This card adds a row of data to the end of a worksheet. Microsoft’s Excel API takes time to propagate changes. When more than one row is being added to a Worksheet, we recommend you add a Wait Function Card set to 10 seconds. If you see rows being omitted, add more time.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.

      Input Fields

      • Values : This will be the list of values for the new row.
        • Column Letters (A - ZZ) (text) : Each of the field will represent the corresponding cell in the newly created row. For example if the worksheet is empty then the first three field will be 1A, 1B, 1C.

      Output Fields

      • Row
        • Row Number (number): The newly created row’s number. This is the number displayed in Excel to the left of the first column.
    • Add Table Row

      This card will add a row of data to the end of the specified table in the worksheet.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
      • Table (dropdown): a list of tables available in the selected worksheet. Table in Excel is a formatted series of worksheets rows and column which have additional function.

      Input Fields

      • Values

        • Columns (text - dynamically generated): list of column headers based on the selected table, this will represent each column of the row that will be contained in the newly assigned table.

          Output Fields

      • Row

        • Row Number (number): The newly created table row number. This is the number displayed in Excel to the left of the first column.
    • Clear Cells

      Clear formats and/or data from the designated cells.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
      • Apply to (dropdown): select what should be cleared from the cells.
        • All - clear formats and content.
        • Formats - clear formats only.
        • Contents - clear contents only.

      Input Fields

      The cell reference cells are used to construct a grid of cells to apply the clear action.

      • Cells
        • Cell Reference Begin (text): a value representing a cell (e.g. A2) in the top left corner of the grid to be cleared.
        • Cell Reference End (text): a value representing a cell (e.g. D4) in the bottom right corner of the grid to be cleared.
    • Delete Cells

      Delete Cells

      Delete cells from an Excel Online sheet.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
      • Shift (dropdown): select how to shift cells once the delete action is completed.
        • Left - shift cells left.
        • Up - shift cells up.

      Input Fields

      The cell reference cells are used to construct a grid of cells to apply the delete action.

      • Cells
        • Cell Reference Begin (text): a value representing a cell (e.g. A2) in the top left corner of the grid to be deleted.
        • Cell Reference End (text): a value representing a cell (e.g. D4) in the bottom right corner of the grid to be deleted.
    • Get Cell Value

      Gets information for a cell.

      Input Fields

      • Cell
        • Cell Reference (text): In format like “ A1”, for the first cell on the spreadsheet.

      Output Fields

      Cell Explanation
      Cell Text (text) The text in the specified cell.
      Cell Value (text) The value of the cell.
      Type _(text) _type
      Format (text) number format
      Column Hidden _(T/F) _If the column is hidden
      Row Hidden _(T/F) _If the row is hidden
      Hidden _(T/F) _If the cell is hidden
      Formula _(text) _Excel online formula
    • HTTP Request

      Make an authenticated HTTP request to the Excel Online API

    • Read All Rows

      Read all rows in a worksheet (maximum of 300).

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.

      Input Fields

      • Offset (number) : The amount of offset of the row to read. This is the numbers displayed in Excel to the left of the first column.

      Output Fields

      • Rows (list of object) : Dynamically generated rows object based on the worksheet.
    • Read Row

      Read a row of data from an Excel Online worksheet.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.

      Input Fields

      • Row
        • Row Number (number): number of the row you want to read; this is the number displayed in Excel to the left of the first column.

      Output Fields

      In the field selection window, select the column letters from which you want to retrieve values.

      • Values
        • Column letter (A-ZZ) (text): a letter that identifies the column from which to read the row data. Each of the fields will represent the corresponding cell of the read row.
    • Read Table Row

      This card will get value from the a row in the table.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
      • Table (dropdown): a list of tables available in the selected worksheet. Table in Excel is a formatted series of worksheets rows and column which have additional function.

      Input Fields

      • Row
        • Row Number (number) : number of the row you want to read; this is the number displayed in Excel to the left of the first column.

      Output Fields

      • Values : Dynamically generated list of each column of the row that was read from the table.
    • Search Rows by Column

      Search for a row or rows that match a value in a certain column.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
      • Column to Search (dropdown) : The column the search will be conducted on.
      • Result Set (dropdown) : either the first matching row or all matching rows.

      Input Fields

      • Column
        • Value (text) : The column value. This is the number displayed in Excel on the top of first row.

      Output Fields

      • Result : rows that are search for.
    • Update Cell

      Updates a value within a row on Excel Online.

      Options

      Choose a workbook and worksheet in order to update a cell.

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.

      Input Fields

      • Cell
        • Cell Reference (text): In format like “ A1”, for the first cell on the spreadsheet.
        • Value (text): the new value.
        • Formula (text): Add an excel formula.
        • Format (text): Number format.

      Output Fields

      • There are no output fields for this card.
    • Update Row

      Updates a row in an Excel Online Worksheet.

      Input Fields

      • Row
        • Row Number (number): the row number.
      • Values
        • Columns (A, B, C…) (text): the values to be inputted at the column location in the row.

      Output Fields

      • There are no output fields for this card.
    • Update Table Row

      Updates a row in the sheet including values for the row.

      Options

      • Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
      • Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
      • Table (dropdown): a list of tables available in the selected worksheet. Table in Excel is a formatted series of worksheets rows and column which have additional function.

      Input Fields

      • Row

        • Row Number (number) : number of the row you want to read; this is the number displayed in Excel to the left of the first column.
      • Values : Dynamically generated list of each column of the row that was read from the table.