i am trying to parse an excel file. its structure is very complex. The possible way i know are.
Use Office introp libraries
Use OLEDB provider and read excel file in a dataset.
But the issue is of its complexity like some columns,cells or rows blank etc. What are the best possible ways to do this?
Excel returns a reference of the form
=Sheet1!R14C1R22C71junk
("junk" won't normally be there, but I want to be sure that there's no extraneous text.)I would like to 'split' this into a VB array, where
a(0)="Sheet1"
a(1)="14"
a(2)="1"
[code]....
I'm sure it can be done easily with a regular expression, but I just can't get the hang of it.
I would like to be able to parse vb.net code files, so I can examine the collection of Subs, Functions (and their contents, including comments), private variables, etc. I can be open the actual source code files. So for example, if I have:
[Code]....
I have browsed through many posts on this and have tried some of the suggestions but still not understanding it fully. I would like to scrape html pages that have some script running that usually executes the script to display a link after clicking. Some mentioned firebug and others talked about reverse engineering the code I need. But after trying reverse engineering I still dont see how to get the data after tracing the script function.[code]I am using vb.net and some sites were easy using firebug where looking at the script I was able to pull the data that I needed. What woudl I do in this scenario? the link is url... and the categories are what I am trying to access. Notice the url does not change.
View 1 Repliesi need to scrape a p tag which has h3 tag after it but does not have a closing p tag. It looks like this :
<script ad>asdasdasd</script>
<p>Translation companies are
-----------------------
-----------------------
<h3 class="this_class">mind blown site</h3>
There is no </p> tag so i cannot parse it completely. Now i have two questions :
1) can this be parsed using httpagility xpath ?
2) i have a function to find text between two strings (getbetween). But i have a doubt - If i use "asdasdasd" and " is it always 100% that vb.net will use the script tag which is just above h3 because there are 2-3 same lines - "asdasdasd"
I have a windows forms application that scrapes a website to retrieve some data. I would like to implement the same functionality as a windows service. The reason for this is to allow the program to run 24/7 without having a user signed in.
To that end, my current version of the program uses a web browser control (system.windows.forms.webbrowser) to navigate the pages, click the buttons, allow scripts to do their thing, etc. I cannot figure out a way to do the same without the web browser control, but the web browser control cannot be instantiated in a windows service (because there is no user interface in a web service).
I was amazed with how little documentation or examples are out there for checking the pagerank for a website using vb.net . I was hoping that someone might have some example code or other resources regarding how to do this (using toolbarqueries.google.com - not by scraping data from a 3rd party website).
View 3 Repliesworking on some code that will screen scrape a site then fine some code in there and pull it out for me...but for some reason i cant find the right regular expression. Anyone can with creating a regular expression that will match
/clipmark/C51BC80B-173F-4BC7-B630-CCDB8B56C9DF/
Have tried multiple attempts of writing it and each time it doesnt bring back all of the content or the wrong content.
I'm creating a vb.net winforms application that will take in user given strings, parse them, and print out labels with variable information. The given string will be used in all the labels, but the variable part of the string will change with each label.
My question is: is it better to parse the strings one time, then store those values in arrays, or to parse the string each time a label is printed? Which will perform better? Which is better practice? What is the proper way to test something like this?
we are trying to use google to get exchange rate prices. they use a csv file which we get the code to go out and get.what im trying to do is pick the first line of the file and just use that. i have the following code but its not just picking the one line.
[Code]...
I am trying to create a program in VB.net to help me fix broken computer systems by parsing log files. I have some ideas but I have only built simple programs previously. I have ideas how to do this but so far my attempts haven't gone so well.Specifically I can either import a txt type file or copy and paste the contents of a txt file into the program and then have it compare what has been posted to a good/bad list then it reprints out what is bad in color coding. Also if their is a way to update the file it uses for comparison by entering in a txt file that would be stellar.
View 1 RepliesIm trying to get school information of a site and want to save it as an excel tables sheet with details in each column, inital start was the below code help me in going further.Column headers: school name, mascot, address, type, phone, fax etc. for a list of schools I have. For example I used one link.
[Code]...
Is there anyway to access internet sites if i code in VB6. i have gone thru a few basic tutorials and didn't found any command/method to develop or code a program which can access internet and do my work.
View 6 RepliesIm making a vb.net app and im using htmlagilitypack. I need hap to get the profile links from [URL]
Here is an example of the html:
<a href="/bus/Ontario/Brampton/A-Safe-Self-Storage/17142.html?what=af&where=Ontario&le=1238793c7aa%7Ccf8042ceaa%7C2ae32e5a2a" onmousedown="utag.link({link_name:'busname', link_attr1:'in_listing_left',
[Code].....
I am making scraper that uses url list. But I have no idea how to pass that wanted url from that list to thread that does scraping.
Public Sub init2_check()
Dim t(source1.Items.Count()) As Thread
For x = 0 To UBound(t) - 1
t(x) = New Thread(AddressOf ScraperDoWork)
t(x).IsBackground = True
t(x).Start(x)
thread.Sleep(100)
Next
Me.Invoke(New button_Delegate(AddressOf enable2_button), btn_StartScrape)
End Sub
I want to download a webpage by httpWebRequest.
Web page Address >> http://www.stockbangladesh.com/resou...l=18455&inv=60
from a free website
[URL]
But that page requires login first. my user name : babul37 and pass : mhbb7337 How can I download that page by httpWebRequest?
I have just made a program were i enter a proxy list then my software views a url over and over using the proxys . I was using a web browser in side the program but worked out slow.So i now have changed the code to htpp request. But now when i run the program it goes up by 2 the views then frezzes .Here is my code
rivate Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
If ListBox1.Items.Count = 1 Then
[code].....
I have a dirty csv file that has 13 headers, but sometimes misses the last column value on some lines.
If the line has 12 columns, I would like to add ,0 as the 13th column.
Example:
2006/03/09,30403,7820,68,220,538,1956,14,3765,11384,26676,17932
2007/12/20,40796,13393,33,79,427,2604,11,4042,24974,44583,41561,7688
How can I read the file, and add ,0 to a line that only has 11 comma's and leave the lines alone when they have 12 comma's?
I have a complicated text file that has 10000 lines of text which is of the format
$$ ************************************
$$ Put FIXTURE alignment code below
$$ you are in Manual mode at this point
$$ ************************************
[code]....
I'm toying with an idea that would require me to parse a text file that contains a SQL statement. (i.e. Select * From Customers) I would like to be able to programmatically via Visual Basic identify key words, table names, comment lines, etc.So, how do compilers handle such a task? How does a SQL database handle such a task? All of the parsing tools are for CSV files with some sort of consistent delimiter. I'm wondering if I need to read the file one character at a time and then do some sort of comparison.
View 2 RepliesI need to code a hitcounter button that looks at a textfile,counts how many times a site has been visited and then shows a message box with the results
View 13 RepliesI have a scenario where i have to Parse a UTF-16 Encoded CSV file and populate a treeview using VB.Net. I need to parse the CSV files which may also support other languages. how to proceed on this and what classes of .net I can use to solve this issue.
In VB.Net we do not have a provision to parse a UTF-16 file But There is a provision for reading UTF-8 encoded file.The method is OpenText(). I want a similar method but it should parse or read a UTF-16 encoded file.
I'm using vb.net. sample data below.. Can i use regular expression to parse this kind of data?
ID:="000000877978" LOCATION:="ALASKA" TELEPHONE:="8979797890" AGE:="33"
ID:="080832108089" LOCATION:="ASIA" TELEPHONE:="088238780" AGE:=45 BIRTHDAY="04/19/1968"
So i have a SQL file with this sort of data :
[Code]....
p.s. If i am not able to make my self clear here then do ask me for my code , It works perfectly but causes the application hang and is pretty slow ( Using the StreamReader )
I'm in the process of parsing the RTF file format, all was going well until I got to the body part of it.
Quote:
This part has been done
{
tf1ansiansicpg1252deff0deflang2057{fonttbl{f0fswissfcharset 0 Arial;}{f1fswissfprq1fcharset0 Arial Black;}}
[Code].....
I Want to create a active log moniter but im having a problem parsing the text file, the data is jumbled like this
["#0000000040000002#","Vicinity","Neoilithic",1291770399]Masterengi
["#0000000040000002#","Vicinity","Neoilithic",1291773853]Igotit
["#0000000040000002#","Vicinity","Neoilithic",1291773854]Respect
[code]....
it dose what i want it to but it creates a massive file and dosnt do it quick enough i have to have a 1 second+ delay in it or it goes bezurk.
I am trying to parse the xml file of format mentioned below and display it using textbox in VB.NET. But I am not able to parse it.
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<Table>
<Product>
<Product_id value="1"/>
[code]....
I'm wanting to have the option in my app to save configuration settings and then be able to import them on another machine or when the application is launched later. So I've got my saving routine working fine, using the XmlWriter class to write various settings to the XML file. I'm not quite sure what I should be using to do the parsing of the XML file to read the settings back in though, as there seems to be a few different ways to do this.Should I be creating an XmlDocument instance from the XML file and then using the ReadNode method or one of the other similar methods? Or should I be using the XmlReader class and one of its methods?is the format of my XML file:
<?xml version="1.0" encoding="utf-8" ?>
<!-- MY_APP_NAME Saved Settings - Version 0.9.5.0 -->
<SearchSettings>
[code].....
Just a little problem; seemingly easy but doesn't seem quite so straightforward as it should be. I am pulling an XML file from a server using the web browser control and the using the DOM innertext property to assign the contents of that XML page to a variable.
I would like to be able to efficiently parse through this variable as if it were an XML file. I have posted the output below.I can work out how to load an XML file using the LoadXML method from a disc or URL but I would prefer to parse it from within the variable. I know this should be simple but I was wondering what the best class to use would be as the most efficient / easy way of parsing data.
I am basically looking to extract each of the details for each <application> into an array.
[Code]...
I'm writing an application in VB.net 2010, using Visual Studio 2010 Pro on a Win 7 Computer. The test code works for me correctly. However when I ziped the project folder and sent it to a friend (who is using Visual Basic 2010 on an Win XP Computer), it did not work correctly.
While runing the program in debug, we found a section of that code reads an XML file to construct an object provides a different results on the two computers. I'm not sure why the same code would parse parts of same XML differently. Most of the XML parsed correctly on both computer, just a couple of sections provides the incorrect result on the XP Computer using VB 2010 Express.
Sample of XML that reads differently:
<players>
<min>2</min>
<max>2</max>
[Code]....