zxing qr code encoder example c# expression.Add(SourceType, Source, LinkSource, HasHeaders, <;$RD> Destination).Name=namestring in Visual C#

Generate QR Code 2d barcode in Visual C# expression.Add(SourceType, Source, LinkSource, HasHeaders, <;$RD> Destination).Name=namestring

Table 26-2.

An expression that returns a ListObject object. One of two XlListObjectSourceType constants: xlSrcExternal, which indicates an external data source, or xlSrcRange (the default), which indicates the data source is a range in a workbook.

Table 26-2.

(continued)

When SourceType is set to xlSrcRange, this argument refers to the range used to create the ListObject. When SourceType is set to xlSrcExternal, this argument must contain an array of three strings (a URL to a page on a SharePoint site, a list name, and a value representing the view to be applied to the list). There s no list of these values in the Visual Basic Editor Help system, so you should leave the third element of the array blank unless you are, or can get the correct values from, a SharePoint administrator. A Boolean value that indicates whether to link the list to an external data source. The default value is True if the SourceType argument is set to xlSrcExternal. Setting the argument to either True or False when the SourceType argument is set to xlSrcRange creates an error. A variant value that indicates whether the ListObject has an existing set of column labels. The argument can be set to xlGuess, xlNo, or xlYes. If the source data doesn t contain column labels, or if Excel can t detect them, the method will create headers. A Range object that identifies the cell at the top left corner of the new list object. The destination must be on the worksheet that called the Add method. A string that contains a unique name for the list.

26

Required if the SourceType argument is set to xlSrcExternal; ignored if the SourceType argument is set to xlSrcRange Required

Note The Add method inserts new columns to the right of the cell identified in the Destination argument to ensure that there s room for the new list; existing data won t be overwritten.

Excel and the Extensible Markup Language (XML)

A Better Way to Create Lists If you check the Visual Basic Editor Help file for the ListObjects collection s Add method, you won t see the .Name = namestring bit at the end. The example in the Help system requires you to create a new object and use a much longer statement to generate the same result. Also, if you use the Add method in the manner described in the Help system, you ll get error messages because the ListObject you create has no name. The Add statement in the example might seem a bit confusing, but you can think of it as a form of the following statement:

You re creating the member of the ListObjects collection in the same statement where you name it, but all is well because the ListObject exists when the Visual Basic Editor encoun ters the Name method.

As an example of how to use the ListObjects collection s Add method, consider the worksheet shown in Figure 26-3, which has a series of cells that contain values to be used as column labels.

Figure 26-3.

26

Microsoft Office Excel 2003 Programming Inside Out You could create a list based on that set of column labels using this procedure (which you would add to a code module):

Sub CreateListObject() ActiveSheet.ListObjects.Add(xlSrcRange, Range( $A$1:$K$1 ), , xlYes)<;$RD> .Name = Suppliers1" End Sub

Lists are a terrific addition to your battery of Excel tools, but they re even more powerful when you combine them with XML data. The next section of this chapter introduces the basics of the Extensible Markup Language and how Excel uses it to facilitate data handling.

26

At the heart of XML-based data interchange is the schema, which is a document that defines the structure of a set of XML files. You can create a custom schema in an XML editor, write the XML code yourself in a simple text editor such as Notepad, or you can have Excel do it for you when you save a workbook as an XML document. The following listing, which was created using Notepad, shows the schema used in the examples throughout this chapter:

< xml version="1.0 encoding="utf-8 > <schema xmlns="http://www.w3.org/2001/XMLSchema"> <element name="Root"> <complexType> <sequence> <element name="Supplier maxOccurs="unbounded"> <complexType> <sequence> <element name="SupplierID type="positiveInteger"/> <element name="CompanyName type="string"/> <element name="ContactName type="string"/> <element name="ContactTitle type="string"/> <element name="MailingAddress"> <complexType> <sequence> <element name="Address type="string"/> <element name="City type="string"/> <element name="Region type="string"/> <element name="PostalCode type="string"/> <element name="Country type="string"/> </sequence> </complexType> </element> <element name="Phone type="string"/> <element name="Fax type="string"/> </sequence> </complexType> </element> </sequence> </complexType> </element> </schema>

Excel and the Extensible Markup Language (XML) Don t let the long set of closing tags at the bottom of the list fool you the structure of the data objects depicted in the schema isn t that complex. Figure 26-4 depicts the schema s structure graphically instead of textually.

Figure 26-4.