I am developing an application which uses data represented using color codes, in an MS-Excel worksheet. The application has to assign values based on the backgroundcolor of a cell. Like, Black = 0, Red=1, Green=2.
How to determine the background of the cell in ASP?
I need to sum the values in different cells of an excel sheet which im getting from data base and which is in a loop and the number of entries depends on the user.
i m adding the code please check it out:...
I've seen lots of posts on this and other boards, but nothing seems to work for me. I need to import data from an Excel spreadsheet using ASP. None of the ranges in the spreadsheet are named. I'm using this code:Code:
<%
Set ExcelConn = Server.CreateObject("ADODB.Connection")
Set ExcelRS = Server.CreateObject("ADODB.Recordset")
ExcelConn.Provider = "Microsoft.Jet.OLEDB.4.0"
ExcelConn.Properties("Extended Properties").Value = "Excel 8.0"
ExcelConn.Open "c:inetpubwwwrootaspcalendar est.xls"
set ExcelRS = ExcelConn.Execute ("SELECT * FROM [Sheet1$]")
Response.Write(ExcelRS($A$1))
%>
I've tried every variation on "ExcelRS($A$1)" that I can think of - I've seen "ExcelRS(1,1)" used, but that doesn't work... What is the syntax for accessing Excel data by cell coordinates?
I get data out of a database and the user can save this data on his disk in Excel format.
Some cells has a large lenght of numbers (eg. 20060512000000). If I open the excel file, the cell where that number is in shows the following : 2.00605E+13.
I have to go into Format Cell and convert this to 'Number' and no decimal places. Is there a way in ASP to define the cells ?
if i have an standard excel file and i have data in there in specific cells. Is it possible to have some upload facility that will be able to paste it to specific asp form textboxes?
e.g if the data in the excel file was in cell c4, i would want to paste it into textbox4. Is that possible.
OR
Is it possible to upload an excel file and to put specifc data from different cells directly into an access database.
e.g excel file -c4 i would want to paste it to rs("test4")
I'm exportin a datagrid to excel, but Excel file is without format colors cells border...
Do you know how format it? Code:
is there a way of calling an already existing excel document and populating certain cells
View Replies View RelatedOne of my programmers is using Office Web Components in classic ASP to create, fill and format an Excel spreadsheet. Everything is fine except when he creates Merged cells the performance drops dramatically. He has investigated the 'Center Across Cells' alternative but cannot get it working
using Office Web Comonents.
Has anyone come across this problem or even better has a solution?
It works if the file in on the server side, how to use the component (DSOleFile) with the file on the client side? Also how can I calculate the width of the file. (Page set up - Landscape or porrait). Code:
View Replies View RelatedDepending on a value in a recordset, is it possible to write the table cell background colour. for example:
If "win" is the value, bkgrd will be "green"
If "draw" is the value bkgrd will be "yellow"
If "lose" is the value bkgrd will be "red"
I have created a table that I want to fill with calculated values. I have given ID's to each cell. This must NOT be the way since I can't address these ID's. How do I store values in table cells from my PostBack?
View Replies View RelatedI've decided after several failed attempts this is too difficult to do
on my own. I know it's been done before and a tutorial or code must
by lying around somewhere.
I have a Weekly Calendar
It's in a table with 7 columns and 22 rows
Across the top I have Monday thru Sunday
Down the side I have half-hour time increments - 8:00am - 10:00pm
I would like to display my events on the table, corresponding to their
day and time. If it spans several hours I would like the event to
span several rows.
Basically look like an Outlook Calendar.
I've tried this myself with five dozen if/then statments and embedded
loops but it's a huge mess.
I'd like to find out how to simply do this in asp (not ready for .net yet), any
ideas?
I have an ASP page that loops through a SQL Server 2000 table, then
downloads an Excel sheet the users can save, etc. Works fine, except, I see
that in one particular "comments" field the Excel sheet returns a #VALUE!
error in the cell when there is a large amount of text. I've looked through
the MSKB, MSDN and many ng posts to see if there is a workaround or solution
to this, inclduing looking at the xlWorksheet properties (I've tried
'xlWorksheet.Cells(iRow, 11).WrapText = True), played with Orientation, etc.
But to no avail.
I need to come up with an if statement that will basically take a large list of records and place each one into its own table cell, and when the cells reach a max of 5 in a row, start a new row and repeat. How can I go about this?
View Replies View RelatedI have an interesting problem and am looking for some advice. I am
hoping to build an asp whereby records are pulled from SQL Server. These
records will be merely file locations for thumbnail images I hope to display
in a grid.
Rather than having a grid be constructed row-to-row, I was
wondering if it is at all possible to dynamically construct this grid as a
table of thumbnails whereby each cell (perhaps 5-6 columns across)
represents one record? I have no idea how one would construct this loop that
spans columns AND rows rather than just rows.
I have data outputted to the table such as (where * are dividers):
Name 01 * Category 1
Name 02 * Category 1
Name 03 * Category 2
Name 04 * Category 2
Name 05 * Category 2
Name 06 * Category 2
Name 07 * Category 3
Name 08 * Category 3
Name 09 * Category 4
Name 10 * Category 5
Name 11 * Category 5
I want each "Category" to have it's own background color, aletranting colors would be ideal so:
Name 01 * Category 1 (Background Color #fff)
Name 02 * Category 1 (Background Color #fff)
Name 03 * Category 2 (Background Color #ffc)
Name 04 * Category 2 (Background Color #ffc)
Name 05 * Category 2 (Background Color #ffc)
Name 06 * Category 2 (Background Color #ffc)
Name 07 * Category 3 (Background Color #fff)
Name 08 * Category 3 (Background Color #fff)
Name 09 * Category 4 (Background Color #ffc)
Name 10 * Category 5 (Background Color #fff)
Name 11 * Category 5 (Background Color #ffc)
i want to give font color red to each head line ..how to concanate with this '<%=RS1("headline")%>';
Do while NOT RS1.EOF
%>
theSummaries[<%=i%>] = '<%=RS1("headline")%>';
theSiteLinks[<%=i%>] = '';
<%
i = i+1
rs1.movenext()
Loop%>
I have got a peculiar requirement. I want to distinquish between the color codes.
I have got two text fields and i will enter the color codes there. The first text field will have background color The second will have text color.
I want to validate if background color is dark then only light colors should be entered in text. and vice versa.
Is there a way to control the hypertext color. I noticed mine are blue when not clicked and red/purple when checked. Is there a way I can make them say white and blue?
View Replies View RelatedI have built an asp app that sends an e-card to selected recipients along
with the text entered by the user. Well, on some machines the text is not
visible because the background color of the table is not going across
correct. The background color is supposed to be teal with white letters.
However the background is going across white with withe letters on some
machines. I am using the same browser (version and everything) as one of the
machines that can't see it the correct way. I am able to see it fine. I have
put in the back color for all of the cells the table, etc but it's still
going through white. What would cause this to happen?
I was asked to incorporate colour options for items sold in my shopping cart such as pens.So if I am selling a pen that comes in 4 or 5 or more colours, then I have to create the number of types of collours for the pen. I am looking at creating a colour dropdowns for individual items , but I am not sure how I can do this in backend.I am using Access database and using ASP programming. This is the link which is an example of what I mentioned http://www.27905398.com/product_inf...9a4aed0a18fb81d .appreciate if anyone familliar with this function
View Replies View RelatedIve created a web page that queries a db and i have that all working fine. What i dont have though and would like to be able to do is get the page to highlight rows according to one colums value, ie
Colum1 Colum2
Row 1 50 Test <-- would like to the be highlihted lite blue for instance
Row 2 90 Test2 <-- would like this to be highlighted red for instance
does anyone know how to make a pop up color chooser so that people can click a button that pops up a thing of colors and then they select from it? i'd even take the color options thing that is at the top of this scrren when writing messages but i need a way to choose colors easily.
any suggestions? also it doesn't have to be in asp, i'm figuring it might be better suited for js or something but i don't really know js and most of my site is in asp...
i've been playing around with this code but can't seem to get it to work. When the check box is clicked the row should change to a color, not sure on why its not working, any ideas? Code:
View Replies View RelatedI'm gettin some numbers out af a db, and would like it to give certain numbers different color. lets say that all numbers 4 should be red, and all numbers 5 should be green.Is that possible
View Replies View RelatedI'm writing an article which contains quite a bit of ASP code in the examples. What I would like is to show this code, in HTML, using pretty color farmatting techniques.
Things like comments in green, keywords in blue, operators in red, the kind of color formatting that text editors have. Does anybody know of any tools which can take ASP code as plain text and produce color formatted HTML output?
I know php has some nice color-code formatting, where it will show the file in nice colors
(highlight_source..)
An example of what I am talking about is located here:
http://dev.zaireweb.com/source.php?source.php
Is there a way to do this in ASP
I know the basic 8, how do i find any others besides those 8? do you use hex codes? should also note that i need to be able to match the vbcolor to a hex color.
View Replies View RelatedI load data from dtb and would be nice to have different color for loaded colors, e.g. blue and light blue. I don�t know how to make it. Here is my code which loads data from dtb: Code:
View Replies View RelatedAnyone have code for a color chart. Specifically a chart that when clicked passes the hex value through querystring or a form. I could make one, but I'm just feeling lazy today.
View Replies View Relatedhow do i do it? I have new images in different colors how do I set up a theme picker?
View Replies View Relatedhow to change the background color of a web form programatically from C#. I have found examples on the web for Visual Basic, but I can't get them to work in C#.
View Replies View Relatedi would like to display the records in red color for the paid member.and blue color for free member.using database. i m not geeting the correct.
[code]
<% If membership='paid' Then%>
<font color="red"><%RS(Product_name)%></font>
<%else%>
<font color="Blue"><%RS(Product_name)%></font>
<%end if%>
[code]