Using ASP To Generate Excel From SQL Data
I am using a SQL database, and Classic ASP and trying to generate an Excel file with my results, but the table is displaying as HTML in the browser instead of prompting the user to download/open the file. below is my code (edited data table for length). Anyone know why I am not being prompted, but shown the data via the webpage?
View Replies
ADVERTISEMENT
I want to create an Excel object from an ASP page. Basically, the input parameters to the Excel would be from the ASP. I know ASP and I know VBA, but I haven't used both of them together. Here's what I would like to do -
The ASP should generate an Excel report by passing 2 parameters to the Excel application (I have done this independently; without interfacing with ASP).
I know that I can create an excel handle from the ASP as -
Set MyExcel = Server.CreateObject("Excel.Application")
I dont know where the VBA code has to go? DO I have to include it in the ASP?
View Replies
View Related
I am using the code below to create an excel document from data that is returned from an sql query. The formatting of the excel document is pretty and all is good unless I hit the back button and run my query a second time, or a third time (I haven't made it past 3
times). Basically what happens is every time I do this, excel does not close once I hit my back button. Does anyone have a solution to this problem? Another problem is that when I run the query it just opens excel within my browser, is there any way to make it ask if you want to save or open the file?
I basically throw this code at the top of the html doc: .....
View Replies
View Related
With response.contenttype = "application/vnd.ms-excel", I can easily export my data to Excel which is embeded and shown within a browser. If I'm going to save the Excel file through ASP programming, which method can I use? I need to save the data to Excel file with dynamic name (the file name should contain key values and appended with system datetime).
View Replies
View Related
I am exporting data from a web application to Excel to allow users to manipulate their data. I can open up the data in Excel. If the user wants to view information about 3 separate clients, how can I put that information on 3 separate worksheets.
I can display the 3 clients on one worksheet, but I need it to be on 3 separate worksheets.
View Replies
View Related
I have a new approach to saving charts from server-side Excel when ASP pages are processed. The charts show weather data that is updated every 15 minutes in a database, and instead of just automating the chart production so that every chart is generated every 15 minutes, 24 hrs/day, it seems smarter to generate up to date charts when people want to look at them. But I'm not sure if this is the best approach.
This is what I can do from an ASP page to dynamically chart data:
- run Excel on the server
- open a Worksheet that has a customized chart for a range of cells.
- insert new data in the charted range of cells (chart auto-updates).
- save the chart to a gif file.
- insert the gif into the html page viewed by the client.
Using this approach is convenient because I can customize charts to look exactly as I want without having to find the documentation to automate the chart formatting.
Is it possible to run Excel once on the server, and let all requests for charts use this one running instance of Excel? The alternative is that Excel will run once for each chart request, this seems like it could get out of hand pretty quickly if a lot of people are trying to look at charts at the same time.
Are there better ways to generate charts dynamically on the server?
View Replies
View Related
I need to be able to generate an invoice from an ASP page. Currently, the invoice is drawn in a web page and my client prints the page from their browser. This doesn't work too well in terms of graphics resolution and also requires endless positioning tweaking on my part.
Is there a way to use Word or Excel on the client, and send the invoice data down so that some sort of invoice template could be used? This needs to work on a Mac and ideally on a PC as well. The client machines have Office installed. I'm thinking this would be the best way to eliminate the positioning and resolution problems.
View Replies
View Related
Is it possible to use ASP +/ VBScript to automatically fill in certain fields of an HTML form with data generated from what the user typed in another field?
For example, the user needs to input 24 consecutive weeks worth of forecast data. If everything is done manually, they'll have to type in a date for each of the week. I would like the form to automatically fill in the following 23 dates (each one week later than the previous field) after the user fill in the first week's date. How do I do that?
View Replies
View Related
Is it possible to write out the contents of a database into an exel-type
spreadsheet within an asp page?
View Replies
View Related
I'm trying to use Activer Server Pages (ASP) to get Data from SQL database to Excel. Do you need to have any ActiveX installed to achieve this and has anyone has experience in doing this?
View Replies
View Related
is there anyway to extract the data out of an asp table and write it into a seperate database that can be read by access or excel?
View Replies
View Related
I have two questions on exporting data to Excel using ASP (w/o converting
formatted excel file into web page and then plug in the dynamic data):
1. Can we export data into different sheets at Excel?
2. Can we do graph at export?
View Replies
View Related
I know the basic way of doing this when you have a static set of
spreadsheets but I need to be able to process different spreadsheets
every day. These spreadsheets are sent to us by an outside auditing
firm without named ranges. They have a consistent format. Is there a
way to read a specific set of cells without having a named range? Or
is there a way to name a range with ASP? I am open to any options
here. Going through and creating named ranges is the only thing that
wont work sicnce it would take more work than processing the files by
hand.
View Replies
View Related
Need your help in uploading excel data to a table in oracle db.We cannot install any server component so pls give some suggestions.
View Replies
View Related
I currently have an excel flat database, it contains a computerName and it has a list of parts associated with it next to the cell value of computerName.There values that are offsetted to the right are the parts associated with the computer name. I was wondering through ASP could i have a dropdown of the computerName, when clicking submit it will find the offsetted values to the right.
View Replies
View Related
i want to import data from excel and save it in sql server data base.my problem is how open excel file and read it cols by cols or rows by rows.
View Replies
View Related
How do i insert data into an Excel Sheet, Along with the provider to be used.
View Replies
View Related
I try to find the best small exemple to display data from excel to asp (connection & code). But only asp.net exemples in microsoft.com.
View Replies
View Related
I have an intranet application written in asp using access as the backend database. My users have requested they be able to download certain data into an excel spreadsheet. I have limited asp experience and could use some help.
Ideally, the user would be prompted to save and name the file (save as dialogue) and then the data would be selected and saved into that file. I know I can use a select statement to select data directly into an excelspreadsheet using:
SELECT * INTO [Excel 8.0;Database=" & lcPathFile & "].[Sheet1] FROM myTable
But I'm not sure that is the right approach.
View Replies
View Related
I retrieve data from the database and display on ASP, then I export these data to a file, like Excel (the best) or text file. Is it possible? I think it is possible, but how can I do that?
View Replies
View Related
how to show excel data in asp?
View Replies
View Related
If there are any tutorials out there or websites that can explain more about this? How to get data from an excel file(or any other file like a .txt) and inserting them into a database using asp? can this be done in asp?
View Replies
View Related
I didn't know how to use asp to update or insert the excel data ....
View Replies
View Related
Is anyone aware of a 255 character limit when reading data from a particular Excel cell? I'm experiencing when pulling straight text from an Excel spreadsheet, which otherwise works fine. Right at 255 characters, the data is truncated and I only see that bit of information.I've searched Google and came up with a few registry modifications, neither of which fixed the issue. Has anyone else ran into this?
View Replies
View Related
Is it possible to extract data from SQL server to MS Excel ? Say if I have 2 tables (Membership and Profile) and extract some certain datas from those 2 tables; MemberID, Member Name, Birthday, Interest; could it be possible to extract them automatically everyday at 1 AM without me doing it manually?
Perhaps its possible to do it with Stored Procedure? or some other means?
View Replies
View Related
I have an asp page that collects data from a database and then displays it in a table on the page. I also want to be able to put this information into excel. I know how to get the page to load up in excel and then display the data using the following command -:
response.contentType = "application/vnd.ms-excel"
however I want it so that there is an Extra button on the page that the user can press to transfer the data accross. Does anyone know how to do this?
View Replies
View Related
I have a master table employee , which contains the details of employees .
i have to upload the the data to this table from thye excel sheet by using asp.
that is -- what i have to do is , I have to provide a interface to browse the the excel sheet by user , afetr browsing the sheet user will submit the page and i have to read all the rows of excel sheet and update the table . if id exists in the table , then update the data otherwise append the data . Code:
View Replies
View Related
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:
View Replies
View Related
i have an ASP page which get data from DataBase. To save it as EXCEL I am using:L
<%response.contentType="application/vnd.ms-excel"%>.
What i want is to stop the user from editing some columns of saved excel file just like we pasword protect an excel.
View Replies
View Related
Does anyone know how to export data from an excel spreadsheet, straight into ms sql server database?
View Replies
View Related
I have asp project where large volume of data entry would be done. I am
trying to find out if there is any tool that can allow me to build asp
application where the forms would be like excel spreadsheet.
View Replies
View Related
how can i export the result of query in a excel file(.xls) in asp page.
View Replies
View Related
How to using one excel template to insert data into another excel spreadsheet by using asp programming ?
View Replies
View Related