Anyone Use Asp Cheat Sheets?
asp is known for it's large amounts of useful functions, how does everyone remember them. I am thinking of typing up all of them and then print it off for easy look up. is that bad?
View Replies
ADVERTISEMENT
Export To Excel - Multiple Sheets & Renaming Sheets
I'm developing a website for work that exports some reports to excel.
I am using the...
Response.AddHeader "Content-Disposition","attachment;filename=report.xls"
Response.ContentType = "application/vnd.ms-excel"
....strategy to do this. It works wonderfully except I cannot figure
out how to do two things:
1) specify a name for the worksheet that's exported (it names the
worksheet "blah.asp?q=123" when the user wants to see "Monthy Quotas"
2) generate multiple worksheets. The exported spreadsheet should have
about 6 tabs on the bottom that all contain different information in
the same report.
Dynamic Css Sheets
I'm using dynamic css sheets.What I'm currently doing is reading a normal css sheet as a text file, then using regular expression to change all the size values and outputting the resized css.Would it be faster to put a resizing function in the asp page that outputs the css, rather than using regexp to change a stylesheet? something like this
Code:
<%
Function resize(n)
resize=Int(clng(n)*(size/12))
End Function
%>
h1{height:<%=resize(20)%>px;width:<%=resize(200)%>px;}
#firstDiv{height:<%=resize(120)%>px;width:<%=resize(200)%>px;}
..............
..............
ASP -> Excel & Several Sheets ?!
I did some searching here & Google but I'm probably blind because nothing matched exactly what I'm trying to do. I'm creating an excel file through ASP, oh yes, I'm doing it! No probs there but how would I add data to several sheets? This is the idea (simplified) how I'm doing it:
Code:
<%
Response.ContentType = "application/vnd.ms-excel"
Response.Write "<table>"
Response.Write "<tr><td>Hello Excel World</td></tr>"
Response.Write "</table>"
%>
So what should I do if I'd like to create a sheet called "foobar" and write that stuff to it and then another sheet called "zenithrocks" and write some other stuff to it.
Generating Excel Like Sheets Using XML And XSD
I'm facing a challange where I have some XML data in
either a flat file or an SQL database. I also have an XSD
file representing the structure of what used to be one-
many Excel sheets.
My task is to generate an Excel like sheet in as ASP.NET
webpage where users can edit the XML data stored in an SQL
database.
I'm using Visual Studio 2003 and C# to build this ASP.NET
application.
I know it's a long shot, but if anyone has experience in
building similar applications I would love to hear how you
have approached it.
Loading Different Style Sheets
I am currently undertaking a project where I have to make the page layout and colour scheme customisable to the user. I have therefore created the different style sheets for both colour schemes and layouts. Each user within the backend database has a field for layout and colour scheme. I need the system, when a user loggs in, to check the field value of both of these, and apply the relevant CSS sheet to every page within the site thereafter.
I have already tryed using cookies, but becasue it is for a school, many users will use multiple machines so that wouldnt work.
Export To Multiple Excel Sheets
I am trying to export a group of tables to an excel workbook and I would like to export table 1 to sheet 1, table 2 to sheet 2 etc. I am using
<%Response.ContentType = "application/vnd.ms-excel"%>
which exports everything to sheet1. how can I split it so it outputs to different sheets.