Introduction
Basic Operations
Creating a Variety of Labels
Printing
Changing Preference Settings
Appendix
Top > Basic Operations > How to Use the Data Creation Window
How to Use the Data Creation Window
The Data creation window allows you to create a large number of labels easily by importing a file created by Excel or other application.
Creating Labels Using an Excel or Other Format File
Importing a List of Equipment from an Excel File
 Note:You can also enter data directly in the Data creation window without importing a file. |
About Files to Import
Supported File Formats
xls, xlsx, csv, xlsm, txt
File Contents
-
Enter data for a single label in one row.
-
You do not need to delete unnecessary sheets, rows or columns in advance. You can select a sheet when importing a file. You can select rows and columns after importing a file.
-
Images such as photos
To import image files (BMP, JPG, TIF, or PNG) such as photos and illustrations, enter the full pathname of the image file.
Example: C:\Users\Desktop\Images\aaa.png
How to Operate the Data Creation Window
Editing Data
Double-click on a cell to edit or add data in the cell.
Sorting Data / Entering Column Title
Right-click on the data area to display menus for sorting data, entering column title, etc.
Changing Column Attribute
Click on at the right of the column, and select attribute for the column from Column Attributes.
When a file is imported, attribute of the all columns is set to Text. You need to change the attribute for columns that contain barcode or QR code data, or images (full pathnames of image files).
Selecting Rows to Print
You can select rows and print only the selected rows. Select the check boxes for the rows you want to print.
|
Note: To print only the selected rows, a setting in the print dialog box is also required. |
Exporting Data
You can export the data to a file by clicking Export.
Inserting Data into the Layout Editing Window
You can insert data from the Data creation window to the Layout editing window in one of the following ways.
-
Drag the column
The shape of the mouse pointer changes to when you move it over the column title. While is displayed, you can drag the column.
-
Use in the tool box
When you click , a dialog box as shown below is displayed. Select a column and click OK in the dialog box, and then click at a position you want to insert it in the Layout editing window.
Introduction
Basic Operations
Creating a Variety of Labels
Printing
Changing Preference Settings
Appendix
Top > Basic Operations > How to Use the Data Creation Window
How to Use the Data Creation Window
The Data creation window allows you to create a large number of labels easily by importing a file created by Excel or other application.
Creating Labels Using an Excel or Other Format File
Importing a List of Equipment from an Excel File
|
Note: You can also enter data directly in the Data creation window without importing a file. |
About Files to Import
Supported File Formats
xls, xlsx, csv, xlsm, txt
File Contents
-
Enter data for a single label in one row.
-
You do not need to delete unnecessary sheets, rows or columns in advance. You can select a sheet when importing a file. You can select rows and columns after importing a file.
-
Images such as photos
To import image files (BMP, JPG, TIF, or PNG) such as photos and illustrations, enter the full pathname of the image file.
Example: C:\Users\Desktop\Images\aaa.png
How to Operate the Data Creation Window
Editing Data
Double-click on a cell to edit or add data in the cell.
Sorting Data / Entering Column Title
Right-click on the data area to display menus for sorting data, entering column title, etc.
Changing Column Attribute
Click on at the right of the column, and select attribute for the column from Column Attributes.
When a file is imported, attribute of the all columns is set to Text. You need to change the attribute for columns that contain barcode or QR code data, or images (full pathnames of image files).
Selecting Rows to Print
You can select rows and print only the selected rows. Select the check boxes for the rows you want to print.
|
Note: To print only the selected rows, a setting in the print dialog box is also required. |
Exporting Data
You can export the data to a file by clicking Export.
Inserting Data into the Layout Editing Window
You can insert data from the Data creation window to the Layout editing window in one of the following ways.
-
Drag the column
The shape of the mouse pointer changes to when you move it over the column title. While is displayed, you can drag the column.
-
Use in the tool box
When you click , a dialog box as shown below is displayed. Select a column and click OK in the dialog box, and then click at a position you want to insert it in the Layout editing window.