VFP6 0 uses the EXCLE table

1 Create an Excel object.

eole=createobject(‘

2 Add a new workbook.

3 Set the 3rd worksheet to the active worksheet.

4 Open the specified workbook.

Temp 5 displays the excel window.

6 Change the Excel title bar.

The application calls Microsoft Excel".

7 Assign a value to the cell.

4).value=xm (xm is the database field name)8 Specify the width of the specified column (unit: number of characters).

9 Set the height of the specified row in pounds

Set the row height to 1 cm, 1 lb = cm).

10 Insert a page break before line 18.

11 Remove the page break before column 4.

12 Specify the width of the border line (the borders parameter is as follows) :d 3")borders(2).weight=313 sets the type of the four border lines.

d3”).borders(2).

linestyle=1 where borders parameters: 1 left, 2 right, 3 top, 4 bottom, 5 oblique, 6 oblique ;linestyle values: 1 and 7 fine solid, 2 fine dotted, 4 dotted dotted, 9 thin solid lines).

14 Set the header.

Report 1"15 sets the footer.

pp"16 Set the header-to-top margin to 2 cm.

17 Set the footer to a margin of 3 cm.

18 Set the top margin to 2 cm.

19 Set the bottom margin to 4 cm.

20 Set the left margin to 2 cm.

21 Set the right margin to 2 cm.

22 Set the page to be horizontally centered.

23 Set the page to be vertically centered.

24 Setting the Page Paper Size (1 Narrow Line8 5 11 39 Wide Line 14 11)25 Printing Cell Lines.

26 Copy the entire worksheet.

27 Copy the specified area.

e2”).copy

28 Paste.

29 Insert a line before line 2.

30 Insert a column before column 2.

31 Set the font.

1).Boldbody".

32 Set the font size.

33 Set the font to italics.

34 Sets the entire column font to bold.

35 Clear cell formulas.

4).clearcontents

36 Print Preview Worksheet.

37 Printout worksheet.

38 Worksheets are separate.

temp 39 discard.

40 Close the workbook.

41 Exit Excel

If you don't know how to find me!

1) Copy structure to "File Name" [fields "Field Name Table"].

Function: Copy the structure of the current table to the specified table. (Only the structure of the table is copied, its record data is not copied).

Note: 1. When you set the fields "Field Name Table" option, only the contents of the field are included in the newly generated table file.

2. If omitted, the structure of the copied table file is the same as that of the current table.

Example: Copy a table.

use students.

copy structure to student1 fields Student ID, Name, Gender & Place Student Sheet, Name, Student, Name, Student, Name, Student, Student, Name, Student, Name, Student, Student, Name, Student

The structure of the three fields of gender is copied to.

Student 1 in the table.

2) Modify the table structure.

Format: modify structure

Function: You can modify each field, add, delete, move the field, or modify the index mark.

Enter the command: use 《filename》 > Open the file you want to modify first.

Modify Structure & Enter the table structure modification command, and you will pop up "Table Designer" to add fields directly.

or modify the field.

copy stru to table name.

Modify the table structure modi stru, and you can also modify the field name and add a new field.

To copy the table structure, use the following parameter to copy structure to 《filename》

To modify the table structure, use the following parameter to modify the structure