getting Webbrower.Document always null

Question

0.00/5 (No votes)

See more:

I am navigating Excel sheet in WebBrowser control.

eBrowser.Navigate("D:\test.xlsx", false);

if I am updating something in excel sheet which is displayed in WB control then I want to save that changes back to location or wants to import sheet with changes in data table.
I tried to get WB control document on Navigated and DocumentComplete event but always getting wb.Document as null.

So please help me to save the Excel from WB on button click.
I don't want to use ctrl+s option which we can use to save excel directly.

Posted 5-Dec-13 23:35pm

rajgaikwad01

Updated 5-Dec-13 23:38pm

v3

Add a Solution

Comments

Ziee-M 9-Dec-13 7:34am

Hi, post some code so we can help you.

rajgaikwad01 10-Dec-13 0:25am

Hi Ziee-M,

Thanks for your reply
Please see the below code:

private void eBrowser_DocumentCompleted(object sender, WebBrowserDocumentCompletedEventArgs e)
{
try
{
Application.DoEvents();
HtmlDocument hDoc = eBrowser.Document;
}
catch (Exception)
{

throw;
}
}

but here I am getting hDoc as Null.
I want to read updated Excel file from WB control.
Is there any option to get Excel data in Data Table.

I tried to read data from Excel in Data table but I am getting only default data which was present in Excel sheet. But if I am updating Excel using WB control that changes we need.
Please see the below code which I have written to get data from Excel:

private DataTable GetExcelData(Excel.Workbook wb)
{
DataTable dTable = new DataTable();
DataColumn dColumn = null;
try
{
Excel.Worksheet wSheet = (Excel.Worksheet)wb.Worksheets.get_Item(1);
Excel.Range wRange = wSheet.UsedRange;
if (wRange.Columns.Count > 0)
{
for (int cCnt = 1; cCnt <= wRange.Columns.Count; cCnt++)
{
dColumn = new DataColumn();
dColumn.DataType = System.Type.GetType("System.String");
string cName = (string)(wRange.Cells[1, cCnt] as Excel.Range).Value2;
dColumn.ColumnName = cName; //cCnt.ToString();
dTable.Columns.Add(dColumn);
}

for (int rCnt = 2; rCnt <= wRange.Rows.Count; rCnt++)
{

DataRow dRow = dTable.NewRow();
int CellEnpty = 0;
for (int cCnt = 1; cCnt <= wRange.Columns.Count; cCnt++)
{
string sCellValue = "";
double ConvertVal = 0.0;
try
{
sCellValue = (string)(wRange.Cells[rCnt, cCnt] as Excel.Range).Value2;
}
catch (Exception)
{
ConvertVal = (double)(wRange.Cells[rCnt, cCnt] as Excel.Range).Value2; ;
sCellValue = ConvertVal.ToString();
}
if (sCellValue != null)
{
if (sCellValue != "")
{
dRow[cCnt - 1] = sCellValue;
}
else
{
CellEnpty += 1;
}
}
else
{
CellEnpty += 1;
}
}
if (CellEnpty < 3)
{
dTable.Rows.Add(dRow);
}
}

}
return dTable;
}
catch (Exception)
{

throw;
}
}

Ziee-M 10-Dec-13 3:21am

hi, i dont think its a good idea to use Application.DoEvents(). if you have a long running loop, your application will crash sooner or later, you will have to use threads and synchornisation later.
From my expirence working with webbrowser, the WebBrowser.document is not very stable, i stopped working with it, but it should work fine in your case, try using DocumentText, you get a string variable. you can use methods like String.Substring, Replace, remove (Strings methods) to get your data.
If your Html code is clean, you will have no problem. althought i am not sure if this is the best solutions.
Don't hesitate to ask more questions.

Ziee-M 10-Dec-13 3:36am

Also try to remove Application.DoEvents(); from there, its used in the wrong place. in general we use it to wait until the webpage is loaded successfully
while (webBrowser1.ReadyState != WebBrowserReadyState.Complete)
{
Application.DoEvents();
}
again, its not a good idea to use it in long running loop.
in my case unhandeled errors started occuring after 5000 loop, so i switched to threads.

rajgaikwad01 10-Dec-13 4:42am

Hi,

I tried with DocumentText but I am getting null value.
Only I am getting value for DocumentTitle property as "test.xlsx".
I have searched on Google for this issue so I saw the examples given with WB have Application.DoEvent so I tried same.

if I am checking "eBrowser.ReadyState" it always returns "Uninitialized".

Ziee-M 10-Dec-13 4:55am

Hi raj,
try doing the process manually,
add a button that gets the browser.DocumentText(). run your application and wait until the webBrowser loads the page successfully, then press the button and check if your value is always null

rajgaikwad01 10-Dec-13 5:00am

Hi,

I tried it on Button click only but I am getting Null value.
Is there any option to upload complete code so you can check it.

Ziee-M 10-Dec-13 4:59am

By the way, why are you using WebBrowser to get Data from a file? you can use streamsto read and put the data in a richtextBox, a datagrid...

rajgaikwad01 10-Dec-13 5:10am

I want to use Grid which will work same as a Excel sheet like Copy, paste multiple rows, Shortcuts like Ctrl + d etc.
These can not be possible with grid so I am trying to use Excel as Control. for that I got this idea to use Excel with WB control.
If you have any other option to do the same please suggest.

Ziee-M 10-Dec-13 5:41am

you can probably achive your goal using DataGrid, but you have to create custom methods.
DataGrid allow multiple row selection, cell selection... so i think its much better then using weBrowser.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)