Formula One report

Formula OneThere are very few materials. I have collected the recently found materials for future viewing.

 

 

//Read template files

Axf1book1. readex (@ "F: \ access \ dom3.vts");

// Textsrc (1, 1, 1 ,"The first row and column of the First worksheet in the workbook.

// \ NLine feed

Axf1book1. set_textsrc (1, 1, 1,"Title"+"\ N"+"\ NSummary Date :"+"1212313");

//Converts a specified cell to a value. axf1book1. get_entryrc (rows, 3) indicates the selected cell.Axf1book1. set_numberrc (rows, 3,Convert. Todouble (axf1book1. get_entryrc (rows, 3 )));

//Select a region

Axf1book1. Selection ="A6: g16";

///Set the border style.

Axf1book1. setborder (1, 1, 1, 1, 1, 1, 1, 1 );

//Calculate the numbers of the specified cells, and place them in.

Axf1book1. set_formularc (18, 3,"Sum (C6: C15 )");

//Merge Cells

Ttf160.F1cellformatAA;

AA = axf1book1. createnewcellformat ();//Create a new cell style

AA. mergecells =True;//Set to enable merging Cells

Axf1book1. setselection (17, 2, 20, 2 );//Select a region

Axf1book1. setcellformat (AA );//Cell format

//Activate other tables. Int indicates the tables.

Axf1book1. Sheet = 2;

//Insert row

Axf1book1. editinsert (ttf160.F1shifttypeconstants. F1shiftrows );// F1shiftcolsInsert column

//Delete row

Axf1book1. editdelete (ttf160.F1shifttypeconstants. F1shiftrows );

//Delete selected Worksheet

Axf1book1. editdeletesheets ();

//Insert Worksheet

Axf1book1.Editinsertsheets ();

//Font Style settings

Axf1book1. setselection (6, 1, 6, 7 );//Select a row

Axf1book1. fontname ="Shu";//Set Font

//The font color is color. Red;

Axf1book1. fontcolor =Color. Blue;//Set Font color

Axf1book1. fontitalic =True;//Set Italic

Axf1book1. fontsize = 18;//Set Font Size

Axf1book1. fontstrikeout =True;//Set strikethrough (strikethrough)

Axf1book1. fontunderline =True;//Underline

//Set the style as follows:

Axf1book1. setselection (6, 1, 6, 7 );//Select a row

Axf1book1. formatcurrency0 ();//Set the style to ￥

//The following content is in the same format as above;

formatalignmentdlg () // " alignment mode " dialog box

formatborderdlg () // " border " Setting Dialog Box

Formatcellsdlg (long pages)//Pop-up"Cell"Dialog Box

Formatcurrency0 ()//Format currency

formatdefaultfontdlg () // display " default font " dialog box

Formatfontdlg ()//Display"Font"Dialog Box

Formatfraction ()//"Score"Format

Formatgeneral ()//"General"Format

Formathmmampm ()//12Hour format

formatmdyy () // date formatting

formatnumberdlg () // " Number " Format dialog box

formatobjectdlg (long pages) // " Object " Format dialog box

Formatpatterndlg ()//Pop-up"Mode"Dialog Box

Formatpercent ()//% Formatting

Formatscientific ()//Scientific notation Format

Search

Axf1book1.Finddlg ()//The "Search" dialog box is displayed.

//Print

//Whether to print table lines

Axf1book1. printgridlines =True;

//Print directly. Whether to display the Print dialog box

Axf1book1. fileprintex (True,False);

Axf1book1. fileprintex (bshowprintDLG, Bprintworkbook)

BshowprintDLG-Whether to display printing settings

Bprintworkbook---Print range,True: RefersThe entire workbook. "false" indicates that the worksheet is printed;

Related links:Http://hi.baidu.com/yiwen228/blog/item/d2f0c33641e14f380a55a949.html