|
|
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 = "D:\Test.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
|
|
|
|
|
|
|
|
kailash.rathi
