|
Hi,
I want to store the data from Radio Options submitted by user to Excel.
I have a Java script for the Poll which gives Poll in HTMl can I transfer the data to Excel or other file .
I Dont have any Database.
I can also make the Radio Buttons form in HTMl instead of above mentioned .JS but as I donthave any database please tell me is it possible to transfer data to Excel file or other file (txt etc).
If yes, tell me the coding. I think it will be something in ACTION=""
Thanks
Kailash
|
|
|
Hi kailash.rathi,
I tried the following codes. Its working for me. Similar logic you suppose to try for radio button also. Please find my sample code below,
<HTML>
<HEAD><TITLE>Exporting into Excel</TITLE></HEAD>
<SCRIPT Language = "VBScript">
Function Export(P,R)
Set ExcelApp = CreateObject("Excel.application")
ExcelApp.Visible = True
strPathDoc = "/forum/DTest.xls" 'Your File path
Set myExcelDoc = ExcelApp.Workbooks.Open(strPathDoc)
ExcelApp.Visible = True
myExcelDoc.Windows(1).Visible = True
set XlSheet = myExcelDoc.Worksheets(2)
XlSheet.Range("A6").value=P
XlSheet.Range("A7").value=R
myExcelDoc.save
myExcelDoc.close
Set myExcelDoc = Nothing
Set ExcelApp = Nothing
End Function
Sub cmdExp_OnClick()
Dim lPrincipal
Dim dblRate
Frstnm = Disnm.value
Lstnm = TreatGrp.value
cInterest = Export(Frstnm, Lstnm)
End Sub
</SCRIPT>
<BODY>
<BR>
First Name: <INPUT Type="Text" Name="Disnm" Value=""><BR>
Last Name : <INPUT Type="Text" Name="TreatGrp" Value=""><BR>
<INPUT Type="Button" Name="cmdExp" Value="Connect">
</BODY>
</HTML>
Warm Regards,
GG
|
|
|
Sir,
Thank you so much for your valuable source code which helped me in my project.In your code previous data is replaced with the newer data,but sir if I want to append data in the same excel sheet how i will do it?Please help me with your innovative source code.
Thank you in advance.
|
|
|
Appending data obtained from Html in an excel sheet
--------------------------------------------------------------------------------
this is wat i want
i hve html page...one text box where u can enter data
wen u click button ..dataa should be moved to a excel sheet
again if u give one more data in html that shud be appended in excel
append n not replace !!
Im attaching my html file in text format...i m not getting it ..can u plz try
|
|
|
Hi,
I used the same code and create the excel file in d drive. when i entered the data in text box and click on connect the i am getting nothing in my excel file. Can you please correct me?
Below are the code.
<HTML>
<HEAD><TITLE>Exporting into Excel</TITLE></HEAD>
<SCRIPT Language = "VBScript">
Function Export(P,R)
Set ExcelApp = CreateObject("Excel.application")
ExcelApp.Visible = True
strPathDoc = "/forum/Datul.xls" 'Your File path
Set myExcelDoc = ExcelApp.Workbooks.Open(strPathDoc)
ExcelApp.Visible = True
myExcelDoc.Windows(1).Visible = True
set XlSheet = myExcelDoc.Worksheets(2)
XlSheet.Range("A6").value=P
XlSheet.Range("A7").value=R
myExcelDoc.save
myExcelDoc.close
Set myExcelDoc = Nothing
Set ExcelApp = Nothing
End Function
Sub cmdExp_OnClick()
Dim lPrincipal
Dim dblRate
Frstnm = Disnm.value
Lstnm = TreatGrp.value
cInterest = Export(Frstnm, Lstnm)
End Sub
</SCRIPT>
<BODY>
<BR>
First Name: <INPUT Type="Text" Name="Disnm" Value=""><BR>
Last Name : <INPUT Type="Text" Name="TreatGrp" Value=""><BR>
<INPUT Type="Button" Name="cmdExp" Value="Connect">
</BODY>
</HTML>
|
|
|
<p><a href="http://www.supratksocietyshoesoutlet.com/">Online Supra Sneaker Outlet</a>, Factory Direct!You will find that low price and top quality <a href="http://www.supratksocietyshoesoutlet.com/">Supra Footwear cheap sale</a> for people to choose from. Get best service by every purchase of Supra Footwear. <a href="http://www.supratksocietyshoesoutlet.com/">www.supratksocietyshoesoutlet.com</a> has the latest information about <a href="http://www.supratksocietyshoesoutlet.com/">Justin Bieber Shoes</a>. More information about <a href="http://www.supratksocietyshoesoutlet.com/">Justin Bieber Supra Shoes</a> including release dates and prices. Thanks for your attention on our store.
Find your favorite styles from our large collection of <a href="http://www.supratksocietyshoesoutlet.com/">Supra Footwear</a>,<a href="http://www.supratksocietyshoesoutlet.com">Supra Shoes UK</a> and more!Top quality <a href="http://www.supratksocietyshoesoutlet.com/">Supra Society Mid Shoes</a> are hot sale now,welcome to our <a href="http://www.supratksocietyshoesoutlet.com/">Supra Shoes Store</a> the more surprise waitting for your such as high quality,fast shipping and 46% OFF!
<p>This <a href="http://www.supratksocietyshoesoutlet.com/men-supra-society-mid-shoes-c-15/">Men Supra Society Mid Shoes</a> is the most fashion style this season.The <a href="http://www.supratksocietyshoesoutlet.com/">supra store</a> is a good choose,and became a bright point for this Supra Shoe.<a href="http://www.supratksocietyshoesoutlet.com/men-supra-skytop-shoes-c-4/">Men Supra Skytop Shoes Discount</a>,We stock various <a href="http://www.supratksocietyshoesoutlet.com/">Cheap Supra Skyop Shoes</a> with top quality and cheapest price.Your complete satisfaction is our top priority for long term business between us.Our shop is your best choice to buy <a href="http://www.supratksocietyshoesoutlet.com/">Supra Skytop</a>.All shoes are packaged with original tags,fast mailing to your door.Welcome to choose one!</p>
<p>Best <a href="http://www.supratksocietyshoesoutlet.com/">Supra shoes online</a> retailer here!Many fashion justin bieber shoes just design for you.High quality <a href="http://www.supratksocietyshoesoutlet.com/kid-supra-skytop-shoes-c-11/">discount Kid Supra Skytop Shoes Sale Online</a> at low prices.</p>
<p><a href="http://www.supratksocietyshoesoutlet.com/2012-new-supra-tk-society-c-2/">2012 New Supra TK Society</a>
<a href="http://www.supratksocietyshoesoutlet.com/justin-bieber-shoes-c-1/">Justin Bieber Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/men-supra-skytop-shoes-c-4/">Men Supra Skytop Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/men-supra-skytop-iii-shoes-c-7/">Men Supra Skytop III Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/men-supra-tk-society-shoes-c-3/">Men Supra TK Society Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/men-supra-vaider-shoes-c-9/">Men Supra Vaider Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/women-supra-skytop-shoes-c-6/">Women Supra Skytop Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/women-supra-skytop-iii-shoes-c-8/">Women Supra Skytop III Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/women-supra-tk-society-shoes-c-5/">Women Supra TK Society Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/women-supra-vaider-shoes-c-10/">Women Supra Vaider Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/kid-supra-skytop-shoes-c-11/">Kid Supra Skytop Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/kid-supra-tk-society-c-12/">Kid Supra TK Society</a>
<a href="http://www.supratksocietyshoesoutlet.com/supra-pilot-shoes-c-13/">Supra Pilot Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/supra-cuttler-ns-shoes-c-14/"></a>
<a href="http://www.supratksocietyshoesoutlet.com/men-supra-society-mid-shoes-c-15/">Men Supra Society Mid Shoes</a>
<a href="http://www.supratksocietyshoesoutlet.com/women-supra-society-mid-shoes-c-16/">Women Supra Society Mid Shoes</a>
<p><a href="http://www.supratksocietyshoesoutlet.com/2012-supra-skytop-black-grey-orange-shoes-p391.html">2012 Supra Skytop Black Grey Orange Shoes</a> <a href="http://www.supratksocietyshoesoutlet.com/2012-supra-skytop-black-grey-purple-shoes-p392.html">2012 Supra Skytop Black Grey Purple Shoes</a> <a href="http://www.supratksocietyshoesoutlet.com/2012-supra-skytop-black-red-sneaker-p393.html">2012 Supra Skytop Black Red Sneaker</a> <a href="http://www.supratksocietyshoesoutlet.com/2012-supra-skytop-black-white-green-black-p394.html">2012 Supra Skytop Black White Green Black</a> <a href="http://www.supratksocietyshoesoutlet.com/2012-supra-skytop-black-white-snowflake-shoes-p395.html">2012 Supra Skytop Black White Snowflake Shoes</a> <a href="http://www.supratksocietyshoesoutlet.com/2012-supra-skytop-blue-snowflake-shoes-p396.html">2012 Supra Skytop Blue Snowflake Shoes</a> <a href="http://www.supratksocietyshoesoutlet.com/2012-supra-skytop-grey-black-snowflake-shoes-p397.html">2012 Supra Skytop Grey Black Snowflake Shoes</a> <a href="http://www.supratksocietyshoesoutlet.com/2012-supra-skytop-grey-snowflake-shoes-p398.html">2012 Supra Skytop Grey Snowflake Shoes</a> <a href="http://www.supratksocietyshoesoutlet.com/2012-supra-skytop-white-black-snowflake-shoes-p399.html">2012 Supra Skytop White Black Snowflake Shoes</a> <a href="http://www.supratksocietyshoesoutlet.com/2012-supra-skytop-white-orange-snowflake-shoes-p400.html">2012 Supra Skytop White Orange Snowflake Shoes</a>
|
|
|
[url=http://www.nikeshoesdiscountsale.com/]www.nikeshoesdiscountsale.com[/url] is a [url=http://www.nikeshoesdiscountsale.com/]Cheap Nike Free Shoes Online Shop[/url] And [url=http://www.nikeshoesdiscountsale.com/]Nike Air Jordan Shoes Outlet Sale Online[/url],All Orders Save 50% Discounts. Welcome To Visit Our [url=http://www.nikeshoesdiscountsale.com/]Nike Sporting Shoes Online Shop[/url]. 100% satisfaction and guarantee!You can find many surprise here at our online world. Please do not hesitate to shake hands with us and go with the tide as soon as possible.
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-2012-new-nike-free-50-c-1_56/]2012 New Nike Free 5.0 Running Shoes on Sale[/url], new latest cool summer [url=http://www.nikeshoesdiscountsale.com/]Nike Running Shoes Cheap[/url] price,lowest price,shop now!Buy more than 2 pairs save more!
Nike's natural motion technology focused in a great low flexible shoe to promote stronger feet which can reduce injury and improve performance.The [url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-run-2-c-1_49/]Nike Free Run+ 2[/url] is even more flexible and Free like than the [url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-50-c-1_46/]Nike Free 5.0[/url].The [url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-run-c-1_48/]Nike Free Run+[/url] is more cushioned and supportive than the [url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-30-v2-c-1_42/]Nike Free 3.0[/url].
A2 In addition,[url=http://www.nikeshoesdiscountsale.com/]Nike Jordan Basketball Shoes[/url] the CP3 logo adorns the top of the shoe's tongue. And of course to finish nike zoom kobe vi womensthe look, a Jumpman logo is placed on the outer side [url=http://www.nikeshoesdiscountsale.com/]Discount Air Jordan 6 for Sale[/url] panels of the shoes. The first CP 2Quick will drop [url=http://www.nikeshoesdiscountsale.com/]air jordan 11[/url] og concordin September of 2011. It will be the first of many colorways Air jordan 11 size 13 Jordan Brand plans to release.The first two color ways [url=http://www.nikeshoesdiscountsale.com/]jordan 3 for sale[/url] to drop will be an all black edition followed bay all white with red accents edition.
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-2012-new-nike-free-50-c-1_56/]2012 New Nike Free 5.0[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-30-v2-c-1_42/]Nike Free 3.0 V2[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-30-v3-c-1_45/]Nike Free 3.0 V3[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-40-v2-c-1_5/]Nike Free 4.0 V2[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-50-c-1_46/]Nike Free 5.0[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-70-c-1_47/]Nike Free 7.0[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-run-c-1_48/]Nike Free Run+[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-run-2-c-1_49/]Nike Free Run+ 2[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-run-3-c-1_50/]Nike Free Run+ 3[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-nike-free-tr-fit-c-1_51/]Nike Free Tr Fit[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-jordan-men-shoes-c-1_43/]Jordan Men Shoes[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-jordan-women-shoes-c-1_44/]Jordan Women Shoes[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-jordan-shoes-2011-c-1_54/]Jordan Shoes 2011[/url]
[url=http://www.nikeshoesdiscountsale.com/nike-free-shoes-jordan-shoes-2012-c-1_55/]Jordan Shoes 2012[/url]
[url=http://www.nikeshoesdiscountsale.com/jordan-men-shoes-nike-air-jordan-1-c-1_43_52/]Nike Air Jordan 1[/url]
[url=http://www.nikeshoesdiscountsale.com/jordan-men-shoes-nike-air-jordan-2-c-1_43_53/]Nike Air Jordan 2[/url]
[url=http://www.nikeshoesdiscountsale.com/jordan-men-shoes-nike-air-jordan-9-c-1_43_60/]Nike Air Jordan 9[/url]
[url=http://www.nikeshoesdiscountsale.com/jordan-men-shoes-nike-air-jordan-12-c-1_43_61/]Nike Air Jordan 12[/url]
|
|
|
this is wat i want
i hve html page...one text box where u can enter data
wen u click button ..dataa should be moved to a excel sheet
again if u give one more data in html that shud be appended in excel
append n not replace !!
Im attaching my html file in text format...i m not getting it ..can u plz try
<html>
<body>
<link rel="stylesheet" type="text/css" href="/forum/s.css">
<body background bgcolor="#E6E6FA">
<font color=blue>
<font size="5px">
<h><div><marquee bgcolor="green" scrollamount="4" direction="left"<MARQUEE BEHAVIOR=ALTERNATE> >>> For E-Material Log in here <<<</h></marquee> </div></br>
User name: <input type="text" name="username"><br>
Pass word: <input type="password" name="pwd"><br>
<input type="checkbox" name="rember me" onclick="alert('Do you Want to rember the Password')" >rember me <br>
<input type="button" width="150" height="50" value="Submit" onclick="window.open('submit.html')" /><br>
</body>
</html>
|
|
|
THe user name and password has to be stored in excel file
|
|
|