i am using the following code to generate a xls file using the content type now when the user opnes the file at his pc it takes long time to open..if the no of records in file is large does the use of html tags has slow down the process of opening in excel. Code:
View RepliesAt work we have to real-time generate a report(excel format) which involves a number of table joining. So to export into excel contentType 'application/vnd.ms-excel' is used, and data are written as table, looping each row of recordset data as table row.
Problem is when user hit export and attempt to open/save the file, file would then be downloaded at constant rate. But during this time, entire server would be irresponsive and in a hang-like state, this is expereinced by all users.
When they attmept to visit another asp page they would wait until the page eventually timeout. This will continues until the report was completely generated and downloaded by users.
I am currently developing a download centre for a hardware manufacturer which has alot of firmware and other software available to it's clients. Most of these are less than 10mb and with their internet connection I'm thinking a browser upload through the admin tools will be fine. However there are files on the current site of up to 100mb, how would be best to handle uploading these?
I was thinking maybe an ftp component would handle bigger files better than an normal http upload? Does anyone know of any components that allow some kind of background uploading so they can continue to use the admin for other tasks while this continues?
Or just any other suggestions full stop! Maybe I would need to come up with some way of taking them out of the system and loading a windows ftp with the correct directories etc.. predefined?
I hope we can upload only files with limited size through ASP scripts(<2MB). I need to write an ASP script that can serve up to 100MB of file uploading. I have written one script(with progress bar ;-)), as my hosting won't allow me any third party upload components. Is there any way we for ASP scripts to make larger file uploads?
View Replies View RelatedI'm using Microsoft's ASPFileUpload routines and all works fine as long as my files are smaller than about 200K. For anything larger than about 210K, I get the following error:
Error Type:
Request object, ASP 0104 (0x80004005)
Operation not Allowed
On the .Upload method. Has anyone else experienced this problem with
ASPFileUpload?
I have code that uploads files in asp. It seems to be working however on files > 200kb it bombs and i don't know why. Does anyone have any idea of why this would occur and what i can do to fix it?
View Replies View RelatedI am trying to use ServerXMLHTTP in an ASP page to return a binary file download to the browser. It works just fine with small files ( under 1 MB) but seems to fail with large files (4 MB, 11 MB in tests). A success would be that the browser kicks off the "Save As" file dialog. The failures are not always the same. Sometimes the browser tries to download the ASP file itself. Sometimes the the file seems to download successfully, but for example only 1.6 MB of a 4 MB file are actually downloaded and it doesn't seem to be a simple truncation. Sometimes I get "internal server error 500". Below is my ASP code. "Project1.exe" is small enough to be successful. If you substitute "OmniViewProSetup.exe" (4 MBs) it will fail.....
View Replies View RelatedWhen I try to open an Excel file from ASP thro' HREF it works fine. But i give the same file in Response.Redirect it says "page cannot be displayed" even when the file exists. Is this related to server configuration?
View Replies View Relatedi have a radio button when a user clicks it i want to open up a excel sheet
and want to display the records from the table
i want to only display specific fields from the table not all fields
Can someone tell me how it can be done in asp 3.0
I have a website set up that can pull data from Access database tables and display them on the webpage depending on users' selection. Is it possible to have ASP open up Microsoft Excel and dump the data into it, plot graphs, calculate averages, etc.?
View Replies View RelatedHow can I open Excel file in a browser which is in the webserver. And How do i Restrict a user from downloading it in the local hard disk.
That means he cant copy the contents of the cell nor he can save the file by the option File>Save As.
Can anyone help with this? Here is the code I am using. The problem
is, where it checks if a file exists, it always goes to else. Even if
the file is there, it won't open the file, goes straight to else part
of statement.
<%
If Session("strLogID") = "" Then
Response.Redirect("http://website/pages/login.asp")
Else
strfile = Request.Form("month") & Request.Form("day") & " Misses" &
".xls"
Set fs = Server.CreateObject("Scripting.FileSystemObject")
If fs.FileExists("http://website/webreports/Misses/" & strfile) THEN
Response.Redirect("http://website/webreports/Misses/" & strfile)
Else
Response.Redirect("http://website/pages/missedreport.asp")
End If
End If
%>
I am creating a webpage and have a form where a visitor will choose a
day, month, and year. I want to pass the data from the form into an
asp page which will process it and put it into a string and open the
excel file requested. The excel file to open will depend on the day,
month, and year chosen in the form.
Is there a way to insure the user can't save the excel file that has been opened?
I have a link that goes to XLS files for users but I don't want to users to be able to save the XLS files to there local drive.
is it possible to open word or excel from an asp page in the client side having word or excel installed only on the server side?if possible, can u post an example ?
View Replies View RelatedExcel open automatically without giving a dialog box option to
Open/Save/Cancel using filesys.createTextFile.
How to pop up the dialog box option to Open/Save/Cancel?
I have a databse in MS Excel which I would like to use it in ASP? I know in MS Acces the provider parameter is as follow:
Provider=Microsoft.Jet.OLEDB.4.0
What is the equivalent of this provider to open Excel file? Or is there any other way that I should do, inorder to open the Excel files?
i would like to know how to open a new excel file and add tabular data in excel file from asp.
View Replies View RelatedI try to open mht file generated by ASP use the
Content-Type = "application/msword".
When the browser show de "dowload dialog" and I click in the Save button the file open perfectly, but if I try to click in the Open button, the browser show the "downloading dialog" and stay perpetual trying to open the file.My problem is, I cant save the file in the local machine, I need the Open only in memory.
I have some .msg file on my website and the when users click on the link they are able to open this file in Outlook Exchange. I had no problem running it on IIS 5. But with IIS 6 I am not able to open .msg file. Just saying that file is not found. I am able to open some other files such as .doc and .xls that are in the same directory.
View Replies View Relatedi'm trying to have excel open up a webpage which basically contains a
table.
in excel 2000 if i specify content type text/csv this works by
displaying an open/save dialog box and clicking open, launches excel
and displays data as a table (desired result ) however in machines with
excel 2002+ excel simply displays the html code.
trying to specify application/excel opens an excel plug-in inside the
browser which poses a problem becouse the excel has links to pdf file
that obscure the plug-in.
I have the following code at the top of my page. Is there a way to force Excel to open the spreadsheet? Presently, it opens within the browser window. I know it can be saved etc., but I would rather have Excel receive the data.
<% Response.contenttype = "application/vnd.ms-excel" %>
<% Response.AddHeader "Content-Disposition", "filename=" &
Request.Form("FileName") & ".xls" %>
I have an asp page that can be saved as an excel spreadsheet using:
<%Response.ContentType = "application/vnd.ms-excel"%>
How can I send the information to a specific spread sheet on the client's
computer?
I am trying do do this when a mouse is over a link (as the image attached), so a popup comes and show the database results, like i have done using Degsy solution.
I have a page (nw.asp) and it queries the db information. if is possible to call this .asp page in the div, I can use the 'a href' like this: Code:
<a href="nw.asp?id=<%=rs("id") %>">.
So this way will be possible to mouseover others links in this page, and as it is asking for id, will bring all the right values o.
I am trying to grab more information around this solution and any light will be so kinda.
My system hung and had to hard reboot. however now when I try to open interdev or a file with interdev I get the following error.
could not find the file c:path make sure the path and filename are correct and that all required libraries are available. It also says its creating an error log. Where is this log? I go to Event viewer and there is nothing in any of the logs and I cant find any kind of log under the InterDev dir.
I have re-installed interdev, re-installed the whole of visual studio and service pack 5 but keep getting this error. Maybe if I could see what was causing the error in this log I could work out whats wrong. I can open my asp files in other text editors but nothing in InterDev. has anyone got any experience of debugging InterDev or know where this error log is?
some users on our network are having difficulty opening Powerpoint
files via the Web. I've read the article "In-Place Activation Using Internet
Explorer 5 Does Not Work for PowerPoint Slides" at this location:
http://support.microsoft.com/defaul...B;EN-US;q290180. However,
following the guidelines of the article has not resolved the issue. Our
users have Windows 2K, XP Pro, Internet Explorer 5.5 and 6.0.
I want to read word files from asp and then store the read data into a variable. How can this be done ? I have no idea on opening files from MS Word.
View Replies View RelatedI am using ASP to open a excel file.
I've noticed that Internet Explorer adds a number in square brackets to files downloaded from the internet and opened directly (i.e. by clicking 'Open' and not 'Save'). This creates a big problem with downloading Excel spreadsheets as square brackets are not a valid filename character inside Excel worksheet name.
When I click open, it opens the excel sheet with the sheet name
as .xls[Sheet and the excel filename as Sheet[1].xls.
Then we get the following error....
While renaming a sheet or chart, you entered an invalid name. Try one of
the following:
- Make sure the name you entered does not exceed 31 characters.
- Make sure the name does not contain any of the following characters:
: / ? * [ or ]
- Make sure you did not leave the name blank.
I want to provide a function using asp for the users to search for their excel files in their PCs in IE and then upload to my database.
View Replies View RelatedI'm not very well-versed on developing on NT machines and IIS, but here goes..
I have a script that opens up an odbc connection to a Microsoft Access file (.mdb). This is file, but after I run it, Windows (or something) keeps the mdb file open and I can't reupload it for like, 20 minutes until it finally decides to close it.
I know it's not an asp problem because I've seen this before with Cold Fusion. I also know that it's not isolated to .mdb files because it does the same with a .txt file.
Any ideas? I do have access to the server, so if it requires any configuration changes.
I want to place a Excel workbook on the web server and create a URL
link to it and when the user clicks on it to the URL/vbscript behind
it must launch Excel on the client and open the URL linked Excel
workbook automatically.
Can you please share the code HTMl & VB script snippet that can do
this.
how to output a pdf file using asp. I know it can be done.
View Replies View RelatedI have a report created in ASP (not ASP.NET) that uses Response.ContentType="application/vnd.ms-excel" to display the results of a query from SQL Server 2003 formatted as an html table using Excel in Internet Explorer (version 6.0.2800).
The report displayed fine when my PC had Excel 97 installed. My PC was recently upgraded to Office 2003 and now the report only displays the report header. Does anyone know of a change I can make to the ASP code to display the rest of the report in Excel 2003?