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
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
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:
Jul 3 '12 #6

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

Similar topics

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...
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...
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...
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
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
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...
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
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?
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
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...
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...
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...
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...
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...
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...
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...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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
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.