|
Copy and paste in notepad, then in notepad copy and paste in Excel ...
|
|
|
|
|
 Thanks Waleed.
I bet i did nt ask how to do that programatically in C# (assumed it to be understood.)
So does any one know how to parse the html data and save it in excel, Programatically in C#?
|
|
|
|
|
Well, you said copy and paste, you don't programmatically copy and paste, you import/export/parse .. etc .. this is why I was confused .. anyway, you have to parse the page (it's also called html scraping I believe) .. you can use mshtml to access the DOM of the page .. I have written a tool recently that does exactly this, read data from a table in an html page and save it to a table in a database but it only works with MySQL but I believe you could change the code easily, anyway, tell me if you want the code ...
regards
|
|
|
|
|
Thanks Waleed for helping out here. Now i know the right technical terms for what i want to acheive here 
If you can send me the code for your tool, i will really appreciate that man.
ytb
|
|
|
|
|
Sure, I uploaded the code to my website .. you may download it from http://www.waleedeissa.com/temp/HTM2MySQL.zip[^]
BTW, you could just replace MySQL with OleDb and export to Excel using OleDb and this connection string:
string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=YES;\"", excelFilePath)
Just change HDR=YES to HDR=No if you don't have headers in your Excel sheet ...
modified on Wednesday, April 16, 2008 3:20 AM
|
|
|
|
|
B Waleed,
The link doesnt seem to be active.
Can you kindly double check?
Thanks
|
|
|
|
|
You're right, sorry, I fixed the link try it again...
I also added a missing file, so if you already downloaded the file, then please download it again...
|
|
|
|
|
Arite,
I have written the problem scenario below.
Can you help me with Step 2? How do i make my application launch the browser with username and password already entered in it?
Sample Scenario:
Step 1 - I want to launch a webpage (www.hotmail.com) using C# Application.
Step 2 - I want my application to enter the username and password in the fields and then click the 'Sign In' button.
Therefore when i launch this application, it takes me directly into the page where data is sitting (Emails)
Here is the code that is working for Step 1
string url = "http://login.live.com/login.srf?wa=wsignin1.0&rpsnv=10&ct=1208358013&rver=4.5.2130.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&id=64855";<br />
System.Diagnostics.Process proc = new System.Diagnostics.Process();<br />
System.Diagnostics.ProcessStartInfo startInfo = new System.Diagnostics.ProcessStartInfo(url);<br />
proc.StartInfo = startInfo;<br />
proc.Start();
|
|
|
|
|
Actually I never tried this before but I believe (not sure though) I saw an article here on codeproject.com that talks just about that , so, you could try searching the site .. I can tell you though that you don't need to do it in two steps, you can pass the username and password as a POST request but to do this in the browser this is what I'm not sure of, I'm almost sure it's possible but I don't have experience with that, so, I guess you need to do a little googling .. sorry man, wish I could help ...
|
|
|
|
|
Well, just wanted to be sure that I understood correctly, are you talking about launching the default web browser e.g. IE or FireFox? (this is what I understood) or hosting a browser control in your application? ie. showing the page in your application .. it's much easier in the later case ...
|
|
|
|
|
|
Hello everyone,
In my understanding, this method only prevents GC from invoking Finalize method of the instance, it does not prevent GC from reclaiming the memory consumed by the instance? Right?
thanks in advance,
George
|
|
|
|
|
SuppressFinalize is used to prevent the call to the finalizer, usually after you cleaned up you resources in the Dispose method.
The call removes the object from the finalization queue, so it is destroyed earlier (and the GC may reclaim memory on it).
So yes, you're right.
|
|
|
|
|
Thanks Zoltan!
I noticed that when dispose method is called, we always call SuppressFinalize to prevent from calling Finalize again.
So, it means we should do the same thing (resource de-allocation) in both Dispose and destructor, right?
regards,
George
|
|
|
|
|
It prevents you from cleaning up unmanaged resources twice. The GC will still (always AFAIK) free the managed memory on Finalize.
|
|
|
|
|
Thanks leppie!
I noticed that when dispose method is called, we always call SuppressFinalize to prevent from calling Finalize again.
So, it means we should do the same thing (resource de-allocation) in both Dispose and destructor, right?
regards,
George
|
|
|
|
|
George_George wrote: So, it means we should do the same thing (resource de-allocation) in both Dispose and destructor, right?
Basically, normally you would use the Dispose(bool) pattern that will be called from the Finalizer with a false parameter, where Dispose() calls it with a true parameter. Do a search, you are bound to find more than enough samples.
|
|
|
|
|
Thanks leppie!
I have made some research. I think in destructor, we should call Dispose to release native resource, in Dispose, we should release both native resouce and call Dispose method of wrapped managed resource explicitly. Right?
regards,
George
|
|
|
|
|
hey
any one of u can help me..
i have one pdf file with 4-5 pages and i want to save these pages as images.so i can show these pdf pages in thumbnail .i m using C# in asp.net application.
can any one help me.can any one give me code help.
thx
Ajay Rathi
software engineer
NOIDA(UP),INDIA
|
|
|
|
|
Hi,
What are the maximum number of columns in .NET DataTable.
Thanks in advance
|
|
|
|
|
|
If you have to hit that limit, you've got bigger issues with your application...
It's System.Int32.MaxValue, or 2,147,483,647. But since you wont be able to reach that limit without generating an OutOfMemory Exception, it's limited by available memory.
|
|
|
|
|
|
|
Can we increase size of data table? I am trying to read data from Excel but dataset picks only first 256 column How Can I read all data from Excel
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
