New generation. Net Office Development Guide: Excel

New generation. Net Office Development Guide: Excel 

Chapter 1 basics of using Excel
1.1 Work thin and worksheet 2
1.2 Excel user interface 2
1.3 format and appearance 5
1.4 formulas and functions 6
1.5 graphics and charts 10
1.6 data analysis tool 12
1.6.1 data filtering 12
1.6.2 Classification summary and classification display 12
1.6.3 PivotTable and pivot 12
1.7 protection Option 13
1.8 macro and programmable 16
1.9 help system 17
1.10 exercise 18
Chapter 2. Net Excel application development Basics
19
2.1 Excel application development policy 19
2.2 understand. Net Excel programming model 21
2.2.1 create the first. Net Excel application
21
2.2.2 basic Excel Object 23
2.2.3 object model and Programming Method 28
2.2.4 understand office Pia 29
2.3 learn how to use Visual Studio Tools
Office (vsto) 30
2.3.1 sales list procedure 30
2.3.2 understand Visual Studio Tools
Office 35
2.3.3 use Windows Forms control 37
2.4 interaction with Excel objects 39
2.4.1 Application Object 39
2.4.2 workbook object 43
2.4.3 worksheet object 46
2.4.4 range and namedrange objects 47
2.4.5 window object 50
2.4.6 globals class 53
2.4.7 czexcel-Excel-assisted development library 54
2.5 exercise 54
Chapter 5 automated data processing 55
3.1 Overview 55
3.2 cell annotation 56
3.2.1 add comments to cells 56
3.2.2 traverse annotation 57
3.3 Automatic Data filling 58
3.3.1 multiple automatic filling Methods 58
Case study: standard limit 60
3.4 search and replace 63
3.4.1 data search and replacement 63
Case study: Computer Accessories list 65
3.5 data sorting 71

3.5.1 sorting Method 71
Case study: 72 League points
3.6 data filtering and hierarchical display 75
3.6.1 automatic filtering and advanced filtering Methods 75
Case study: exam score filtering 77
3.6.2 Classification and outline display 82
Case study: sales data classification display 83
3.7 exercise 85
Chapter 4th integration with Windows Forms 87
4.1 overview 87
Comprehensive Practice 4-1 industrial goods sales contract procedure --
Focus on workbooks 88
Program function overview 88
Build project 88
Create buyer and seller Basic Information Form 91
Create contract terms Option Form 93
Primary worksheet function 96
Print contract 101
Comprehensive Practice 4-2 product barcode label printing program --
Use Windows Forms
Center 101
Program functions 101
Windows form design 102
Create Product class goodsitem 104
Print tag 106
Comprehensive Practice 4-3 bookstore cash register management procedure --
Use the Spreadsheet control 110.
Spreadsheet control 110
Program functions 112
Main program form design 112
Sales business processing 115
4.2 exercise 120
Chapter 2 menu and toolbar 5th
5.1 overview 121
5.2 office objects related to menus and toolbar
122
5.3 custom menu 124
5.3.1 add custom menu 124
Case study: Target Rating Program 128
5.3.2 add shortcuts 136
Case study: Send email 137 to address book
5.4 custom toolbar 141
5.4.1 add toolbar and toolbar button 141
5.4.2 customize toolbar buttons and icons 145
Case study: Excel Screen Saver 146
5.5 exercise 152
Chapter 2 Smart Document Programming Technology 6th
6.1 Overview 153
6.1.1 smart flag 154
6.1.2 operation pane 154

6.2 Smart Tag 155
6.2.1 create a Smart Tag 155
Case study: intelligent temperature conversion mark 158
Case study: intelligent tagging of books and information 160
6.3 operation pane control 165
6.3.1 use the operation pane control 165
Case study: Personnel Archive Management 168
6.4 exercise 174
Chapter 2 table style 7th
7.1 overview 175
7.2 basic style 176
7.2.1 font and color operations 176
7.2.2 cell size setting and obtaining 179
7.2.3 border settings 179
7.2.4 text style setting 182
7.3 advanced style 185
7.3.1 about style object 185
7.3.2 automatic format 188
7.4 predefined style 191
7.4.1 pre-defined Style Class czstyle 191
7.4.2 pre-defined style group czstylegroup 198
Case study: Apply style group class
Czstylegroup 205
7.5 exercise 207
Chapter 4 using worksheet functions 8th
8.1 overview 209
8.2 perform basic operations 210
8.2.1 use worksheetfunction interface 210
8.2.2 basic mathematical functions 211
Case study: solving equations 212
8.2.3 trigonometric function 213
Case study: Draw a trigonometric curve of 213
8.2.4 logical functions 216
8.3 text information processing 216
8.3.1 text function 216
8.3.2 information function 217
Case study: product list verification 218
8.4 statistics, query and analysis 225
8.4.1 statistical function 225
8.4.2 search and reference functions 228
Case study: score statistical analysis 229
8.5 financial processing 239
8.5.1 financial function 239
Case study: depreciation statistics of Fixed Assets: 240
8.6 exercise 244
Chapter 2 graphics and charts 9th
9.1 overview 245
9.2 Drawing Graphics 246
9.2.1 shape object 246
9.2.2 drawing a custom image 247

9.2.3 set 3D effect 249
9.2.4 set shadow mode 251
9.2.5 draw wordart 252
Comprehensive Practice 9-1 analog clock 253
Program function 253
Appearance drawing 253
Clock running 255
9.3 drawing charts 256
9.3.1 create an embedded chart 256
9.3.2 create a chart 259
9.3.3 set data series and coordinate axes 261
9.3.4 add multiple chart objects to the chart table
264
Comprehensive Practice 9-2 sales analysis chart 266
Program function 266
Drawing charts 267
Predicted future sales of 269 million
Output image file 271
9.4 exercise 273
Chapter 2 pivot tables and data perspective 10th
10.1 overview 275
10.2 Pivot Table 276
10.2.1 create a basic PivotTable 276
10.2.2 create an advanced PivotTable 280
10.2.3 format the PivotTable 284
10.3 data perspective 287
10.3.1 automatically create a data perspective 287
10.3.2 create a data perspective in the program 288
10.3.3 create a custom chart for the PivotTable
289
10.4 connect to external database 291
10.4.1 obtain data from external database 291
Case study: Financial report analysis 292
10.5 exercise 299
Chapter 2 security programming 11th
11.1 overview 301
11.2 Excel document protection 302
11.2.1 protection bandwidth: 302
11.2.2 protect worksheet 305
11.2.3 allow users to edit the specified region 307
11.2.4 encrypt thin files 308
11.3 hide data 309
11.3.1 hide an excel program 310
11.3.2 hide the working thin area 310
11.3.3 hide a worksheet 310
11.3.4 hide the cell area 312
Case study: Computer accessory list Ultimate Edition 313
Comprehensive Practice 11-1 multi-user sales business management
Program 317
Program functions 317

Sales data analysis 318
User Login form 323
Implement different user functions 325
11.4 exercise 328
Chapter 2 interaction with external programs 12th
12.1 Overview 329
12.2 Start external applications 330
12.2.1 use the process object to start external
Program 330
Case study: Broadcast Program 331
12.3 interaction with office applications 335
12.3.1 access other office applications 335
Case study: Company customer information management 336
12.3.2 in other office applications
Access Excel 347
Case study: generate academic journal framework 349
12.4 access external database program 356
12.4.1 use ADO. Net to access the database
356
Case study: employee payroll system 358
12.5 exercise 370
Chapter 2 workbooks and Web applications 13th
13.1 overview 371
13.2 Access Excel Data from web pages 372
13.2.1 problems with direct access policy 372
13.2.2 ASP. NET + ADO. Net Access
Policy 374
13.2.3 Use offline Cache Technology 376
13.3 access web service 377 from Excel
13.3.1 call Web Service 377
Case study: Inventory statistical analysis 379
Comprehensive Practice 13-1 online survey procedure 385
Program functions 385
Create an Excel worksheet 386
Web page 387
13.4 exercise 390
Chapter 4 deploying applications 14th
14.1 overview 391
14.2 environmental requirements 392
14.3 security requirements 393
14.3.1 running permission and member condition 393
14.3.2 use the. NET Framework Configuration Tool
Manage running permissions 394
14.3.3 use the caspol tool to manage the operation
Permission 397
14.4 create an installation file 398
14.4.1 create and install project 398
14.4.2 automatically complete permissions during installation
Configure 400
14.5 exercise 403

Chapter 2 Comprehensive Case Study: Academic Achievement Management System
405
15.1 program function overview 405
15.2 develop local management programs 408
15.2.1 create a project 408
15.2.2 paper review 408
15.2.3 paper data statistics 415
15.2.4 system user management 418
15.3 create Web Service 429
15.3.1 create a project 429
15.3.2 access user data 430
15.3.3 access thesis data 433
15.4 Development System website 437
15.4.1 create a project 437
15.4.2 logon page 437
15.4.3 system homepage 440
15.4.4 retrieval page 441
15.4.5 personal information page 444
15.4.6 Statistical Analysis page 449

Examples

Apply AutoFill as the AutoFill Filling Method
-- Autofillsample 59
Case study: standard limit 60
Case study: Computer Accessories list 65
Case study: 72 League points
Case study: exam score filtering 77
Case study: sales data classification display 83
Comprehensive Practice 4-1 industrial goods sales contract procedure
-- Use workbooks
Center 88
Comprehensive Practice 4-2 product barcode label printing program
-- Windows form application
Center 101
Comprehensive Practice 4-3 bookstore cash register management procedure
-- Use the spreadsheet Control
110
Exercise now 2 Add a custom menu to the menu bar
-- Excelmenusample 124
Case study: Target Rating Program 128
Case study: Send email 137 to address book
Exercise now 3. Add a toolbar button to the Standard toolbar
-- Exceltoolbarriers sample 142
Exercise at Will 4 place the new toolbar in different locations
-- Excelnewtoolbarsample 143.
5. Add a toolbar button to the custom toolbar,
And set different style attributes
-- Exceltoolbarbuttonsample 145
Case study: Excel Screen Saver 146

Exercise 6 to create a Smart Tag
-- Smarttagsample 155
Case study: intelligent temperature conversion mark 158
Case study: intelligent tagging of books and information 160
7. Create an operation pane Control
-- Actionspanelocation 165
Case study: Personnel Archive Management 168
Use different line types, widths, and colors
Draw different parts of the border --
Borderssample 180
Exercise 9 with different horizontal and vertical alignment
Display text --
Textstyle sample 182
Use different filling modes and
Fill color to construct the background --
Back groundsample 186
Example of automatically applying format
-- Autoformatsample 189
Case study: czstylegroup
205
Case study: solving equations 212
Case study: Draw a trigonometric curve of 213
Case study: product list verification 218
Case study: score statistical analysis 229
Case study: depreciation statistics of Fixed Assets: 240
Exercise 12 to draw all your office Images
-- Shapesample 248
Exercise at will 13 set different 3D effects of the selected Image
-- Threedsample 250
Exercise freely 14. Set the shadow type and transparency of the image
-- Shadowsample 251:
Comprehensive Practice 9-1 analog clock 253
15 programs for "Drawing trigonometric curve"
Chart Implementation Method --
Curvechartsample 258
Drawing charts and tables
-- Surveychart 259
Draw a Gantt chart of task progress
-- Schedulechar263
Add Multiple widgets to the chart table
Embedded chart-gradescatter 265
Comprehensive Practice 9-2 sales analysis chart 266
Exercise 19 to create a simple Pivot table
-- Receivttablesample 276
Exercise now 20 to create an advanced Pivot table
-- Saleportfolio 281
Exercise now 2 create a custom table from the pivot table
Perspective -- saleportfolio1 289
Case study: Financial report analysis 292
Example of protecting the workbook Program

-- Workbookprotection 303
Sample Worksheet Protection Program
-- Worksheetprotection 306
Example of hiding a worksheet
-- Worksheet ethidden 311
Case study: Computer accessory list Ultimate Edition 313
Comprehensive Practice 11-1 multi-user sales business management
Program 317
/Demo: Play program 331
Case study: Company customer information management 336
Exercise freely 25. Create an Excel chart from a Word Table
--- Chartinword 347
Case study: generate academic journal framework 349
Case study: employee payroll system 358
Practice 26 directly through office Pia
Example of accessing Excel --
Badexcelweb sample 372
Practice 27 using ASP. NET + ADO. net
Example of an access policy --
Excelwebsample 375
Get weather through Web Service
Forecast Data and write it into an Excel table --
Weatherrecord 378
Case study: Inventory statistical analysis 379
Comprehensive Practice 13-1 online survey procedure 385