Exporting and importing CSV files

This section explains how to output to and import from CSV files.

CSV files can be linked to table data or to data displayed on the screen in two ways.

Register CSV File Data in a Table

  1. The action settings of the CSV file output are set see "Register the Data of the CSV file in the Table"

Save the table data to a CSV file

  1. The action settings of the CSV file output are set see "Save Table Data in CSV file"

Display CSV File Data on the Screen

  1. Open the "Action set settings" dialog.

  2. Drag&drop the "Set CSV file data" action in the tab "File operation" at the top left of the action set settings screen to the right side of the screen.

    ../../../_images/img_01.en61.png

    Tip

    As shown below, when you drag&drop the action to the left side of the screen, an orange underline appears at the bottom of the action to complete the set.
    img_action_set_location

  1. Set [A1] to the output destination cell of the CSV file.

    Hint

    This can be specified from the screen by clicking on the icon in the text box.
    ../../../_images/img_03.en47.png ../../../_images/img_04.en44.png

  2. Specify the source CSV file path for loading.

    Hint

    • If you select "Specify with popup dialog", you can specify the path in the dialog.
    • If you select "Use the specified path", you can specify a fixed path of your choice.

    Tip

    You can specify the path described in B1 by entering the path in the "B1" cell and typing "=B1" in the "Use the specified path" field.

    ../../../_images/img_10.en17.png

  3. When you have completed your settings, click the "OK" button at the bottom right of the screen.

Save the data displayed on the screen to a CSV file.

  1. Open the "Action set settings" dialog.

  2. Drag&drop the "Save cell value in CSV file" action from the tab "File operation" at the top left of the Action Set settings screen to the right side of the screen.

    ../../../_images/img_06.en30.png

  3. Specify the range of data you want to convert to a CSV file.

    ../../../_images/img_11.en15.png

    Hint

    You can specify it from the screen by clicking on the icon in the text box. Here the range of "A1:D8" is specified.

  4. Specify the path of the CSV file to be saved.

    ../../../_images/img_08.en24.png

    Hint

    • If you select "Specify with popup dialog", you can specify the path in the dialog.
    • If you select "Use the specified path", you can specify a fixed path of your choice.

    Tip

    You can specify the path described in B1 by entering the path in the "B1" cell and typing "=B1" in the "Use the specified path" field.
    ../../../_images/img_09.en19.png

  5. When you have completed your settings, click the "OK" button at the bottom right of the screen.