Comments by rajgaikwad01 (Top 10 by date)

Hi Gaurav,

Thanks for reply.
Is there any other option to fill DGV with DataGridViewComboBoxColumn.
Because use of for loop will lower down the application performance in my case.
because I have editable grid which will interact with the Database.

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.

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.

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".

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;
}
}