473,581 Members | 6,775 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

spilt and write in excel

1 New Member
I need read particular data grid from html page and spilt it to write in the excel (writing excel sheet adding data in different cells)using vba
Jun 29 '12 #1
5 15148
Rabbit
12,516 Recognized Expert Moderator MVP
What do you have so far?
Jun 29 '12 #2
Guido Geurs
767 Recognized Expert Contributor
Is it possible to attach in Bytes the HTML data so we can see the structure?
If the data is confidential, please replace it with recemblant but harmless data.
Can you also give an example how you want the data in the Excel sheet?
Jun 30 '12 #3
Guido Geurs
767 Recognized Expert Contributor
In this call "Looping Marco thur url" from Sandy Armstrong we capture data from URLs of hospitals.
You can import the tables and split them in sheets.
If you want more help, please send us more details of the URLs and the sheet you want to use.
Jul 2 '12 #4
Killer42
8,435 Recognized Expert Expert
Was there meant to be a link in that last reply?
Jul 3 '12 #5
Guido Geurs
767 Recognized Expert Contributor
Sorry, my mistake.
This is the link:
http://bytes.com/topic/visual-basic/...marco-thur-url
Jul 3 '12 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
2173
by: jack | last post by:
Access is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Access is denied. ASP.NET is not authorized to access the requested...
4
1948
by: Bradley | last post by:
I'd like to read in an Excel based xls template, add data to specific cells then write the information out to a different filename. In addition to a request for some sample code, I have the following questions that I hope somebody can help me with: 1) Do all versions of excel export an interface? I'm using Excel 2002 2) Do I need to require...
0
1489
by: Klaus Urban | last post by:
Hi all, How would you read and write XMLSS files in VB.NET? I'm developing a Windows Forms Application and want to export data from datasets. Need a bit more Spreadsheet formatting than just writing the dataset to XML. My first approach is to create a new XMLDocument and manually add the attributes and child nodes. But i'm not very...
3
7195
by: tkpmep | last post by:
I downloaded PyExcelerator.zip as I need to write some data into Excel files, and tried unsuccessfully to install it. I unzipped the files into C:/Python24/Lib/site-packages/PyExcelerator, and in a python command line window typed >>>os.chdir("C:/Python24/Lib/site-packages/PyExcelerator") followed by >>>python ./setup.py install
0
1045
by: Berger | last post by:
Hello I generate and fill an excel sheet with oledb. My problem is that I have to write more than 255 chars but I can´t find an datatype which I can use. I have tried datatype char,text,memo all witm max 255 chars:( Exist another datatype which I can use? thx for help Björn
1
1621
by: neehakale | last post by:
can anybody of u know basic steps of reading and writting excel files in c#.net.Which class or namspace we have to use here like we use system.IO for reading and writting to text files...
6
12358
by: =?Utf-8?B?LnBhdWwu?= | last post by:
how can i write to an excel .xls file using odbc? i've read in several places that its possible but i can't find an example. i have managed to read an excel file using odbc
5
5692
by: CF FAN | last post by:
Hi Is it possible to read an Excel file using coldfusion then wrile that content to another excel sheet with different format?Is any one can help me?
7
12057
by: TG | last post by:
hi! I am trying to create a sql server table from an excel sheet. Here is the code I have: 'This procedure the xlsx file and dumps it to a table in SQL Server
8
28344
blazedaces
by: blazedaces | last post by:
So I have a program below which writes an excel file with multiple sheets based on inputs of sheet names, data, cell types, etc. It uses Apache POI, which is currently the only thing I found (correct me if I'm wrong about this) that can write excel 2007 files. The program works. I've tested it out on very small files (I will include the...
0
7854
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7783
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8296
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7880
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8157
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5665
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3807
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2295
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1119
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.