Code:
<% for i = asc("A") to asc("O")
If voicetype(chr(i)) <> "" Then
response.Write yaketyRecordset("voicetype(chr(i))" & "<br />")
End If
next %>
Hennie JvN
Last Activity: Sep 26 '11, 08:39 PM
Joined: Oct 9 '10
Location: Pretoria, Gauteng, South Africa
-
Cant you use a regular if statement:
-
Hey, I found my answer and thought I'd post it. The idea is to create a spreadsheet from ASP and ADO information. If you open a spreadsheet saved as a web page (in notepad) you will see that it is basically an xml page combined with an html page. NOW what I did was, I created the columns that I needed and formatted it accordingly. I then saved the spreadsheet as a web page, and opened it with notepad. The styles created by excel explained everything....Leave a comment:
-
The problem is that I will need to convert the file to CSV and the database that I need to import it in to, will not allow any other characters. But Thanx for trying to help. I'll try to explore asp.net, I might find something that will help. HLeave a comment:
-
I have tried that, seeing that one would usually get a hidden apostrophe in excel. But if I do that the number appears like this '0 instead of just 0. I was actually more tending to use the mso-number-format
Code:{mso-number-format:General; text-align:general;white-space: nowrap; mso-spacerun: yes;}Leave a comment:
-
How to export to excel from ASP?
Hi, I need some assistance with exporting to excel from asp. I have seen your responses on the formating of columns when exporting, but I need an example.
The code I'm using:
...Code:Function GenHtmlTable() set conn=Server.CreateObject("ADODB.Connection") conn.provider="Microsoft.Jet.OLEDB.4.0;" conn.open server.mappath(MyDB.mdb") set rs=Server.CreateObject("ADODB.recordset")
No activity results to display
Leave a comment: