MS Excel Internet Assistant Wizard: Removing Gridlines in HTML

ID: Q150004


The information in this article applies to:
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel for Windows, version 5.x
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Word 97 for Windows


SUMMARY

When you use the Internet Assistant for Microsoft Excel add-in, gridlines appear in the finished Hypertext Markup Language (HTML) document even if you set the option for the gridlines to not appear or print in Microsoft Excel. This article provides an example of how you can remove these gridlines from the HTML document.


MORE INFORMATION

The add-in discussed in this article is provided "as is" and Microsoft does not guarantee that it can be used in all situations. Although Microsoft support professionals can help with the installation and existing functionality of this add-in, they will not modify the add-in to provide new functionality.

NOTE: Before you can use the following example, you must install the add-in. Please download the file and see the Readme.txt file for the installation instructions.

The add-in discussed in this article can be obtained from the Microsoft TechNet compact disc and from Online Services.

NOTE: The Internet Assistant Wizard add-in ships with Microsoft Excel 97. If you are using Microsoft Excel 97, you do not need to download a copy of the add-in.

For additional information about downloading files from Online Services, please see the following article in the Microsoft Knowledge Base:

Q119591 : How to Obtain Microsoft Support Files from Online Services



Creating an HTML Document with Gridlines

In Microsoft Excel 97

  1. On a new worksheet, type the following:

    
       A1: Bill       B1: Clinton
       A2: George     B2: Bush
       A3: Ronald     B3: Reagan 


  2. Highlight the range from A1 to B3.


  3. On the File menu, click Save As HTML.


  4. In step 1 of the wizard, the range $A$1:$B$3 appears in the "Ranges and charts to convert" box. Click Next.


  5. Accept the default settings in step 2 of the wizard, and click Next.


  6. Accept the default settings in step 3 of the wizard, and click Next.


  7. In step 4 of the wizard, enter C:\Nogrid.htm in the File Path box.


In Microsoft Excel versions 5.0 and 7.0

  1. On a new worksheet, type the following:

    
          A1: Bill       B1: Clinton
          A2: George     B2: Bush
          A3: Ronald     B3: Reagan 


  2. Select the range from A1 to B3.


  3. On the Tools menu, click HTML Wizard.


  4. In step 1 of the wizard, the range $A$1:$B$3 appears. If it fails to appear, type this range. Click Next.


  5. Accept the default settings in step 2 of the wizard, and then click Next.


  6. Accept the default settings in step 3 of the wizard, and then click Next.


  7. Accept the default settings in step 4 of the wizard, and then click Next.


  8. In step 5 of the wizard, enter "C:\Nogrid.htm" (without the quotation marks) as the file path. Click Finish.


Using Internet Explorer to Remove Gridlines

NOTE: This example assumes you have followed the steps in the section "Creating an HTML Document with Gridlines" to create the file C:\Nogrid.htm. If you are using another file name with this example, substitute the path and name of your file for C:\Nogrid.htm.

  1. Start Microsoft Internet Explorer. On the File menu, click Open. In the Open box, type C:\Nogrid.htm and click OK.

    The data previously entered appears in a table with borders that resemble gridlines.


  2. On the View menu, click Source. The HTML formatting codes used to generate the document appear in a Notepad window.


  3. Find the line that contains <Table border>. Change <Table border> to <Table> by deleting the word "border" from within the angle brackets.


  4. On the File menu in Notepad, click Save.


  5. On the File menu in Notepad, click Exit.


  6. On the View menu of Internet Explorer, click Refresh. The Microsoft Excel data now appears in a table format, with no gridlines.


NOTE: To have the data appear as text, with the contents of each cell separated by a single space rather than formatted as part of a table, substitute the following step for step 3 in the "Using Internet Explorer to Remove Gridlines" section:


   Find the line that contains &lt;Table border&gt; and delete &lt;Table border&gt;.
   Find the line that contains &lt;/Table&gt; and delete &lt;/Table&gt;. 


For additional information, please see the following article in the Microsoft Knowledge Base:

Q147273 : XL: The Internet Assistant Wizard (html.xla)



Using Microsoft Word to Remove Gridlines

NOTE: This example will create an HTML document using Excel and Word. You must have Word 97 installed on your system in order to use this method.

  1. Follow steps 1 and 2 in the "Creating an HTML Document with Gridlines" above.


  2. On the Edit menu, click Copy.


  3. Start Word. On the Edit menu, click Paste. The Excel data is pasted into Word with the gridlines showing.


  4. On the Table menu, click Hide Gridlines.


  5. On the File menu, click Save As HTML. In the Save As HTML dialog box, click Save.


When you view the newly created HTML page in a Web browser, the gridlines will no longer appear.

Additional query words: 5.00a 5.00c 5.0 5.0c 97 borders addin IA

Keywords : kbualink97 xladdins
Version : WINDOWS:5.0,5.0c,7.0,7.0a,97; MACINTOSH:5.0,5.0a
Platform : MACINTOSH WINDOWS
Issue type :


Last Reviewed: June 1, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.