First, create a new Excel document, right-click on the desktop, select "New"-"Excel Worksheet" and name "Novice Learner".
Now that the new Excel document is blank, we will then open and write some data by pressing the wizard 's script.
Open the Key Wizard software, click "New", go to My scripting interface, and then click on "All commands."
In all commands, select Plug-in Commands-Office Office document plug-in-open Excel document.
Below the command you can see the detailed settings of the command, click on "path".
In the pop-up window, select "Novice Learner" in the Excel document and click Open.
You can see the referenced document in the command parameters and click Insert to insert the corresponding command script.
Continue to write new data in the document, select the command "Writexls to Excel document Cells", select the corresponding cell row and column, enter the content to be written to the cell "" Ordinal ", click Insert.
The newly inserted code can be seen in the scripting interface.
Depending on a similar format, you can add additional code that writes a total of 3 rows and 4 columns of cell content.
Finally select "Closexls Close Document" and click Insert Corresponding code.
Modifies the description of the script property and the saved script file name. After saving the script, press "F10" to debug the script.
Once the script executes, open the Excel document again and you can see that the data you just set has been successfully written.
Key Wizard How to invoke Excel and Key wizard methods to write Excel data tutorial---Getting Started with the automatic action table