 |
| 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
|
|
|
|
November 24th, 2008, 10:12 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
|
|
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
|
|
November 24th, 2008, 10:48 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
|
|
<table border=1>
|
|
November 24th, 2008, 11:01 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
|
|
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
|
|
November 25th, 2008, 10:51 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
|
|
Oh...you mean the *FULL* grid...all letters, all numbers??
Hmmm...I dunno.
Hmmm...good one. Dunno if it's even possible.
|
|
November 25th, 2008, 11:13 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
|
|
Indeed thats what I was getting at. I have found nothing which indicates its possible.
Wind is your friend
Matt
www.elitemarquees.com.au
|
|
November 26th, 2008, 12:45 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
|
|
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?
|
|
December 28th, 2008, 03:01 AM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 198
Thanks: 2
Thanked 0 Times in 0 Posts
|
|
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.
|
|
December 28th, 2008, 05:43 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
|
|
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"????
|
|
May 31st, 2009, 05:56 PM
|
|
Authorized User
|
|
Join Date: Apr 2005
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Excel gridlines in ASP.NET
Quote:
Originally Posted by mat41
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/
|
|
|
