Using WPS to transfer online information to spreadsheet

Source: Internet
Author: User

To commemorate the 90 anniversary of the founding of the party, the provincial education Department organized the "under the Sun" Network reading activities. The information group needs to convert the students ' participation information published on the network to the form save. With WPS Office2012, the job is much easier. Interested friends, you can follow the steps below to operate.

A new text document, named "Student participation information. txt". Log in to the relevant website (http://www.shangshu.com/ecenter/) and inquire about the students ' participation information. Copy and paste into the text document you just created.

Query interface:

1, select the relevant information replication.

2, paste in the text document.

3, go back to the website, go to the next page, copy the relevant information, and then paste in the text document.

4, repeat the above operation until all the information is pasted into the text document.

5, save the text document.

Second, import the text document into the WPS form.

1, new WPS form, named "Student participation information. ET".

2, the implementation of "data" → "Import data", in the pop-up dialog box click "Select Data Source" or "next".

3, in the new pop-up interface to locate the "Student entry information. txt", open.

4, in the pop-up "file Conversion" interface, click Next.

5, in the Pop-up Text Import Wizard-3 Steps 1 dialog box, select the separator symbol (D).

6, in the Pop-up Text Import Wizard-3 Steps 2 dialog box, select the appropriate separator symbol, in this case, select "Space" and click Next.

7. Click Finish in the Pop-up Text Import Wizard-3 Steps 3 dialog box. At this point, the student entry information is imported into the spreadsheet.

Screenshot of spreadsheet:

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.