When the output is in excel format for an ASP page, some of the values displayed get transformed to decimal numbers instead of their true values. How to solve this problem? When the output is in plain html, the values are displayed correctly. Note that the values to be displayed are in TIME format. How can i change the format of excel cells in asp?
For output in excel when the form method is POST, no parameter values get posted to the other page. But when it is GET the values get posted. Y? I even change use request.querystring for GET but the result is the same.
I create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see. Is any way to seperate it? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page, or create another drop down list to select for how many data to show in a page? and how to write that ?
I have a asp page which will get the data from multiple tables (with functions and procedures)and display data in HTML tables <TABLE> on ASP page.Is there any way we can create a excel file from the output of this ASP file.I know how to export if this information on ASP page is coming from single query from a database table.
I am developing my application in ASP and there is a requirement to save the output in Excel. One option is to use Content-Disposition header but it prompts user for saving. As per our requirement the output should get automatically saved.
The website sends users through a series of questions. When they are done they can view there results and open a printer friendly version, but my boss wants the user to have the option to send their answers to Word or Excel so they can either change their answers or the layout of whatever. Is there a way to do this?
I 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 :
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.
I have a site that currently collects info from a form. The info is then emailed to an elected email address. It occurs to me that perhaps there is some way of collecting the information and sending to a spreadsheet that would keep updating. THe information is all word based (as in mostly yes or no answers).
i have created a quotation page where customer could view the quotation details and i just thinking to allow customer to print his/her quotation as a reference. all the data are fetched from db and displayed in the table.
I have one problem, that is i design a ASP report getting data from MS SQL Server 2000 and displays it as a desinged format and also "one option to export this same format to MS EXCEL". Before i seen it, but i dont know its code:
The problem i have in my system you can seacrh clients and then display their details. what i wanna do is find the client i want and then have a button called e.g. generate and then the asp pops up a word or rtf document with there details sloted in to a preformatted document.
Now i know i could do this by creating the doc line by line with asp on the file but is there a faster way of just inserting the asp values into placeholders in the word or rtf file which has already been setup?
I'm having a problem controlling the output from an access db and the css two column layout. It goes like this.Left side has a connection string and outputs 3 columns of db data to the leftside of the page. There is also a conection string on the right side of the page. It outputs that db data AFTER the right side processes that data. So the page is staggered, left to right instead of displaying the results across from each other.
I have an ASP program. It outputs HTML with some XML data islands in it. When I run the program, the browser sees the HTML and doesn't work the way I want it to. however, if I view source on the output page, save the source as an XML file, then open the saved file, it works properly.
How do I get the browser to treat the output from an ASP program as XML instead of HTML?
This is really puzzling me; I am developing a site for a client and have uploaded it to a remote server with ASP enabled; I and my friends do not have a problem diplaying the output HTML from my ASP statements however, my client is unable to see it. He says he can see all the other page (CSS layout) but is unable to view the content (output HTML) from my ASP statement. Now I am clever enough to know that ASP is server side, so I cannot understand why he can't see it- and he has tried this with two of his computers. The only possible explanation that I can come up with is that he may have Javascript disabled in his browser as my pages contain a small amount of Javascript.
if guy can help how to output if my customer make reservation....enter everything ..etc enter first name, last name. then after click make reservation button it will come out his/her name on the page for his/her referrence ...then it will clear once another customer enter it.
This might sound stupid to you guys, ok i have this:
------------------------------------------------------------ perc = (total*100)/limit
response.write (" You are using ") response.write perc response.write (" % Of your 1GB")
------------------------------------------------------------- but on the output i just need the first two digits, but i get this You are using 21.8057899 % Of your 1GB
Please guide me. How can I output the records from my recordset in columns in a table? That is, instead of just one record per row in a table, how can I have multiple records per row?
I haven't being doing that much in ASP, but I have to create this: It has to read out data from some DB to excel.
The following (corrected) code works if just it outputs as html, once the Response.ContentType is excel. then it offers to open/save the file, and stops - file not found - what do I do wrong? Code:
Does anyone know of any freely usable code that helps automate the process of generating RTF files from ASP (particularly generating the code needed for tables)?
I created an RSS script for my readers to use, but I have been having some minor issues with it.
Actuallyit works fine and I have tested it in 3 feed readers without a problem. Still it does not output as perfect XML if you go here you will see what I mean. Code:
I am trying to build a knowledge base for use in out internal IT department. It uses SQL to store the data and at first just printing out the questions and answers in a table in plain text was great, but now I have run into a place where there needs to be links and line breaks and spacing. Formatting in general is going to be needed for anything with an answer over 1 line long.
It also needs to be able to be updated. I have the code working for the update right now, but I am not sure how to go about getting the ouput from the database to display where links are highlighted and such.
I am sending a form to UPS and upon successful completion of the form, the UPS sends me a single output containing several variables and their values on the screen. I need to prevent it displaying on the screen, save it in a variable and then extract information I need and display those values with my format on a table. How can I do that. I heard in ColdFusion there is <CFHTTP> that does that. Is there equivalent of this in ASP.
i m giving link print this article to my users to print the page.
Code:
<A HREF="javascript:window.print()">Print this article</A>
but it is printing whole window but i want to print only news part. i want to make the printed output "printer friendly". means stripped off the left and right side crap. And the banner ad at the top.
