I am new to ASP so please pardon me if this is crazy.
I have data that I want to allow the user to be able to save in a format
that will then enable the user to open the data in Excel. (I have already
read the previous CSV posts and still have a question.)
I have an ASP page that takes some data from a previous page,adds some
column headings and displays it all in apparent CSV format.
All I am trying to do is allow the users to do a Save As (for a text or CSV
file) and open it (in Excel) with the proper columns. Somehow, although all
appears OK on the screen, when saving the file, line feeds seem to be added
and all the rows get messed up. If I simply select all the text on the ASP
page and copy it to WordPad, save it, and open it in Excel - all works fine.
Obviously there is some formatting I am overlooking.
Any suggestions would be helpful! (The page can be viewed at http://primefreight.ca/database1_int...ck_company.asp and
search on TEST COMPANY as the company, press Track and then the Export
button.)
I am baffled and feel I am so close... but getting frustrated.
Thanks for any input!
Aliza
--
-----------------------------------
Aliza Klein ab*****@optonline.net
----------------------------------- 4 3464
Aliza Klein wrote: I am new to ASP so please pardon me if this is crazy.
I have data that I want to allow the user to be able to save in a format that will then enable the user to open the data in Excel. (I have already read the previous CSV posts and still have a question.)
I have an ASP page that takes some data from a previous page,adds some column headings and displays it all in apparent CSV format.
All I am trying to do is allow the users to do a Save As (for a text or CSV file) and open it (in Excel) with the proper columns. Somehow, although all appears OK on the screen, when saving the file, line feeds seem to be added and all the rows get messed up. If I simply select all the text on the ASP page and copy it to WordPad, save it, and open it in Excel - all works fine. Obviously there is some formatting I am overlooking.
Any suggestions would be helpful! (The page can be viewed at http://primefreight.ca/database1_int...ck_company.asp and search on TEST COMPANY as the company, press Track and then the Export button.)
While the code used to generate these results would be helpful, I do notice
that the header of the exported page contains this:
content="text/plain"
You would probably be better off setting the content type to
"application/vnd.ms-excel":
Response.ContentType = "application/vnd.ms-excel"
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Thanks for the tip. I didn't know I could do that. Unfortunately, the
problem still remains. The code follows (as does the explanation):
<%
tmp = ""
response.contenttype = "application/vnd.ms-excel"
response.write "Container #,Vessel Name,Company Name,House Bill of Lading
#,Shipper,Country,Cargo Control #,ETD Origin,ETA (Halifax/Vancouver),ETA
(Montreal),Revised ETA,Current Location of Cargo,Delivery Status,Customs
Clearance Status,OBL Required,Number of Cartons,Weight (kg),Cubic Meters
(CBM),PO #,PO # (2),Comments #1,Comments #2,Comments #3,Comments #4,Comments
#5,Reference #" & "<BR>"
For each item in Request.form
For icount = 1 to Request.Form(Item).Count
if Item = "export_stuff" then
tmp = tmp & Request.form(item)(icount)
tmp = ConvertString(tmp)
response.write "'" & tmp & "'" & vbCrLF
end if
next
next
%>
<% function ConvertString(strMy)
dim strRetVal
strRetVal = strMy
strRetVal = replace(strRetVal, "!!!","','", 1, -1, 1)
ConvertString = strRetVal
end function
%>
Explanation: Basically, I write a comma delimited string to the screen and
then a string (that I first convert - long story) that containes all the
text that I want that is passed from the previous page. The reason I did it
this way is that I often return more than one record and when I did it field
by field, the data was grouped together (ie: both record's data under 1
field). I hope this makes sense to you.
And thanks!
Aliza
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:%2******************@TK2MSFTNGP10.phx.gbl... Aliza Klein wrote: I am new to ASP so please pardon me if this is crazy.
I have data that I want to allow the user to be able to save in a format that will then enable the user to open the data in Excel. (I have already read the previous CSV posts and still have a question.)
I have an ASP page that takes some data from a previous page,adds some column headings and displays it all in apparent CSV format.
All I am trying to do is allow the users to do a Save As (for a text or CSV file) and open it (in Excel) with the proper columns. Somehow, although all appears OK on the screen, when saving the file, line feeds seem to be added and all the rows get messed up. If I simply select all the text on the ASP page and copy it to WordPad, save it, and open it in Excel - all works fine. Obviously there is some formatting I am overlooking.
Any suggestions would be helpful! (The page can be viewed at http://primefreight.ca/database1_int...ck_company.asp and search on TEST COMPANY as the company, press Track and then the Export button.) While the code used to generate these results would be helpful, I do
notice that the header of the exported page contains this: content="text/plain" You would probably be better off setting the content type to "application/vnd.ms-excel": Response.ContentType = "application/vnd.ms-excel"
Bob Barrows
-- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
Aliza Klein wrote: Thanks for the tip. I didn't know I could do that. Unfortunately, the problem still remains. The code follows (as does the explanation):
<% tmp = "" response.contenttype = "application/vnd.ms-excel" response.write "Container #,Vessel Name,Company Name,House Bill of Lading #,Shipper,Country,Cargo Control #,ETD Origin,ETA (Halifax/Vancouver),ETA (Montreal),Revised ETA,Current Location of Cargo,Delivery Status,Customs Clearance Status,OBL Required,Number of Cartons,Weight (kg),Cubic Meters (CBM),PO #,PO # (2),Comments #1,Comments #2,Comments #3,Comments #4,Comments #5,Reference #" & "<BR>" For each item in Request.form For icount = 1 to Request.Form(Item).Count if Item = "export_stuff" then tmp = tmp & Request.form(item)(icount) tmp = ConvertString(tmp) response.write "'" & tmp & "'" & vbCrLF end if next
next
%>
<% function ConvertString(strMy) dim strRetVal strRetVal = strMy strRetVal = replace(strRetVal, "!!!","','", 1, -1, 1) ConvertString = strRetVal end function %>
Explanation: Basically, I write a comma delimited string to the screen and then a string (that I first convert - long story) that containes all the text that I want that is passed from the previous page. The reason I did it this way is that I often return more than one record and when I did it field by field, the data was grouped together (ie: both record's data under 1 field). I hope this makes sense to you.
And thanks! Aliza
You need to but the data into a table. This works for me:
<%
Response.Buffer=true
Response.ContentType = "application/vnd.ms-excel"
tmp = "Container #,Vessel Name,Company Name," & _
"House Bill of Lading#,Shipper,Country,Cargo Control #," & _
"ETD Origin,ETA (Halifax/Vancouver),ETA(Montreal),Revised ETA," & _
"Current Location of Cargo,Delivery Status," & _
"Customs Clearance Status,OBL Required,Number of Cartons," & _
"Weight (kg),Cubic Meters(CBM),PO #,PO # (2),Comments #1," & _
"Comments #2,Comments #3,Comments #4,Comments #5,Reference #"
Response.Write "<table><tr><td>"
response.write replace(tmp,",","</td><td>")
Response.Write "</td></tr></table>"
%>
HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Thanks so much! That set me on the right path!
I am up and running....
Aliza
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:Oy**************@TK2MSFTNGP10.phx.gbl... Aliza Klein wrote: Thanks for the tip. I didn't know I could do that. Unfortunately, the problem still remains. The code follows (as does the explanation):
<% tmp = "" response.contenttype = "application/vnd.ms-excel" response.write "Container #,Vessel Name,Company Name,House Bill of Lading #,Shipper,Country,Cargo Control #,ETD Origin,ETA (Halifax/Vancouver),ETA (Montreal),Revised ETA,Current Location of Cargo,Delivery Status,Customs Clearance Status,OBL Required,Number of Cartons,Weight (kg),Cubic Meters (CBM),PO #,PO # (2),Comments #1,Comments #2,Comments #3,Comments #4,Comments #5,Reference #" & "<BR>" For each item in Request.form For icount = 1 to Request.Form(Item).Count if Item = "export_stuff" then tmp = tmp & Request.form(item)(icount) tmp = ConvertString(tmp) response.write "'" & tmp & "'" & vbCrLF end if next
next
%>
<% function ConvertString(strMy) dim strRetVal strRetVal = strMy strRetVal = replace(strRetVal, "!!!","','", 1, -1, 1) ConvertString = strRetVal end function %>
Explanation: Basically, I write a comma delimited string to the screen and then a string (that I first convert - long story) that containes all the text that I want that is passed from the previous page. The reason I did it this way is that I often return more than one record and when I did it field by field, the data was grouped together (ie: both record's data under 1 field). I hope this makes sense to you.
And thanks! Aliza
You need to but the data into a table. This works for me:
<% Response.Buffer=true Response.ContentType = "application/vnd.ms-excel" tmp = "Container #,Vessel Name,Company Name," & _ "House Bill of Lading#,Shipper,Country,Cargo Control #," & _ "ETD Origin,ETA (Halifax/Vancouver),ETA(Montreal),Revised ETA," & _ "Current Location of Cargo,Delivery Status," & _ "Customs Clearance Status,OBL Required,Number of Cartons," & _ "Weight (kg),Cubic Meters(CBM),PO #,PO # (2),Comments #1," & _ "Comments #2,Comments #3,Comments #4,Comments #5,Reference #" Response.Write "<table><tr><td>" response.write replace(tmp,",","</td><td>") Response.Write "</td></tr></table>" %>
HTH, Bob Barrows
-- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Andras Gilicz |
last post by:
Hi VB fans
I'm working on a relatively large project in VB6 with about a dozen
forms, including graphs, labels, text boxes, etc. The software itself
is actually a flow simulator with more or...
|
by: Ivan Demkovitch |
last post by:
Hi!
I would like to know if I can save File on Server using server-side code?
For example, I like to create thumbnail images and populate specific
directory.
Do I need specific permissions...
|
by: Shanli RICHEZ |
last post by:
I'm using ASP.NET and quite a lot of object in memory instead of a database.
The question is that I tried to save the data, serialize them in a XML file
to save them when the application is...
|
by: B-Dog |
last post by:
I'm checking some files to see if the filenames are in a certain format and
if not I want to pull up a dialog box that gives me a save as with the file
that is in question. I have all the files in...
|
by: Peter Proost |
last post by:
Hi group when save a bitmap called saveBmp like this:
<<<<
saveBmp.Save(filename, ImageFormat.Jpeg)
<<<<
the bitmap gets saved with it's size propertys, so if I right click the file
and...
|
by: zheng |
last post by:
ÇçÌì
I have a word document and it has a picture object, I want save the picture
object as other single picture file by C# program. I have a idea, by
clipboard, copy the picture to clipboard, and...
|
by: C Watson |
last post by:
Hi,
I'm wondering if anyone can help me with AJAX in ASP.NET 1.1. I have a very
specific feature that I would like to use it for.
I have a rather long form that the users use to enter data...
|
by: fiefie.niles |
last post by:
I would like to save a web page to a file and have the hyperlinks work
when I bring the file back up. If the web page has a hyperlink like the
following
<a href="OurWeb/News/abcFile.htm">, after...
|
by: =?Utf-8?B?RnJlZU5FYXN5?= |
last post by:
Hello,
the scenario:
There's an ASPX page which shows some text and has three buttons at the
bottom: Save, Print and Close. Print and close is done by javascript. But how
can I save the page...
|
by: Koliber (js) |
last post by:
sorry for my bad english
when I fire up (from my c# code) a standard "file - save as "
dialog, and when chosen location is a shered local network
directory, where I do have rights to create...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |