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)....
View Replies
ADVERTISEMENT
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?
View Replies
View Related
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.
View Replies
View Related
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!
View Replies
View Related
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:
View Replies
View Related
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:
View Replies
View Related
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)
View Replies
View Related
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>
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
Can anyone recommend how to do a screen scrape from a dynamic page and save it to a text file?
View Replies
View Related
i want to force the web page address to be saved in browser history using asp vbscript.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
here is my code:
set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP")
objXMLHTTP.open "GET", "http://www.xxx.com/index22.asp", false
objXMLHTTP.send ""
intStatus = objXMLHTTP.status
response.Write(intStatus)
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 ?
View Replies
View Related
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.
View Replies
View Related
I've just re-installed my PC with IIS (WinXP w/ service pack2) and now when I try to access or write data to any .asp site locally I get this error.
'Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
i want to read an HTML page in ASP n i m not able to do so.
View Replies
View Related
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.
View Replies
View Related
I have a dB with several tables, in my page the visitor should have to choose which table in the dB should be selected. here is my code:
View Replies
View Related
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.
View Replies
View Related
is it possible to read the content of a db[ms sql] field and save the content as a file[e.g: .bmp]
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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
<html>
<head>
</head>
<body>
<form name="form1" method="post" action="">
<P>
Software: <INPUT name=text1 >
<input type="submit" name="Submit" value="Find">
<%
on error goto 0
If Request.Form("Submit") = "Find" Then
description = Request.Form("text1") .....
View Replies
View Related
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.
View Replies
View Related
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).
View Replies
View Related
I have a page with 4 submit buttons. How can I make 1 of these buttons spawn a new page AND use the data posted from the orginal page?
View Replies
View Related