qr code library c# download Part 5: Manipulating Excel Objects in Visual C#

Creator QR Code ISO/IEC18004 in Visual C# Part 5: Manipulating Excel Objects

16
Encoding QR In C#
Using Barcode generation for VS .NET Control to generate, create QR Code JIS X 0510 image in .NET applications.
www.OnBarcode.com
QR Scanner In Visual C#
Using Barcode recognizer for VS .NET Control to read, scan read, scan image in Visual Studio .NET applications.
www.OnBarcode.com
Part 5: Manipulating Excel Objects
Barcode Maker In C#.NET
Using Barcode printer for .NET Control to generate, create bar code image in VS .NET applications.
www.OnBarcode.com
Barcode Decoder In C#.NET
Using Barcode decoder for .NET Control to read, scan read, scan image in Visual Studio .NET applications.
www.OnBarcode.com
Microsoft Office Excel 2003 Programming Inside Out
Quick Response Code Drawer In VS .NET
Using Barcode generator for ASP.NET Control to generate, create QR Code image in ASP.NET applications.
www.OnBarcode.com
QR Encoder In Visual Studio .NET
Using Barcode generation for Visual Studio .NET Control to generate, create QR image in VS .NET applications.
www.OnBarcode.com
Table 16-2.
Printing Quick Response Code In Visual Basic .NET
Using Barcode generator for .NET Control to generate, create QR Code JIS X 0510 image in VS .NET applications.
www.OnBarcode.com
Barcode Encoder In C#.NET
Using Barcode creation for Visual Studio .NET Control to generate, create barcode image in Visual Studio .NET applications.
www.OnBarcode.com
Key Properties and Methods of the PivotTable Object
UPC-A Generator In C#
Using Barcode creation for .NET framework Control to generate, create Universal Product Code version A image in VS .NET applications.
www.OnBarcode.com
Data Matrix ECC200 Maker In Visual C#
Using Barcode encoder for .NET Control to generate, create Data Matrix ECC200 image in Visual Studio .NET applications.
www.OnBarcode.com
Description
Printing ANSI/AIM Code 39 In C#
Using Barcode generator for .NET framework Control to generate, create Code39 image in .NET framework applications.
www.OnBarcode.com
Encode Code 93 In Visual C#
Using Barcode creation for .NET framework Control to generate, create Code 93 image in VS .NET applications.
www.OnBarcode.com
Method: This routine adds a data field to a PivotTable. Field is a PivotField object associated with the PivotTable. Caption contains a value that will be used to label the specified PivotField (optional). Function specifies the summary function performed on the data field. Method: returns a CalculatedFields collection, which contains the set of PivotField objects, which are computed based on other fields in the PivotTable. Property (read-only): returns either a PivotField object or a PivotFields collection containing the fields that are currently displayed as column fields. Property: when True, the PivotTable report displays grand totals for each column in the PivotTable object. Property (read-only): returns either a PivotField object or a PivotFields collection containing the fields that are currently displayed as data fields. Property: when True, any cells with errors will display the text in the ErrorString property. Property: when True, any cells with null values will display the text in the NullString property. Property: contains the text that will be displayed in cells with errors, if the DisplayErrorString property is True. Method: sets the PivotTable s format to one of the formats specified in XlPivotFormatType. Valid formats are xlPTClassic, xlPTNone, xlPTReport1 to xlPTReport10, and xlPTTable1 to xlPTTable10. Property (read-only): returns either a PivotField object or a PivotFields collection containing the fields that are not currently displayed as row, column, page, or data fields. Property: contains the name of the PivotTable. Property: contains the text that will be displayed in cells with null values when the DisplayNullString property is True. Property (read-only): returns either a PivotField object or a PivotFields collection containing the fields that are currently displayed as page fields.
Bar Code Printer In Objective-C
Using Barcode generation for iPad Control to generate, create bar code image in iPad applications.
www.OnBarcode.com
USS-128 Generation In None
Using Barcode creation for Font Control to generate, create GS1-128 image in Font applications.
www.OnBarcode.com
Property/Method
Generate Barcode In Visual Studio .NET
Using Barcode creator for .NET Control to generate, create bar code image in .NET applications.
www.OnBarcode.com
Draw DataMatrix In .NET
Using Barcode encoder for ASP.NET Control to generate, create Data Matrix ECC200 image in ASP.NET applications.
www.OnBarcode.com
AddDataField(Field, Caption, Function)
Denso QR Bar Code Generation In Objective-C
Using Barcode creation for iPad Control to generate, create QR Code JIS X 0510 image in iPad applications.
www.OnBarcode.com
Matrix Barcode Drawer In Visual Studio .NET
Using Barcode encoder for ASP.NET Control to generate, create 2D Barcode image in ASP.NET applications.
www.OnBarcode.com
CalculatedFields
Data Matrix ECC200 Drawer In VS .NET
Using Barcode generator for .NET framework Control to generate, create DataMatrix image in Visual Studio .NET applications.
www.OnBarcode.com
QR-Code Recognizer In VB.NET
Using Barcode recognizer for .NET framework Control to read, scan read, scan image in VS .NET applications.
www.OnBarcode.com
ColumnFields
ColumnGrand DataFields
DisplayErrorString DisplayNullString
16
ErrorString Format (format)
HiddenFields
Name NullString
PageFields
Part 5: Manipulating Excel Objects
PivotTables and PivotCharts
Table 16-2.
Key Properties and Methods of the PivotTable Object
Description
Method: returns an object reference to the PivotCache object associated with the PivotTable. Method: returns either the PivotField object specified by the index parameter, or returns the collection of all PivotFields if index is omitted. Method: constructs a PivotTable named TableName using
data from SourceData and places the result at
TableDestination.
Property/Method
PivotCache PivotFields (index)
PivotTableWizard (SourceType, SourceData, TableDestination, TableName, RowGrand, ColumnGrand, SaveData,
HasAutoFormat, AutoPage,
Reserved, BackgroundQuery,
OptimizeCache, PageFieldOrder,
PageFieldWrapCount,
ReadData, Connection)
RefreshTable RowFields
Method: refreshes the data displayed in the PivotTable based on the data in the associated data source. Property (read-only): returns either a PivotField object or a PivotFields collection containing the fields that are currently displayed as row fields. Property: when True, displays grand totals for each row in the PivotTable. Property (read-only): returns either a PivotField object or a PivotFields collection containing the fields that are currently displayed in the PivotTable.
RowGrand VisibleFields
Refresh Your Data Use the RefreshTable method to update the information displayed in the PivotTable if the source data changes.
PivotCaches Collection
The PivotCaches collection contains the set of all PivotCache objects (see Table 16-3). Because PivotCache objects are stored at the workbook level, they can be easily used to create PivotTables and PivotCharts anywhere in the workbook.
16
Part 5: Manipulating Excel Objects
Microsoft Office Excel 2003 Programming Inside Out
Table 16-3.
Key Properties and Methods of the PivotCaches Collection
Description
Method: adds a new PivotCache object to the collection. SourceType identifies where the data is coming from. Can be xlConsolidation, xlDatabase, xlExternal, xlPivotTable, or xlScenario. SourceData specifies additional information about the source of the data. Typically, this source is a Range object, although in the case of an external database it s a two-element string array, where the first element contains the connection string and the second element contains the SQL query that retrieves the data. Property (read-only): returns the number of items in the PivotCaches collection. Method: returns the PivotCache object reference associated with index. Index may refer to the PivotTable by either its name or its relative position in the collection.
Property/Method
Add(SourceType, SourceData)
Count Item(index)
PivotCache Object
The data displayed in a PivotTable is stored in the PivotCache object. You can reference the PivotCache through the PivotCache method associated with the PivotTable object or through the PivotCache collection associated with the Workbook object. Multiple PivotTables can share the same PivotCache object.
Copyright © OnBarcode.com . All rights reserved.