Using Action

This page is about using Actions.

• Cell operation
  • Copy and paste cell values.
  • Hide/Unhide rows or columns
  • INSERT/DELETE rows or columns
  • Change Cell Formatting
  • Set Check Button List Date Value in Action
  • Replace cell values in an action
  • Restore cell values to the state of the sheet as initially displayed in an action
  • Clear filter(s)
• Sheet operation
  • Transit From The Sheet To Other Sheet
  • Pass Data to Other Sheet
  • Copy and paste sheet values to other sheet
  • Execute Other Sheet Action
  • Refer From The Sheet to Other Sheet and Cell
  • Save sheet as an Excel file
  • Print the sheet by Action
  • Save sheet as a PDF file
  • Record Value Changes in the Sheet
• Data operation
  • Get One Table Data
  • Get Multiple Data From Table
  • Get the Number of Records from Table
  • Display Combined Multiple Tables Data
  • Insert Update Delete Table Data
  • Insert, Update, Delete Table Multiple Data
  • Exclusive Control when Table Update
  • Send Mail
  • Cross Tabulation (Basic)
  • Cross Tabulation (Advanced)
  • Register the Data of the CSV file in the Table
  • Save Table Data in CSV file
• Control
  • Branch action
  • Show pop-up
  • Execute data updates in batches.
  • Handle Error
• File operation
  • Upload files
  • Upload, download and delete file from action
  • Open File dialog
  • Open folder dialog
  • Open specified URL or file
  • Set data in Excel file to cell
  • Set cell data to Excel file
  • Process CSV files and output them as another CSV file.

Supplementary Information on Actions

This is a supplementary page on how to use actions.

• Pasting in Actions

Actions List

Refer the following documents about Actions List.

• ActionList