How to produce a payroll in a WPS table

The production of payroll, transcripts are cyclical repetitive work, monotonous and tedious. In this paper, the use of the WPS table intelligent filling and clever algorithm, teach you only a paste, a formula, a drag, to deal with the style of Figure 1 bar document. So, come with me to do one in the WPS text.

　　The first method: Find the Substitution method

First, use the WPS table to open the source data document, as shown in Figure 1, to copy all the data.

Close the WPS table (be sure to close, or there will be a table when you paste it into WPS text), open the WPS text, and press "CTRL + V" To paste the data copied from the source document into the new blank document. At this point, the data is presented as a text state separated by tabs and carriage returns (Figure 2).

Next, make the contents of the 1th row header to the Clipboard, and then press the shortcut key "Ctrl+h", bring up the Find and Replace dialog box, enter "^p" in Find what, and paste the table header that you just copied into the "Replace with" text box, and enter two consecutive "^p" in front of it, followed by a "^p" and note that use wildcard characters is selected (Figure 3).

Click the Replace All button to close the Find and Replace dialog box, where you'll find that there is a row of headers on top of all rows of data except for the beginning of the document and header and footer, and a blank line below it. Delete the extra header rows, select all the documents, choose convert → text to table from the Table menu, and then convert all the data into a table. In the ointment, there are vertical lines in the empty table row, which is not beautiful enough. In this case, we can use all the vertical table lines to set all the "borderless" mode, that is, to display only the horizontal table line method to solve, the final printing effect as shown in Figure 4.

　　The second method: using the next domain method

To start by declaring that the following two methods use mail merge, you need to upgrade WPS Office 2007 to the latest version and install the VBA environment.

Create a new document with WPS text, bring up the Mail Merge toolbar from the View → toolbar (or select mail merge with the mouse right click in the toolbar space). Then click the "Open Data Source" button at the far left of the toolbar to locate and open the WPS form document that contains the source data. Then, follow the header style of the source data and make a 2 Row 7 column table, enter the contents of the header in the 1th row of the table, press the Insert Merge field button (the 3rd button on the left) in the second row of cells, insert the corresponding merge fields item, and then position the cursor in the line below the table, with the left mouse button clicked " Insert the Drop-down menu to the right of the merge field and choose Insert Next field to get the content shown in Figure 5.

At this point, click the View Merge Data button (number 5th on the left) to display the inserted field as the data content. Then select the table and the row that you inserted in the next field, and then paste it back and forth until the table is full, and delete the last Netx field. At this point although all the first person (John) of the pay bar, but actually not so, with the left mouse button in two "View merge data" button, you will find that the data in the payroll is no longer repeat (Figure 6). Finally, click the "Merge to New Document" button, OK, done!

The third method: Delete the section break method

The second method uses the next field, primarily to prevent the problem of having only one record per page after merging to a new document. We can do the opposite, sir. Each page has only one record of the payroll document, and then the section break is deleted, and the pay bar is "called Together".

First, as with the second method, make a table of 2 rows and 7 columns and populate the header and merge fields. Then tap the ENTER key below the table to make it two line break symbols. Press the "Merge to New Document" button directly to generate the Payroll section file. We found a new document generated with only one payroll per page, and a "section break (Next page)" below the Payroll bar (Figure 7).

So there is only one payroll per page, and this is the "section break (Next page)" is making trouble. What do we do? Yes, press "ctrl+h" to bring up the Find and replace panel, in the Find content enter "^b", "Replace with" without entering anything (delete all if there is content), and tick "use wildcard" (Figure 8), point "Replace all" and close. Look at the document again, the pay bar is no longer split, one by one, neatly arranged in the line!