How to convert cable inventory (Excel sheet) directly into cable license plate

If your cable inventory includes these columns, 1. cable number, 2. cable start, 3. cable terminal, 4. cable model can be directly imported into the Shuofang signage machine editing software SP Editor, import steps will be described in detail below.

If your cable inventory is not such a content, you can slightly organize, cable signage width is limited, try to minimize the number of columns, each column corresponds to the cable signage subcontent for each line, the more the number of columns in the cable inventory form, the more the number of rows of cable signage.

The cable inventory imported into the Shuofang sign machine editing software SP Editor steps are as follows:

Cable inventory

The first line of the contents of the title of each sign, from the second line of the beginning of the contents of the title of each sign in turn after the content to be printed. After editing the printed content, archive the file. Open the sp editing software, click "File" and select "Material Options" to set the type and size parameters of the sign, such as the sign is set to "32 * 68" single hole, and then click "File" and select "Material Options" to set the type and size parameters of the sign. "File" select "import excel file", as shown in Figure 2.

Shuo square sign machine editing software SP Editor editing page

In the pop-up page to find the storage location of the imported file, and select the print file, then the software will pop-up page shown in Figure 3, click "Sheet1" both excel file storage location, you can display the content of the imported file, as shown in Figure 3, and then click "File" and select "Import excel file", as shown in Figure 2. The content of the imported file, as shown in Figure 3.

Special note: If you want to print the contents of the sign without title, the first line shown in Figure 3 as the column headings. Click on Figure 3, "Settings", you can set the file to be imported, you can set the following contents as shown in Figure 4:

Figure 3, Figure 4

After importing, the content of the right side of each sign is the title, and the left side of the contents of the cable inventory of each sign. For the file generated after import, you can subsequently edit the location of the content, text format and size, etc. .

Turned into a cable sign content

Through the above steps can quickly solve the problem of how to make the cable inventory into a cable sign, using the Shuofang signage machine should be installed in advance of the ribbon, as well as the required signage, to confirm that all the preparations are ready, you can edit the software through the "print" command, complete the Batch cable inventory into cable license plate work.