i have a excel download which works fine, but the format is incorrect if i need to re-upload the worksheet to the database via a file upload.
so i think the problem is that in the download i am using a table format with <tr><td> etc. how can i change these to just be cell entries?
I need to allow user to save dataset to their computer in Microsoft Money
format. I searched internet for help on this but found nothing helpful. I
also chatted with MS Online Concierge to no avail.
If you could, please provide pointers to steps how to accomplish this. If
you will provide the steps yourself, please be very explicit in what you
provide.
I am in need of allowing permissioned users of a particular web app using ASP to query a table and then allow them to download an excel formatted version of the data they can use offline.
View Replies View RelatedI am trying to download a table of data from an ASP page into Excel. The link opens Excel OK and creates a worksheet with the name of the ASP page, but no data is transferred.
If I remove (comment out) the Response.ContentType line from my code, then the table appears on the asp page.
<%Response.ContentType = "application/vnd.ms-excel"%>
which save my asp query to excel, but the TYPE of excel it saves as is WEB PAGE. is there a way to save as a excel workbook?
I'm using Response.ContentType = "application/vnd.ms-excel" to display my SQL filled table in Excel and all the data shows up, but the column formats are not correct. For example, Excel treats my column with data such as "01-80" as date "Jan/1/80" and I want it to stay as a string. How do I specify the column format as text inside my ASP code?
View Replies View RelatedI have written an ASP script that connects to a database and runs a stored procedure and displays the results in text format ...using the <TABLE> tag. But I would like to
have these results appear in a NEW Window in an Excel format. I used :
<%
Response.ContentType = "application/vnd.ms-excel"
Response.Buffer = true
Response.Clear
%>
This opens up Excel in the same window and usually does not refresh my data ...even though the stored procedure is actually running on the database server.
My program exported a excel file by using
Response.ContentType = "application/vnd.ms-excel";after downloading the same when i import it back to my system using Microsoft Excel driver, i got an error.
External table is not in the expected format. Do anyone know how to solve it?
I'm exportin a datagrid to excel, but Excel file is without format colors cells border...
Do you know how format it? Code:
I would like to inquire how would it be possible to use asp to check the format of the excel being uploaded? Like the first row in cloumn A is named Results, column B is named Example and so on.
I've already able to use asp to to extract the data from the excel and insert them into the access ab. Now I would like to know how to be able to check the format of the excel file being uploaded, if it is the way i want then it would proceed to insert the values into the access db, if not the user will be informed that the format of the excel file was not the standard one.
I would like to inquire how would it be possible to use asp to check the format of the excel being uploaded? Like the first row in cloumn A is named Results, column B is named Example and so on...
I've already able to use asp to to extract the data from the excel and insert them into the access ab.
Now I would like to know how to be able to check the format of the excel file being uploaded, if it is the way i want then it would proceed to insert the values into the access db, if not the user will be informed that the format of the excel file was not the standard one.
How can I use ASP to read data in an Excel file and than write it in the format of XML?
View Replies View RelatedI have 3 asp pages. The first page (login.asp) takes the parameter values(userid, groupid, locationid and deptid) based on the login (validate using a table). On submit the page params.asp is executed. Here the user has to select the filtering.
Then the page results.asp is executed. When the result is in excel format only the parameter value p_attdate (p_attdate is the value on page params.asp) contains a value.
The value of p_gid(p_gid is a session variable) remain null. BUT when the output is in html format, the parameter value p_gid return the correct value. I want the output to be in excel format but the sql statement is returning the wrong result. Only p_attdate is returning the correct value. I think because p_attdate is a form variable.
Can anyone tell me why value of p_gid is always null when the output is in excel format???
I am having trouble downloading an excel report generated from our AS
pages. We presumed it was something to do with the SSL certificate w
just installed, so loaded the ForceSSL.inc script from Microsoft an
changed the cache settings by changing this code in our globals.as
file:
Response.AddHeader "pragma","cache"
Response.AddHeader "cache-control","private"
Response.CacheControl = "private"
Now we are having trouble with downloading about ten of the twent
five reports that we have. Does anyone have any ideas?
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
Any suggestions on where to start?
if there any asp or vb functions that can convert any audio format files to vox format.
View Replies View Relatedhow to format date in MM/DD/YYYY format in ASP?
View Replies View RelatedI am trying to download files from one website to another for purposes
of caching. In trying to do this, I created a VB dll component (using
VB6), that used URLDownloadToFile, to allow me to download the file
onto the receiving site. The sending site supports an ASP page that
allows the file to be downloaded.The component works fine when run in debugging mode, placing the file as expected. But when not debugging (but registered), it reports that
the file has been downloaded, but the file is not there.
I am looking for some VB Script tutorials possibly as a pdf file that one can download and take print out of as one single file. I can see a lot of VB Script tutorials on the net but not offered as a single PDF file all in html format and explained on different pages.
View Replies View Relatedwhere I can download PWS Personal Web Server,or IIS from,ideally for as little cost as possible?I have XP Pro, but I've tried typing "inetmgr" in the Run field in Start Menu but it says it can't find inetmgr,and there is no IIS or PWS in my Program menus or submenus on my machine that I can see.
I had heard my XP Pro may have come with IIS but this doesn't seem to be the case with my pc. I have IIS on my server at work which has Windows 2000.Is it possible to copy an .exe install application of somekind which would be used to install IIS on another machine? What would the .exe file be called and where would it be located?
Is there a reference document for ASP (not ASP.NET) which can be downloaded? Perhaps an SDK? Where could I find this?
View Replies View RelatedI have created a script which connects to a SQL DB, runs a query, writes the results out to a file (Using FSO) then presents the user with a link to download the CSV. As the file contains sensitive data, I dont want to leave the file on the server, and I dont want to rely on the user to delete the file after every export.
View Replies View RelatedLooking for download asp script or java script for my zip files but without user know the location of the file/folder and can only log to this page from my authorized page.
View Replies View RelatedDoes any one know if there a ASP editor available that I can download as a trial version or free lisence?
View Replies View RelatedI have this javascript photo album i made. It is all working in tables and such. When you roll over a certain cell it will show that picture above, and turn the cell a different color. I also made the cell "clickable" when they are on it.
Is there anyway i can get it to when someone clicks that cell, that it will download that picture?? I have looked everywhere but i have not see anythign that will allow me to do that.
I'm using ADODB objects to download the images. Is there any way I can disable 'Save' option on a prompt. Also, when display the image (it could be any of the following files: .doc, xls, txt, pdf...), I need to disable 'Save' option or hide the toolbar.
View Replies View RelatedI don't know if this is possible, but does anybody know whether you can determine how long a file took to download. I want to be able to log how long a download took.
View Replies View RelatedMy problem is: i need to write an ASP page which first checks whether
the user has permissions to download a ZIP file, and then streams the
file itself if the user is allowed to see it.
I have succeeded until
this point, but the client browser asks to save the file with the
original filename (and ASP extension). Obviously this would mean
making the downloaded file unusable at client side, unless I tell the
site user to manually rename it, but this is not a solution.
So I ask you: is there any way for an ASP page to stream data to the
browser and have it saved with a default file name and extension which
are different from the page's ones? Code:
I'm having a problem with a script that makes the browser download a PDF instead of opening it.But when the file is downloaded, it downloads nothing.
The code is:
[vbs]
Set FSO = server.createobject("Scripting.FileSystemObject")
FileThere = FSO.FileExists(server.mapPath(request.querystring("f")))
If FileThere then
Response.AddHeader "Content-Disposition", "attachment;filename=" & request.querystring("f")
Response.ContentType = "application/pdf"
else
response.write("Sorry, file could not be found")
end if
Set FSO = nothing
[/vbs]
let me know and I'll pm you the address for it.
I need to show how long a given file size will download.
View Replies View RelatedWe have to provide a facility on the client machines to download the data
visible on a ASP page into an excel sheet. We are using WIN2k clients
connected to WIN2k server with IE6.0 installed.
The way we plan to implement it is that :
a) provide a right click and download to excel button from the ASP page
visible in IE.
b) on click of download make a server call passing the appropriate command
to send back the data in excel format.
My questions are :
Q1) Is there anyway to avoid the server call? I am not looking for OCX
either?
Q2) Are there any issues to do with memory leaks / deadlocks in case we use
such office automation to generate a report in excel? Is there a way around?
I have an example running at the moment that shares some 15,000 MP3 files however to offer these as downloadable i would be breaking the law i think !
I would like to set it up so that i have a method where the user can build a play list by going through the files and selecting them and then they would would be played either through the clients own system applications or through media components i can build into the site.
Maybe i could have some controls on there.
also why does the script not like to display files with the .ISO file extention ?
I want to make a support-page where people can download the latest help-files (these will be in a database) but I don't know how to do this (I only know the basics of ASP).
I don't mean that, for example a pdf, should open in another window. When you click on the filename it should give the standard downoad-box 'Open', 'Save', 'Cancel'.
Does anyone know how to do this? Or maybe there is some code on the net that explains it.