ASP Read The Execl Cell's Data, Web Page Created From Excel2000 -- Save As Web Page
I created a web page from Excel2000, using "Save as web page..."...Publish
function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button.
How can get the data on the excel file using ASP from server side?
For example, the value of Cell(1,2), Cell(2,3)....
I run a website that reads our own databases and makes the data available to our users. However, recently someone has sent me a link to a php page that contains data they want me to display on our site. The php creates a csv formatted text string.
Example : I type in www.somewebsite.php and the page returns game1,gamedate,gametime,hometeam,visitor,,,, with real values of course being in these values. the ,,, are null fields that have no value as they expect our website to fill in this data for them from our users. how do I read this data with asp into a recordset, or a database?
I am working with a developer, on two portions to a site, he is working in PHP and my work is done in ASP.
Is it possible for my pages to request data from a cookie that was written by his pages that are PHP but residing on the same server? Just want to make sure before I spend too much time planning out the development on my end.
My company needs an online form that user's can enter information into and once submitted, will dump the user-supplied info into a csv file and email it to the person who heads up the project. Initially, I thought they wanted the form to save the data to a database, and after playing all weekend, I was able to do that. Today I learned that they prefer the emailing a csv file method instead. Any links to tutorials on this subject or sample code with explanation would be greatly appreciated!
how do i get data from a user on one page and display the result on the other page actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
I would like to save a web page to a file. When I do that, sometimes the saved web page does not look like the original web page. For example, when I save www.msn.com, it looks very different the original page. How can I save the web page to look like the original (as if I do "File" - "Save As" and under "Save as Type" select "Web Page, complete (*.htm,*.html)" ? This is how I save the web page: Set fs = CreateObject("Scripting.FileSystemObject") Set filePtr = fs.CreateTextFile("c:abc.htm", True) filePtr.WriteLine (WebBrowser1.Document.body.innerHTML)
I have a form.htm page where the user enters an ID to retrieve addresses. Then PAGE1.ASP displays the addresses. From here the user selects an address and submits. Then PAGE3.ASP brings back further information. My question is how do I use one field from the address information on PAGE2.ASP to display on PAGE3.ASP? I know how to do it with textboxs and such but cant get RS data to hope page to page. I get no errors or anthing.
On PAGE2.ASP I have : <input type="hidden" name="CLIENTHIDDEN" value="<%=RS1("CICL_LNG_NM") %>"></td>
On PAGE3.ASP I have: clientname = request.form("CLIENTHIDDEN")
and to display: <td class=rt width="110" height="1">Business Name:</td><td width="849" class=rt height="1"><% =clientname%></td>
is there an easy way to save the current page in asp through code. for example if I dynamically created a page and then wanted to save it without requiring the user to do anything.
I want to be able to save a file created by an asp file somewhere. Or even email the file if possible. I've searched google extensively and only found people with the same problem but no answer. He solved the problem but didnt post the solution.
I am building a link exchange system - It works but I have to validate each recipricol link individually. I want to modify it so that it can read a web page and determine whether the website has added a recipricol link to my site before I add theirs.
What is the appropriate control or code to pop a "save as" dialog window to allow the user of a web page to save a document after they click on a link? All of the CommonDialog controls obviously are to be used on WinForms, so not sure how to accomplish this from an aspx page.
I have an ASP site where the majority of the site style is set in CSS but certain aspects such as font and background colors for sections is set by the user in a web page, with the data being pulled from an Access database.
It should be noted that the site is an open source forum and the user mentioned above is the admin for the site - so this only means limited access to this functionality but allows the admin to customise their forum for their users easily, whilst keeping them from the more crucial aspects of the CSS which afect table layouts etc.
The question has been asked - is it possible to not have to split the CSS like this (some in Db some in CSS sheet) and instead include it all in a style sheet?
I guess what I am asking is - is it possible to read and write to the style sheet from ASP, and if so how would you identify each CSS ID or Class?
let say the addres is not exist, but the web server will auto redirect the page to a user customize page, and the object track the page as 200. Is there any way to track the error even the page is redirect to a 404 page ?
What I need to do is use asp to read the contents of a web page (that is generated on another server), put the html in to a sting, and then take action based on the contents of the string. I can probably do all of the sring manipulation myself, but want to know if I can open the page and read the first 200 characters in to a variable that I can then manipulate.
I'm no ASP/VBScript guru, but I need to read a page from another domain, extract some information, and format it inside one of our own pages at the office.Just to make one thing clear: I'm not ripping off someone else's page. The external site handles employment ads, and we're supposed to include our own ads from there.
Frames or iframes are out of the question, since we use HTML 4.01 Strict. The markup on the external page is horrible (layout tables, presentational markup, etc.). I want to read the external page into a string, and then extract the actual ad information and format that on our page. This would be very easy in PHP, using fopen(), and I assume there is something similar for ASP/VBScript.
I have a csv file that has 2 columns - Name and Team. I want to display both of these on a page in seperate dropdown boxes..Ideally I would then like to have an option where the user of the page can click a button to change which team an employee is a part off, in effect overwriting that line of data but not deleting everything else in the file
The code below lets me see each column from the csv file on a page in a separate dropdown box but I don't think I have the logic right to do what I need..I've checked Google and w3schools but I must not be searching for the correct thing as I can't find a way to do this... Code:
I am in the process of developing an application and would like to hide the query strings in the URLs. I want to POST data to a page then validate the data. If there is an error I have to send data back via a long query string. Is there anyway to POST data between pages programmatically?
i have a page that i need to load in an iframe that is on a diff domain (sub domain), i need to get the doc height of the page so that i can adjust the iframes height (so there will be no scroll bars).the problem with that is even though its on the same sever, because it is on a subdomain the browser sees it as different and restricts access to it (makes sense).
so, what we can do is have php read in the page with curl and parse it out in the iframe. that looks like <iframe src="reader.php?page=subdomain.pagename.html">but, we cannot use php on this server so i was wondering if there is an asp solution that can do the same thing (vb script). basically, i just need that asp page to grab the page on the sub domain, read it in and then output it.
Is it possible to do the following in asp: To read an html page from a server (not mine) every 5 minutes and copy it to my server. The html page just contains a list of numbers.
i have a page which displays a list of events searched for by a particular date. we usually have a lot of events and i don't want the user to have scroll through all of them, especially if they're interested in a particular type of event.
i have created a dynamic drop down menu which consists of all the event types. how can i got about displaying the events returned by the query to a specific event for that date.
so for example, if some one searches for 03/08/2005, they will initially get a list of all events for that day. if they click on "Closed" from the drop down menu, it will display all the "Closed" events for 03/08/2005.
I am working on my intranet reporting web site, by use of IIS5 + Office2000 +SQL2000. Currently, the first step, I show user an ASP web-interface to collect user input, keyword etc.,use "<Form name=xxxx Action=MyAction.ASP method=post>........</Form>" then these user input values will be submit to action page to run reports for user. My problem is, sometimes user needs to input lots of different set of keyword, which are prepared in his own execel2000 worksheet. Can I use an Excel2000 file instead of asp page to collect user input and send to the action page MyAction.asp? Sine excel2000 can support copy/paste on more cells/columns, better that web <Form....> control. I am thinking anther way is: How can I bound a Grid control( like data-grid in VB6) in asp page, then user can copy and paste data to it with more than one columns and rows?
I need to read a SQL Server table into a Web Page and within the Web Page to permit my users to make changes to the records, delete or add new records and then save the entire contents back to the SQL Server table back.
The functionality I am looking is almost the same as In the SQL Enterprise Manager whereby I can choose a table open the table and then return all rows and I can maintain the same and save it back to the SQL Server table. I want almost a similar web interface to such a functionality.
Even if not a generic functionality as the SQL Enterprise Manager table maintenance appreciate if somebody can share the code with a sample how I can do it in ASP pages + T-SQL if need be.
I would like the value of the textfield from text1 from Select_License.asp to be transfered to swname from License_add.asp when i click on the Next button from Select_License.asp
I'd like to display XML data in a table in an ASP page. Seems like XSL and XML don't like that because ASP commands within the document cause the page to not be "well-formed"...
anybody know how to do what I want to do? Point me to a good online tutorial...i'll be looking too in the meantime.
OK this query if probably fairly elementary, and forgive my novice understanding of the terminology, I have dealt a little with php but .asp is relatively new to me.
I am able to store variables posted from a form using something along the lines of
strStartDay = Request.Form("StartDay")
however this only works for the .asp page that immediately results from the form. how do I then pass these same values(entered from the form) into an asp page that follows (link from the first asp page).
In my ignorance I have placed the same variable statements in my second asp page but no values are being returned (which of course they wouldnt).