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
- On a new worksheet, type the following:
A1: Bill B1: Clinton
A2: George B2: Bush
A3: Ronald B3: Reagan
- Highlight the range from A1 to B3.
- On the File menu, click Save As HTML.
- In step 1 of the wizard, the range $A$1:$B$3 appears in the "Ranges
and charts to convert" box. Click Next.
- Accept the default settings in step 2 of the wizard, and click Next.
- Accept the default settings in step 3 of the wizard, and click Next.
- In step 4 of the wizard, enter C:\Nogrid.htm in the File Path box.
In Microsoft Excel versions 5.0 and 7.0
- On a new worksheet, type the following:
A1: Bill B1: Clinton
A2: George B2: Bush
A3: Ronald B3: Reagan
- Select the range from A1 to B3.
- On the Tools menu, click HTML Wizard.
- In step 1 of the wizard, the range $A$1:$B$3 appears. If it fails to
appear, type this range. Click Next.
- Accept the default settings in step 2 of the wizard, and then click
Next.
- Accept the default settings in step 3 of the wizard, and then click
Next.
- Accept the default settings in step 4 of the wizard, and then click
Next.
- 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.
- 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.
- On the View menu, click Source. The HTML formatting codes used to
generate the document appear in a Notepad window.
- Find the line that contains <Table border>. Change <Table border> to
<Table> by deleting the word "border" from within the angle brackets.
- On the File menu in Notepad, click Save.
- On the File menu in Notepad, click Exit.
- 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 <Table border> and delete <Table border>.
Find the line that contains </Table> and delete </Table>.
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.
- Follow steps 1 and 2 in the "Creating an HTML Document with Gridlines"
above.
- On the Edit menu, click Copy.
- Start Word. On the Edit menu, click Paste. The Excel data is pasted
into Word with the gridlines showing.
- On the Table menu, click Hide Gridlines.
- 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 :
|