Key Wizard How to invoke Excel and Key wizard methods to write Excel data tutorial---Getting Started with the automatic action table

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.