473,320 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Storing data from HTML to Excel

i hve html page...one text box where u can enter data

wen u click button ..data should be moved to a excel sheet

again if u give one more data in html that shud be appended in excel

append and not replace !!

below is the my html file in ...i m not getting it ..can u plz try

----------------------------------------------------------

Expand|Select|Wrap|Line Numbers
  1. <HTML> <HEAD><TITLE>Exporting into Excel</TITLE></HEAD> <SCRIPT Language = "VBScript">
  2.  
  3. Function Export(P,R)
  4.  
  5. Set ExcelApp = CreateObject("Excel.application")
  6. ExcelApp.Visible = True
  7. strPathDoc = "D:\atul.xls" 'Your File path
  8. Set myExcelDoc = ExcelApp.Workbooks.Open(strPathDoc)
  9. ExcelApp.Visible = True
  10. myExcelDoc.Windows(1).Visible = True
  11. set XlSheet = myExcelDoc.Worksheets(2)
  12. XlSheet.Range("A6").value=P
  13. XlSheet.Range("A7").value=R
  14. myExcelDoc.save
  15. myExcelDoc.close
  16. Set myExcelDoc = Nothing
  17. Set ExcelApp = Nothing
  18. End Function
  19.  
  20. Sub cmdExp_OnClick()
  21. Dim lPrincipal 
  22. Dim dblRate 
  23.  
  24. Frstnm = Disnm.value
  25. Lstnm = TreatGrp.value
  26. cInterest = Export(Frstnm, Lstnm)
  27.  
  28. End Sub
  29.  
  30.  
  31. </SCRIPT> <BODY> <BR>
  32. First Name: <INPUT Type="Text" Name="Disnm" Value=""><BR>
  33. Last Name : <INPUT Type="Text" Name="TreatGrp" Value=""><BR> <INPUT Type="Button" Name="cmdExp" Value="Connect"> </BODY> </HTML> 
-----------------------------------------------------------
Aug 20 '13 #1
0 1765

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Jonny | last post by:
Hello, I have created a button on my form which when pressed does the following : 1) Run a pre-defined Macro, which is picking up a query and running my data to excel. However, I need the...
7
by: Vanessa | last post by:
hi Everyone, I have two questions on exporting data to Excel using ASP (w/o converting formatted excel file into web page and then plug in the dynamic data): 1. Can we export data into...
3
by: balazee | last post by:
Hi, I’ve some data in an excel sheet which needs to be displayed in an html page as lists. For example, In the excel I’ve the below details like, the application name and the path where the...
6
by: nairda | last post by:
Hi there, I need help processing data from Excel in VB. I have a MSHFlexgrid to show data extracted from Excel. I'm able to show a range of cells from Excel table to my Flexgrid, but that's it. The...
1
by: syam217 | last post by:
Please help me out in reading data from Excel file and storing it in SQL Server 2000 database. Its very urgent. Thanks in advance.
4
by: Falcolas | last post by:
I personally feel that it's a bad idea. I've got to convince managerial types of this. Would some of you mind posting comments for and against the concept of storing data in XML attributes? If...
2
by: defabiisk | last post by:
Hello, I'm trying to open some data I've collected in my Perl DBI script - in excel. I'm using Javascript function to try and open the data in execl - without trying to do a SaveAs first. So I...
2
by: Dhananjay | last post by:
Hi all , I have got problem when i am tring to exportGridview Data into Excel format. It is going into text format ,but what i want is if the field is number/currency then it should go into...
8
by: rshin2020 | last post by:
I have a script as below. I need to display the data in excel. This is in C#.net. Right now, the data only displays up till B5 and C5. How do I make it display till B8 and C8. The values for symbol...
4
by: lenniekuah | last post by:
Hi Good Guys I need your help. Please help me. I have asked to migrate VBNET2008 to C#Net2008 version of extracting data from Excel to fill DataGridView. I tried to convert it and here are the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.