Sep 13, 2013 at 4:24 AM
Edited Sep 13, 2013 at 4:28 AM
I have a active-x checkbox control in my excel. I need to read the value of the active-x control i.e. the checkbox on the server...on my local machine as excel component is installed there is no issue to read the same but at the server there is no excel component
Is there any way i can read the active-x check control without using ole-db or excel component at the server...
Following is the code i am using
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
using (FileStream file = new FileStream(FileName, FileMode.Open, FileAccess.Read))
hssfworkbook = new HSSFWorkbook(file);
int SheetCount = hssfworkbook.NumberOfSheets;
for (int Loopvar = 0; Loopvar < 4; Loopvar++)
ISheet sheet = hssfworkbook.GetSheetAt(Loopvar);
System.Collections.IEnumerator rows = sheet.GetRowEnumerator();
IRow row = (HSSFRow)rows.Current;
for (int i = 0; i < row.LastCellNum; i++)
ICell cell = row.GetCell(i);
if (cell == null)
//sheet = null;
But when check box is there in the cell it is returning null value.....
Thanks in advance.....