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 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'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 ?
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?
One 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?
Static.htm Contains a form with two text boxes, called text_1 and text_2 and some other info that is irrelevant for my question.
Dynamic.asp Need some code to check that the text boxes only contain values greater than 0 and only numbers. Thus if any of the textboxes for example contain -3 or the letter m I want to cancel the form submission and display some kind of error message.
I have two textboxes, nett, vat and gross value.Nett and vat are entered manually, is there a way to say, when nett textbox lostfocus or vat lostfocus then add the two and show the value in the gross value textbox WITHOUT calling the page again as i would have to do in vbscript?
When I retrieve this data into standard text boxes (using ASP/ADO) so that the user can update/file the following problems occur on what I would call price fields:
10 << I want 10.00
11.6 << I want 11.60
12.89 << this is fine
My MySQL DB holds prices as decimal(10,3) so I know the decimal data isn't chopped at this point.
Before the data is displayed in these boxes I created the below function to parse the data before it is written to the boxes: Code:
All of a sudden about 50% of my textboxes are yellow (as opposed to theusual white color). It started when I started on an ASP project, but this could have been coincidental. I have noticed that it shows yellow textboxes on many other webpages.
The input forms are created using FORMMANGER of MS Visual Interdev 6.0(ASP Code). The forms containing textboxes and bottons (with disable property) are shown correctly in IE5. But when same forms are viewed in IE6 the disabled textboxes and buttons are shown distorted.
Ho can i loop through textboxes and then collect the data filled into them.I've done one for checkboxes but can't get my head around doing the one for textboxes.
i need to get the values from the stored procedure below, basically the Name, Description, and is Active values and display them in two textboxes and a checkbox. How can i do this? Or can it be done with this stored procedure? I havent been able to find any good examples on the web... Code:
I’ve a few radio buttons; few of them have input textboxes and dropdown list. I use Select case to insert values (depend on which radio button that you've selected) into the sql db but it doesn’t work. Then I use if, elseif and else…the value of radio still doesn’t insert into the DB. In this case how can we insert the value(s) into the DB? Code:
Has anyone ever tried this? Customer insists on having web form to post to existing excel spreadsheet. My colleague agreed to do this and then got stuck and passed it to me .
I would have advised them to use a database myself...
What is the best way to do this? I am trying to post to the spreadsheet and keep getting errors. Once I had made sure that the formats of all fields etc matched what was being posted I then got a message saying that one or more required parameters was missing; but I was posting 19 data items to 19 columns, so no idea where to go next.
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?
i am unable to figure out some way....so pls if anyone has implemented then do suggest me. i need to have a link on clickign to which i want excel workbook to open (a previously created template) below the link in the form.
how can i do it. i find lot of info on opening excel as an application freshly. i want to open in the form itself. is it feasible or i am just wasting my time searching info for it.
I'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?
I 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 want 2 create a survey Web Form that people can fill in. I then want the data entered to be saved to an Excel spreadsheet located on a server.
Can .ASP handle this kind of task? and if so does anyone know the code required to perform this function?
The data entered will be RAW and the .ASP (or whatever required programming) will need 2 process and convert the data into the spreadsheet.
Also, would it be possible to run this from a stand alone machine so that the web form, .ASP and spreadsheet are all contained on the machine and have no outside influences?
I´m having a problem using ASP Upload with an insert form..
If I use ENCTYPE="multipart/form-data" the all the parametres i might get with request.form don´t appear.. but i can upload the files.. Besides if I take away the ENCTYPE tag, i can´t upload but the INSERT INTO form works propertly
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
I have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems.
Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....".
I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code:
