zxing qr code encoder example c# Part 6: Excel and the Outside World: Collaborating Made Easy in Visual C#

Draw QR Code in Visual C# Part 6: Excel and the Outside World: Collaborating Made Easy

25

Notice that Excel appends the filename extension .htm to whichever filename you enter in this text box. This is the standard extension for a HyperText Markup text file. If you plan to publish the Web page on a UNIX Web server, keep in mind that this operating system is sensitive to uppercase and lowercase letters in the filename. The Macintosh and Windows operating system are both case blind when it comes to filenames.

25

6 Specify a title for the Web page; click the Change Title button in the Save As dialog box. Type the text for the title in the Set Page Title dialog box, and click OK.

The Procedure Depends on You To save a chart that wasn t selected prior to opening the Save As dialog box, click the Publish button and then select the chart, identified by its description from the Choose dropdown list. To save a specific range of cells that you didn t select prior to opening the Save As dialog box, click the Publish button. Then select Range of Cells from the Choose dropdown list before you type the range address in the text box immediately below, or enter the range by selecting the range of cells by highlighting them in the worksheet.

While saving your worksheet data in the new Web page, Excel automatically creates a new folder with the same name as the .htm file that contains all the supporting files, including the graphics files and charts among the numerical data. So if you move the Web page from a local drive to a Web server, you need to copy the supporting files folder, as well as its Web page file, to ensure that the user s browser can successfully open the entire contents of the page. If you don t want Excel to create a separate folder with the supporting files, change the setting in the Web Options dialog box. To open the Web Options dialog box, select the Tools menu from Microsoft Excel and then select Options. Select the General Tab, and click the Web Options button. In the Web Options dialog box, select the Files tab. Remove the check mark from the Organize Supporting Files in a Folder check box on the Files tab. Note

Keep in mind that when you save an entire workbook containing worksheet data and charts on separate worksheets, Internet Explorer preserves the original Excel sheet arrangement in the resultant static Web page by adding sheet tabs at the bottom of the Internet Explorer window.

Alternatively you can save your worksheet as a Web page using Microsoft Visual Basic for Applications (VBA) code. Review the following simple procedure to save your active worksheet as a Web page:

Sub SaveAsWebPage() With ActiveWorkbook.PublishObjects.Add(xlSourceSheet, _ C:\Page.mht", Sheet1", ", xlHtmlStatic, _ ProductSales_18739", My Web ) .Publish (False) .AutoRepublish = False End With End Sub

This procedure simply saves the active worksheet as a Web page. Remember that thorough testing should be included whenever a new Web page is created. Testing will alleviate end user problems before your page is published on the Web.

After the Web page has been saved, you are required to publish the page to the Web before you can share it with the world. The following steps review how to post your Web page on the Internet:

1 Click File, Save as Web Page to open the Save As Web Page dialog box. Select the Entire Workbook option. Then click the Publish button. The Publish as Web Page dialog box opens, as shown in Figure 25-2.

Figure 25-2. The Publish as a Web Page dialog box displays the options available before the save operation is complete. You can set up the location, file name, and other options from this dialog box.

2 Click the Browse button to select the location for the Web page to be stored. 3 If you have already set up a Web folder, navigate to the appropriate folder and skip forward to step 10; otherwise, follow these steps.