The code below (partial) should export a file as Excel when the button near the bottom is clicked. The example I pulled the concept from uses a GridView for binding. I don't need to display it, just export it, so I created ExcelGrid visible=false at the bottom. The Response.Write(strQuery); is never getting executed. I get:
Exception Details: System.Web.HttpException: Control 'ExcelGrid' of type 'GridView' must be placed inside a form tag with runat=server.
I'm almost positive (from what you see below) that my ExcelGrid is inside the form tag, which contains the runat=server.
Any ideas? It works when you pull that code and just run the rest of the form so the runat=server is working for all of the other controls! Code:
I have been able to successfully export data to Excel via ASP, however there is a small problem.When the file download window is displayed (to export to excel), you have have several options: open, save and cancel. Pressing the save button allows you to save a *.xls file to your HDD (THIS WORKS FINE). However, most users will push the open button. By doing so, the same screen will appear again with the same options: open, save and cancel. Pressing the open button again causes MS Excel to open (as expected) and then a dialog with the following message appears: "C:Documents and Settings<user name>Local SettingsTemporary Internet FilesContent.IE5BIOJDDG5<filename[1].xls> could not be found".
As most users will probably press the Open button, I want to find a solution to this problem.
I am trying to export a dynamically generated table to excel. I have used following code for the same
Response.ContentType ="application/vnd.ms-excel"
On some machines with excel 2000 version it is not working. The problem is that i have coded a session check for the user in that page and page is not getting the session value & it is redirecting the user to homepage for login in that excelsheet itself. That means instead of showing expected report ,excel sheet is showing contents of home page. I am not getting what is the connection of excel version with session.
I am trying to export a result set as an excel spread sheet. Most of the time this works as expected, when a user chooses to save as excel the browser pop-up a save as dialog to allow the user to save the spreadshet with a .xls name. Some times the browser will open up the file as text file within the bvrowser itself? These are my two lines of code to prompt the save as dialog for a Browser:
I am trying to export a recordset to an excel file using the Content Type below in the header.
Response.ContentType = "application/vnd.ms-excel"
Which works fine however the problem is that when I have a number in a column with a leading zero the zero gets dropped. E.G. 01760942 will be displayed as 1760942 . How can I rectify this?
Is this possible? I am planning to export data from SQL that generates HTML table. Instead of selecting the table and then copy then paste to excel, is ther a script(JS or VB) that will automatically export or open the Query to it.
1.) I've done this using macros in excel but I can't get the macros to run with the security of the xls file. I can't change the security, how can I make that particular macro safe?
2.) Now that I have macros running in excel, i'd like to know how to implement them into my asp page. I can't just copy and paste my macro b/c it wouldn't know what file it's looking for. I need help putting a macro on my page pointing at any given xls (dynamically as they will change)
3.) When running the macro in excel, i have problems with the output. Currently (until i get a better grasp on getting it running) i am using a macro from MSDN called quotecommaexport (which obviously makes a comma separated list of the data from excel) and the problem is when the xls shows ########## instead of the value b/c of lack of space.
It works when I span out the column and shows the value, the correct value is exported. Otherwise, it exports "#############" which does nothing for me. How can i get it to export the value without me physically spanning out the columns to give the value room. (I know this question may not make sense) Code:
I am writing a web-based information portal and one of the requested features is that some data be outputted not to the screen, but to an MS Excel file.
I could not find much information on this topic, but I'm sure there's a way. All the database searching is in place, the recordset has been built, I just need an interface to send data into Excel as opposed to a text file, or to the screen. Code:
I have a webpage that is taking input from a form and using it as criteria to select data out of an sql database. The page displays an html table with the results. The user can then click a button "excel" to open or save the file as an excel document. This works, and everything in the excel document is formatted fine except for the first column which in this case is "Part Number". The problem is that this part number: 883100105100 is displayed like this: 8.831E+11 in excel.
I am not sure how to format the excel cells using the asp/html so that it doesn't try to throw everything into scientific notation. I have thought that maybe if I gave excel a string value instead of a number value then it would fix the problem but I am pretty new to asp and am not sure how to do this. Below is the block that throws everything into excel in the first place. Code:
I am getting an error on a page that uses asp to query a db then opens the page on the client in excel. The error is only occuring on XP boxes only. If I comment out the cache killers it opens fine but I want to make sure a user gets the most up to date data so I need some cache control in there. What can I do to fix this? Code:
I 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.
I have an asp page that queries a db and displays the data in an html table. This page has a hyperlink that goes to another asp page that is meant to load the same data table in Excel. This all works fine on windows 2000. This app has been running now for close to a year.
On XP however I get an error message ststing that the Temporary file whatever.xls could not be found. Check the spelling and verify if the file location is correct. This has happened on all XP boxes. I can save the file and then open but users don't want that extra click.
The code in the asp file that is meant to spawn Excel looks like this: ...
I have created one dynamic chart creation application using vb dll. If I call this function from vb it is working fine. But If i call this function from ASP i got error while opening the excel file line. I have windows 2000 server. Do i need to give any permission for this? The same coding is working fine in NT server.
I have an ASP page that loops through a SQL Server 2000 table, then downloads an Excel sheet the users can save, etc. Works fine, except, I see that in one particular "comments" field the Excel sheet returns a #VALUE! error in the cell when there is a large amount of text. I've looked through the MSKB, MSDN and many ng posts to see if there is a workaround or solution to this, including looking at the xlWorksheet properties. Is there a limitation of 255 chars that can be tranferred? When I copy and paste the text it copies into the cell fine.
i can use Server.CreateObject("Scripting.FileSystemObject") successfully, why this excel.application cannot work?is there any other way to read data from an excel file?
I am using an ASP script on my site that reads a microsoft excel file and adds the values to the database (MS SQL Server). The script works completely fine on my LOCAL server, but it shows me the following error when I upload it to the server and try to run it.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1128 Thread 0x2268 DBC 0xd2d0fec Excel'.
Is there a way of exporting some asp generated text to various formats (doc,pdf,csv,xls etc.)? Idealy it should be preformated in order to print it directly (ex. labels).
I've got a code that takes SQL query and creates a downloadable csv file, and it works fine. But, there is data that is getting seperated by commas that I don't want to be seperated. Like "Last Name" that is "Drake, Dr.".
I tried creating a tab delimited file (which I did) but it opens all wacky if I leave it as a csv file, and if I change it to txt then the download box doesn't open. The end users could select all the text and create their own file, but these end users are in desperate need of as much assistance as possible. Here is the code I am using:Code:
I am using a SQL 2000 server and am trying to export results from a query to a text file. The code is working, expect my CONTACTNAME field has a comma, and my export is splitting that into 2 columns when I only want it to be one. Code:
I have a table that contains information that I need to export to a .csv file without manually saving the file, e.g click a button, information is passed and saved. I have no problem geting the information from the table, just exporting it into a .csv and then saving.
I have a site where orders are placed, i was just thinking of a good way for customers to keep track of there orders, at the moment they can page through there orders and and find it manually, I was thinking of putting a seach in also. Another one was to export all there orders in to an excel file, and one think thats any good?
the below code successfully queries the database for the record with the correct username and password, and then displays the users age and email from the database.
what i need
at the moment the asp returns the details in the form of a sentence on the browser. however, i shall be exporting the retreived details into flash, so rather then the current way, i would like to declare the fields i have just loaded as something i can export out to flash..such as Response.write (age=myage which will be the flash text box name) or something like that. Code:
