Part 9: Managing Databases and Lists in Visual C#

Print QR Code JIS X 0510 in Visual C# Part 9: Managing Databases and Lists

You can print the list object by clicking the Print List Range button on the List toolbar. The list object expands as you add new rows. Columns added directly to the right are automatically incorporated into the list object. Charts based on columns in list objects expand as new data is added. Range names assigned to columns in list objects expand as new data is added. The list is protected against accidental row and column deletions. The Move On Enter feature is disabled.

Note If you don t want Excel to expand your list object when you add rows or columns, choose Tools, AutoCorrect options. On the AutoFormat As You Type tab of the AutoCorrect dialog box, clear Include New Rows And Columns In List. Before you click OK to create your new list object, make sure that the range reference proposed in the Create List dialog box is correct (if you have selected more than one cell in the list but not the entire list, you ll need to adjust this reference or start again with a single-cell selection), and that the state of the check box accurately indicates the presence or absence of a header line atop your list. If you don t have headers, Excel will create them for you when you click OK, using the labels Column 1, Column 2, and so on. When you click OK, Excel does the following:

28

labels in boldface, and turns AutoFilter on. (For information about using AutoFilter, see Using the AutoFilter Command on page 730.)

selecting a list object). Figure 28-3 shows the effect of these changes on the Staff list shown in Figure 28-1.

Figure 28-3. When you create a list object, Excel turns AutoFilter on and inserts a row below the list to accommodate your next entry.

Provided you have authoring rights on a SharePoint site, you can publish a list object to that site. Select any cell within it (or the entire list), and then choose Data, List, Publish List. The Step 1 dialog box appears:

28

Type the URL for your SharePoint site on the Address line. (If you have already published one or more lists to this site, you can simply select the URL from the drop-down list.) Select the Link To The New SharePoint List check box if you want to be able to synchronize your Excelresident list object with the version you publish. (Synchronizing allows your worksheet to be updated if anyone changes the list in SharePoint, as well as letting you transmit changes you

Microsoft Office Excel 2003 Inside Out make in Excel to the SharePoint site.) Supply a name and (optionally) a description for your new SharePoint list, and then click Next. The Step 2 dialog box, which might look something like this, appears:

This dialog box asks you to acknowledge two bits of bad news. First, SharePoint handles only particular data types and constrains whatever you publish to those formats. Second, in the process of publishing your list, SharePoint converts any calculated values to constants; that is, it removes formulas and replaces them with current results. As we ll see, workarounds for both limitations are available. You can t change the data types proposed in the Step 2 dialog box. All you can do is acknowledge and acquiesce (by clicking Finish) or bail out (by clicking Cancel). When you click Finish, a message confirming the transfer will appear, complete with a link that takes you straight to the published list.

28

If you have chosen to link your list object to the SharePoint site, your worksheet will now show the following changes: