Column Autofit In Xls Using ASP Contenttype
I am trying to create a report in xls format using ASP. I need to do some formatting to the report. To do this, I'm using xml. But, somehow, I cannot get the columns to autofit causing the report not to print in one page. What am I missing?
Here is the code
******************
<%
Response.Contenttype="application/vnd.ms-excel"
Response.AddHeader "content-disposition", "attachment; filename="Report"
strHeader" = "User criteria goes here"
%>
<HTML xmlns:x="urn:schemas-microsoft-com:office:excel">
<HEAD>
<style>
<!--
td
{mso-width-source:auto;}
col
{mso-width-source:auto;}
@page
{
mso-header-data:"&CDate: &D
View Replies
ADVERTISEMENT
I have a page called createWordDoc.asp, that starts with the line <% Response.ContentType = "application/msword" %>.
What it does, is receicves information from a form on the previous page, formats everything using html, and saves it as a word document.
Everything is working ok, except when I open the word document, there should be a picture in amongst the text, but it isn't there.
Does anyone know about creating word docs from asp, or has anyone had simliar problems?
View Replies
View Related
<%Response.ContentType = "video/x-ms-asf" %>
<% dim songs
set songs = server.CreateObject("scripting.dictionary") set songs = session("cart") %>
This code works fine in IE but in mozilla/netscape, session object is lost and returns error. However, if i resmove the first line for contenttype, the code works fine in mozilla but i ned the first line as this code is part of playing a window media playlist
View Replies
View Related
I had a asp file that generated asx files using
Response.ContentType = "video/x-ms-asf"
It was working fine up until a day or so ago. Now all of a sudden it does not work. If I take out the Response.ContentType line and copy the source code to a asx file it works fine. if I copy the URLs out of the code and put them into the browser it plays. So it is generating the file correctly, it is opening Windows media player, but it then errors saying it cant fine the file. Yet copying the URL from the generated asx works fine.
View Replies
View Related
I am trying to generate an RSS feed with ASP, however, IE will not
display the feed as an XML document, instead returning it as text.
I have <% Response.Buffer = true %> and <% Response.ContentType =
"text/xml" %> at the top of the page, but it does not make a
difference. Netscape/Mozilla recognizes the contenttype and displays
it as XML, and the feed is valid.
View Replies
View Related
What would prevent Code:
Response.ContentType = "application/vnd.ms-excel"
from opening the page in excel assuming that excel IS on the clients machine?
The page has a couple included pages that contain ASP and JS, the page itself dynamically writes the table cells in html like so...Code:
strTable = RS.GetString(,,"</td><td>","</td></tr><tr><td>"," ")
View Replies
View Related
You know how you can use "Response.ContentType" to tell the browser to display the content as Excel or Word and it will automatically convert your html page into an .xls or .doc file. My question is can I convert it to PDF? If so how?
View Replies
View Related
I have a problem in that i have a page that works fine and shows all records/Output until i add Response.ContentType=msword
And then i only show every other record.
I probably should have coded the page differently. But for context - it's a school report system and i have setup a Subroutine which queries a database and builds a summary report for a girl. I wanted to print out a class list of these. I.e one for each girl in a class and so i loop around the results of one recordset and within each loop make a new query and create the report. This is probably not the best way to do it.
Anyhow, in the browser it woorks fine. As soon as i add the code to output it to word (or excel ) i lose evry other report.
View Replies
View Related
It involves using ASP/VbScript and ADODB.Stream to read binary data from a *.DOC or *.RTF
file and then send it to the user with Response.ContentType and BinaryWrite.
Everything works fine until I try to Replace() certain strings in the *.RTF
file with my own data. I'm assuming Replace() is choking on the binary characters, or
incorrectly thinking 0x00 values are marking end of string. Code:
View Replies
View Related
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies
View Related
I have created an Excel spreadsheet for the web. When it opens in IE
6.0 I get the message that the format is not supported. This is because
it is in tab delimited format. Ane when I save the file, It saves it as
txt. How can this file be created so that Excel sees it as an .xls
format. I created the data in VB 6.0 with a vbtab to seperate the
columns.
View Replies
View Related
I'm using Response.ContentType = "application/vnd.ms-excel" to display contents in excel file.
I have one problem my SQL Query is working fine,because I checked it 1000 times and the most important thing is because if I don't use Response.ContentType = "application/vnd.ms-excel" and just printing the contents as a table it works!!! But when I write Response.ContentType = "application/vnd.ms-excel" I don't see the contents!?
One more thing ,when I use the same file with other SQL Query that is a little different I can see the Excel perfect.
View Replies
View Related
I am using Response.ContentType = "application/msword" to open the page as a word file (obviously). As an asp page, the page opens great and looks great.
But, when it's opened as application/msword, i get unwanted line breaks after every table as well as table borders and inaccurate table widths that weren't there when the response.contenttype line was commented out.
I'd make it one table but the page is a report that consists of rows and columns... some rows not lining up, hence new table. (it has to be exact).
View Replies
View Related
I have a csv file that I'd like to be able to add a column to. Specifically, I want to take the first 6 chars of the filename and add it to each row as a new column. e.g.
Code:
whatever.csv 'before
1,2,3,4
whatever.csv 'after
1,2,3,4,whatev
View Replies
View Related
Ok let me explain what I am trying to do as easily as I can. I have a table in my access database that I am connecting to. I select a specific id number using my SQL statement. Now what I am trying to do is scroll through that records row and get the column name of that column along with the value of that cell. I hope that isn't to confusing. Now I'm not sure whether this would be done using ASP or done in my SQL statement. Code:
View Replies
View Related
How do you get the description of fields in an Access database? I really need this and can't find it anywhere....
It would also help if someone showed me how to get the datatype and other info (like if it's a Yes/no or True/False field).
What is the resource/doc for this so I know where to look before asking from now on?
View Replies
View Related
Ok i'm self taught with regards to ASP so not great etc, so sorry if this is a really basic question..
On the last line here i'm trying to some how get it to call the last ID entry...
ImageID = Request("ID")
If (Len(ImageID) = 0) then ImageID = "1"
If Not IsNumeric(ImageID) Then ImageID = "1"
If ImageID = "0" then ImageID = "1"
If ImageID>3 then ImageID = max(Len(ImageID))
This is basically for some max min links for a online comic here's what it links to
<a href="default.asp?id=<%=ImageID-1%>">< Backwards</a> -
<a href="default.asp?id=<%=ImageID+1%>">Forward ></a> -
Code:
View Replies
View Related
Can someone please explain to me why the hyperlinked column headings will sort in Firefox and IE 7 but not in IE6. Code:
View Replies
View Related
I need to set up an HTML table or the like, with 4 columns.
Each column needs to have a header with a FRIDAY (dd/mm/yy) date.
i.e. this weeks Fridays date is 16th Feb, the following is 23rd Feb
etc.
So, I need column 1 to be headed 16th Feb, col 2 to show 23rd Feb etc.
As this week passes, the dates need to move up 1 week, so that next
week, col 1 will display 23rd Feb and so on.
These headers need to change according to the date.
Please can you advise how I best achieve this ?
View Replies
View Related
we have a requirement to freeze the column and row column heading... so that when the user scrolls to the right the first two columns ( I refer them as "row headings") will stay and the remaining columns scroll left and when the user scrolls to the bottom the first row stays ("column headings")and the remaining rows will scroll up.. This can be easily accomplished in EXCEL by freezing the itersecting cell... How can the same be accomplished using HTML tables /ASP code.... Is there any Active X control available that can be used to accomplish the same?Our technical env is ASP and Oracle DB
View Replies
View Related
Pretty basic but I cannot figure it out.
Column:
FULLNAME (lname, fname)
Needs to be
FNAME
LNAME
Should split at the comman.I already have all the columns created; just
need to SQL command to make it happen.
View Replies
View Related
I am trying to access a table in a SQL server using ADO in ASP. It works fine in the rest of the site. Here is the code:
View Replies
View Related
If I have several fields:
a | b | c | d | e
and the original SQL = SQL & " ORDER BY a ASC ".
I want to place links to b, c, d, e to make the table of results to show by ascending order of b (or , c, d, e).
do I need to place an "if/ end if" in the sql or do I put some statement in the paging?
example
a (ORDER BY a ASC)| b | c | d | e
1 | 3 | z
2 | 2 | y
3 | 1 | x
4 | 5 | w
5 | 4 | v
to
a | b (ORDER BY b ASC)| c | d | e
3 | 1 | x
2 | 2 | y
1 | 3 | z
5 | 4 | v
4 | 5 | w
View Replies
View Related
I have a SQL query that produces a table which displays account numbers and the amount owed on those accounts.
the page that displays that table is written with ASP. Does anyone know how can I highlight the rows in the table where account numbers have more than 7500 dollars in amount owed? Code:
View Replies
View Related
im reading from multiple databases, and one restraint is that i must know the amount of columns and the names of the columns before i can display info from the database.my question: can i somehow GRAB or READ this information from each database and then just adapt my Display accordingly
View Replies
View Related
I have an asp page which the user enters a time(e.g. 12:21). I need to insert this time into a SQL Server DB, which has a smalldatetime column.
I have tried everything I can think of (such as CDate, TimeValue, FormatDateTime etc) to convert the time string, into a valid time. However, the insert always try to insert a datetime datatype (e.g. 12/12/1899 12:21:00).
I am trying to process the insert through ado, eg:
objRS.AddNew
objRS("Field1") = strText
objRS("DateField") = dteValue
objRS.Update
View Replies
View Related
I use this code to dynamically create a column in a table...
strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));"
conn.execute(strSQL)
This will create two text columns. How can I create some YES/NO columns
instead of TEXT columns?
View Replies
View Related
Is there a way to have a piece of repeating information display in multiple columns like a phone book? I need to display a list of contract numbers which will link to the actual contract.
There is no other information to display and it would be better if I could display 3 or 4 columns on the page like a phone book. Hope that makes sense. I am using Dreamweaver and it's and Access db if that helps.
View Replies
View Related
I use this code to create a table dynamically.
strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));"
conn.execute(strSQL)
This will create two text columns. How can I create some YES/NO columns instead of TEXT columns?
View Replies
View Related
Is it possible to get a db's column names not the data inside the columns just the columns names.
View Replies
View Related
I've searched high and low in this forum for an answer to this one. maybe someone knows where it's at.
Let's say I have a page that is displaying fields from the database. There is a column of numbers, that at the bottom of the page I would like it to display the total of those numbers displayed. Is there an easy way to make this happen?
View Replies
View Related
I want to save the details of phases. On selecting a phase, there are 3 columns, task ,start date, end date in a row. Next to it, a button'Add task' is displayed. on clicking this, another row appears below. When i click submit, the data is saved if the following condition is truw: The end date should not be less than start date. how do i retieve the data of all the rows.
View Replies
View Related
How do I print the name of all columns in a table?
View Replies
View Related