Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 24th, 2008, 10:12 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default ASP to Excel BUT show Excel grid lines

Good day

Does any body know how to make the Excel grid lines appear when sending the contents of an ASP file to a .xls file?

I am using Excel 2003 and are sending the information by inserting the following line:

Response.ContentType = "application/vnd.ms-excel"

TYIA

Wind is your friend
Matt
www.elitemarquees.com.au
__________________
Wind is your friend
Matt
 
Old November 24th, 2008, 10:48 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

<table border=1>
 
Old November 24th, 2008, 11:01 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

I tried this and of course it does place a regular table border around the HTML table(s). I was trying to get the dafult grid to appear as it would when you normally open Excel

Wind is your friend
Matt
www.elitemarquees.com.au
 
Old November 25th, 2008, 10:51 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Oh...you mean the *FULL* grid...all letters, all numbers??

Hmmm...I dunno.

Hmmm...good one. Dunno if it's even possible.
 
Old November 25th, 2008, 11:13 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

Indeed thats what I was getting at. I have found nothing which indicates its possible.

Wind is your friend
Matt
www.elitemarquees.com.au
 
Old November 26th, 2008, 12:45 AM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

You could, of course, "cheat" and produce a grid with mostly empty cells, so that at least it looks like you have a full grid.

Ugly. But maybe usable?
 
Old December 28th, 2008, 03:01 AM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 198
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via MSN to itHighway
Default

Set the border=1 and border color to #CCCCCC.

Besides that, instead of excel file create a CSV file. This will resolve your empty column problem.
 
Old December 28th, 2008, 05:43 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

I don't get it.

If it's a CSV file than how does the border enter into it???

CSV files don't *have* borders because they don't have <TABLE>s.

Or are you saying to go ahead and produce a <TABLE Border=1> but then just *NAME* the file as ".csv"????
 
Old May 31st, 2009, 05:56 PM
Authorized User
 
Join Date: Apr 2005
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel gridlines in ASP.NET

Quote:
Originally Posted by mat41 View Post
Good day

Does any body know how to make the Excel grid lines appear when sending the contents of an ASP file to a .xls file?

I am using Excel 2003 and are sending the information by inserting the following line:

Response.ContentType = "application/vnd.ms-excel"

TYIA

Wind is your friend
Matt
www.elitemarquees.com.au

Check here: http://www.sandboxm.com/excel-and-aspnet/





Similar Threads
Thread Thread Starter Forum Replies Last Post
Read Excel Lines VBA gbvdh VB How-To 0 February 26th, 2007 08:44 AM
Exporting more that 65536 lines to excel martinrhague Access 3 January 5th, 2007 11:11 AM
ASP to Excel - excel output formatting issue mat41 Classic ASP Professional 0 August 13th, 2006 06:41 AM
Increase row height in Excel and multiple lines in jmss66 VB How-To 4 June 23rd, 2006 05:45 AM
Save grid in Excel jkalinina C# 1 September 12th, 2003 02:22 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.