Set data in Excel file to cell

You can use the action to read the data in the Excel file and set it in the CELF sheet.

Set data in Excel file to cell

  1. Open 'Action set setting' dialog.
  2. Drag 'Set data in Excel file to cell' action in 'File operation' tab, and then set into edit area.
../../../../_images/img_01.en41.png
  1. Select the Excel file specification method for reading data.
../../../../_images/img_02.en39.png
  • If you select file by popup at action set execution, select 'Select file with pop-up dialog'.
  • If you select file with full path, select 'Use the specified path'.
  1. Specify the name of the sheet from which data is to be read in 'Excel sheet name to read'.
../../../../_images/img_03.en29.png
  1. In 'Where to set the data', specify the start cell to be set in the CELF sheet and the cell range to read Excel.
../../../../_images/img_04.en28.png

Tip

  • You can make multiple designations by clicking the '+' button, and you can delete unnecessary 'Where to set the data' by clicking the 'trash can' button.
../../../../_images/img_05.en26.png
  1. Click 'OK' button.

Attention

This action is not available for the following Excel files.

  • Not readable
  • Password is set

Related keywords

import, input, cooperation, excel