Creating Excel File with ASP

Question

I am creating an Excel file with classic ASP and everything works fine except for hyperlinks.

I use this to create the excel file:

Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment;filename=artigos.xls"

And this to create the hyperlink:

<a href="http://www.google.pt" >teste</a>

When I open the file in excel it appears as a link, but like this:

file:///c:\users\silvia\desktop%0d%0ahttp:\www.google.pt%0d%0a

How do you generate the excel? Is it just an HTML output?

Remy
– Remy

2013-08-30 11:48:58 +00:00
Commented Aug 30, 2013 at 11:48 — Remy
– Remy, Commented Aug 30, 2013 at 11:48
yes. It is a normal table.

Silvia Gaspar
– Silvia Gaspar

2013-08-30 12:15:15 +00:00
Commented Aug 30, 2013 at 12:15 — Silvia Gaspar
– Silvia Gaspar, Commented Aug 30, 2013 at 12:15

Richard Morgan · Accepted Answer · 2013-08-30 13:56:36Z

0

Verify that the hyperlink base property of the workbook is empty. If it's Excel 2003, look under File -> Properties -> Summary. If it's Excel 2010, look under File -> Information -> Document Properties -> Advanced.

The hyperlink base property is known to mangle hyperlinks.

Edit:

Another thing to try is use the HYPERLINK function. Explicitly tell Excel, the text in the cell is a hyperlink and include the http:// :

=HYPERLINK("http://www.google.pt")

edited Aug 30, 2013 at 13:56

answered Aug 30, 2013 at 11:46

Richard Morgan

7,6799 gold badges51 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Silvia Gaspar Over a year ago

And in 2013? Where do I change this option?

Silvia Gaspar Over a year ago

I have found where I change this option, but doens not solve my problema... When I do the edit link it appears like this....%0d%0a%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20http:\www.google.pt%0d%0a...If I remove the strange caracteres it works

Richard Morgan Over a year ago

Looks like the value has a carriage return and a lot of spaces now. Let me update the answer trying to use the Hyperlink function.

Silvia Gaspar Over a year ago

thank you very much. The Hyperlink function worked. But know I´m with a encoding problem, because of the url. Our português caracters desapear...Do you have any ideia why?

Silvia Gaspar Over a year ago

I found that if I put =HYPERLINK("google.pt") it works fine... If I put =HYPERLINK("google.com";title) where title is "EY promove conferência IRC: Perspectivas Futuras" it appears ok. If I put =HYPERLINK("google.com/";title) it appears like this: =HYPERLINK("gmail.google.com/fff";"EY promove conferÃªncia IRC: Perspectivas Futuras")

Remy · Accepted Answer · 2013-08-30 16:06:28Z

0

If you are willing to put a little more work into it, you could use the Open XML API from Microsoft. With it you can create native Excel xlsx files. And also use all possible Excel features that you want.

edited Aug 30, 2013 at 16:06

answered Aug 30, 2013 at 11:48

Remy

12.8k14 gold badges66 silver badges106 bronze badges

1 Comment

Remy Over a year ago

What .Net Version are you using? But basically I don't see a reason why not?

Collectives™ on Stack Overflow

Creating Excel File with ASP

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related