How To Set Text Style For Excel
How to set text style for an excel cell progrmattically, which is equavalant
to Excel->Format Cells->Number Tab->Text
ADVERTISEMENT
Exporting Excel To Text File
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:
Determine CSS Style
I want to use asp to assign a css class to <td> tag. I was thinking an If statement, but i've not come across trying to assign a class to a table cell before! I want the cell background to be highlighted red determined by a database table with - yes or null. (null remains white, yes - red) At the moment it simple like this: Code:
<td><%=strAddress%> </td>
Cannot Using Style Sheet
I would like to using style sheet in ASP generated Excel, but it sees cannot using it. Here's my code:
<style>
<!--
..report {
font-family: Arial;
font-size: 11pt;
}
//-->
</style>
<%
response.contentType = "application/vnd.ms-excel"
%>
<font class="report">testing</font>
Adding CSS Style To An ASP 2.0 Menu
how to add a css style to a menu in asp 2.0?
View Replies View RelatedASP Style Sheet Switching
I need to figure out how to make ASP add in the appropriate style sheet. Basically I want it to look, see what page it is on and say, 'Ok ... if this is the home page, use this style sheet ... if it is not, use this other style sheet.'
View Replies View RelatedTrying To Write And Asp Style Switcher
I'm trying to write a style sheet switcher for myself in asp. The code sits on every page. I've so far managed to cobble the following: This block sits in the head: Code:
View Replies View RelatedDynamic Inline Style
I am storing content in a database, and when a text field is updated I am adding a line "Updated by <username> at <date and time>" inside the text field.
Now what I would like to do is to apply a dynamic style to that line by using a span.
<span style="<%=UpdateStyle%>">Updated by <username> at <date and time></span>
where UpdateStyle would be an ASP variable like "font-weight:bold;color:red" etc, so how that line is displayed is amendable at any time from within an include file.
Well obviously using <%=UpdateStyle%> didn't work ... I also tried defining it as a javascript variable and calling it using document.write, but that didn't work either.
Css Style Sheet With Asp Code
I am having trouble with css style sheet with asp code, everything was working till I put extra of css code in there, and I got error message state expected end statement,
Response.Write "<a class="three" href=""job.asp?ID=" & rs("ID") & """
style="text-decoration: none">"
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.
Entering Data, Spreadsheet-style
I would like to know if and how it would be possible to create an
entry-screen that allows the user to enter data in a database, using a
spreadsheet/table-like entry screen. The screen would start of having
headers for each column/field and an empty row underneath. When each column
in the row is filled in, the user must have an option to add another row.
I'm look for the code/explanation that helps me set up the entry screen, and
the ASP code to add the entered data in the database.
I can imagine that each entered row is added to the table when a new row is
added, or a button is pressed and then the screen refreshes with the newly
entered information and a new row...
Shopping Basket Style Thing
Further to a question I posted a few weeks back - i'm devloping a site for our company where visitors can vist product sections, and pick catalogues they want - currently they can only go to one section, pick catalogues, order them, then move onto another section - problem is this. The powers that be want a more 'shopping basket' style - where customers can browse all the sections and pick as they go - and order them all together. In a 'shopping basket' styleee - so does anyone know of any good shopping basket style tutorials?
View Replies View RelatedCalendar / Album Style Resultset
I am trying to make my result set print out the results in the same style as
a calendar or photo album. I am actually making a photo album, and I can
only print the results in list format. I would like to have 3 or 4 results
per table row. Then once I have 3 or 4 results across a new row in the table
will start. Code:
Explorer Style Tree View
Anybody have any experience of a decent explorer style tree view system which is database driven?At the minute I'm using ASP Tree View (www.CompuSolve-Technology.co.uk) but it's not really the best.It has to work with a database (MS SQL Server).
View Replies View RelatedWorking With INI Style Config Files
It there a standardized process of working with text files that follow the typical INI file pattern with sections within it designated with square brackets? I am looking at needing to read in some of these into the DB and then editing in the DB and writing the files back out again. As an example they would have sections like this:
[fltsim]
'Stuff here
[general]
'Stuff here
ASP Classic PHP-style Function Reference
If anyone knows of something similar to the PHP style documentation that would be great.
View Replies View RelatedBREADCRUMB Style Navigation Displays File Names
I have this file called "inc_BreadCrumbs.asp" basically this is a Navigation include file as breadcrumbs style, and I inserted this to every page in my site. It works fine but one thing I cant configure is that:
It displays the file names as for example: search.asp or results.asp etc... But i want it to display as SEARCH or RESULTS etc... How to implement this? Can it display only page title name or something else how can you change it? Code:
Regex :: Grab Any Style Attribute Within HTML That Uses Double Quotes
I have the following regular expression:
re.Pattern = "style[^=]*=[^""]*""[^""]*"""
It will grab any style attribute within HTML that uses double quotes, and put it in the re.Matches collection.Now, I want to include single quotes into this regular expression. Here's what I have so far:
re.Pattern = "style[^=]*=[^""']*(""|')[^1]*1"
but it does not work.
Controlling Text In A Text Area Or Text
I have this problem in controlling a the text in a Text Area. How can I do
that for example the field size is 200, when it reaches 50 it automatically
goes to the next line. Bcoz im having problem when viewing it in my report,
it continuesly views in a strieght line and im having problem in printing.
International Text And FSO Created Text Files
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
Text Area Limited Text
I have a text area which I want to limit the number of words or number of text entered into it. Is this possible?
<textarea name="textarea" cols="35" rows="5"></textarea>
In the text area above, can I say limit the person filling in the text area to say 100 characters?
Text Box In Form Cutting Text
I have a form on asp page that pulls info from a DB when the page loads.
It them puts the info into text boxes on the page that are editable by the
user.
The only problem I have is say in the description text box it should
read "HP Laserjet 5Si" , it always cuts the text off where it just says "HP"
.. It does this on all the text boxes? I can't seem to figure out why it
is doing it. Here is the sample code:
With quotes around <%= vdesc%>
<td><input name="desc" type="text" id="desc" size="45" value="<%=
vdesc%>"></td>
And I tried it without.
Regular Expression Of Text OR Text OR Etc...
I have text in a field coming from a database. The text has various
forms such as:
text1
text1 or text2
text1 or text2 or text3
text1; or text2
text1; or text2; or text3
etc...
how can I parse this with a reg ex? I tried this:
(.+);? or
but it only captures 1 submatch (text1) and only if theres an "or"
after it
I'd like to get 1 submatch for each piece of text separated by the
"or", just the text itself if there is no or.
Anyone know how to do it?
Controlling Text In A Text Area
I have this problem in controlling a text in a Text Area. How can I do that, for example the field size is 200, when it reaches 50 it automatically goes to the next line. Because im having problem when viewing text in my report, it continuesly views in a straight line. Can you give me ASP code for that.
View Replies View RelatedHover Over Text To Bring Up Text
I have text - ARI Promise, when I hover over the text I would like a box to appear with the Promise information. It would be several paragraphs that need to be formatted with paragraph and bullets. Is this possible to do? If so how would I go about it?
View Replies View RelatedDisplay Text In Text Box
I have a search page, after search returns value I want to display fields in text box instead of table.
View Replies View RelatedError In Asp Text: Command Text Not Set For The Command
I am getting the above error in an asp page. Not sure why? The error details is given below. Code:
View Replies View RelatedASP Excel
I want to give Excel facility into the the Browser for the user and after that I need to insert all the Excel data into the SQL Database table.
View Replies View RelatedAsp Excel
i have a project i am currently working on, basically what i am doing is i have an excel spreadsheet with 2 fields a number that coordinates with another field which is a url, currently i have to copy paste the url in my browser to get what i want, which is a picture, each url is a picture and picture only, what im trying to do is create an asp web app that i can use that spreadsheet connect using asp and automatically download every url in the spreadsheet to a directory, while also renaming all the pics as the first field.jpg,so basically an asp downloader that downloads contents of url and renames it a certain number
View Replies View RelatedAsp & Excel
I've an asp page which brings back a query and displays it in a table. The
query takes around 30 seconds. Once the page displays they will have an
option to send it to excel.
From the examples I've seen they all require the
query to be re-ran again in asp (i.e. server side scripting) and as it takes
30 seconds to start with I want to try and take out the repeat of the query.
Does anyone know of any way you can do this in asp by passing the already
executed table to asp or via any other method?
How I Can Get Value From Ms Excel
I want to access the data contained in the MS excel by giving a field value that has to be got from one HTML file including a textbox and one button -SUBMIT to submit the required field value. Finally i want to display the details of that particular field value which is recieved from the first file in HTML. Is it possible ?
View Replies View RelatedASP IN EXCEL
I have an ASP file which is opened in MS Excel.
I have used the "formatNumber" function to set the number
of decimals for variables which are displayed.
however Excel cuts off any zeros at the end.
e.g 4.650 displays as 4.65
the number of decimals I want to display to varies across
the page, e.g. I cant say "display the whole with 3
decimal places"
Is there any code I can put in my ASP page to stop Excel
truncating zeros at the end?
Ms Excel
i have a Print button to allow user to save reservation detail in ms excel. currently, when user clicks Print, a Save menu which allow user to open and save will appear. how can i skip this window? i want my system automatically open ms excel and at the same time open the Print window in ms excel and user also cannot modify any detail in ms excel. is it posible to that?
View Replies View Related