Operating environment: ASUS Ling Yao Pro 14, win 10, WPS 10.0.27.

1. Open the Excel table to be processed.

2. Calculate the product in cell C 1, and enter = A 1 * B 1 in cell C 1.

3. When you return to the editing area, you can see the calculation results.

Excel has the following functions:

1, basic Excel function

Basically, excel controls support some basic functions of excel, such as single selection, multiple selection, cell merging, multiple worksheets, cross worksheets, formula indexing, hierarchical display, grouping, conditional formatting, sorting, row filtering, etc.

2. Import and export Excel

In general, the excel control will independently install the input and output engine of excel file format, and the input and output of excel file format can be performed without installing excel. Charts, graphs and images designed in the development process will be output to excel files as objects.

3.Excel formula support

Excel control has a formula calculation engine, which supports built-in functions and uses built-in functions and operators to customize formulas. Usually supported functions are date, time, engineering calculation, financial calculation, logic function, mathematical trigonometric function, statistical function, text function and so on.