ASP. NET Code read an Excel table

Private excel. _ application excelapp; <br/> private string filename = string. empty; <br/> private excel. workbookclass wbclass; <br/> Public class1 (string _ filename) <br/>{< br/> excelapp = new excel. application (); <br/> Object objopt = system. reflection. missing. value; <br/> wbclass = (Excel. workbookclass) excelapp. workbooks. open (_ filename, objopt, false, objopt, true, objopt, objopt, true, objopt ); <br/>}</P> <p>/**/<br/> // <summary> <br/> // list of all sheet names <br />/// </Summary> <br/> /// <returns> </returns> <br/> public list <string> getsheetnames () <br/>{< br/> List <string> List = new list <string> (); <br/> excel. sheets sheets = wbclass. worksheets; <br/> string sheetnams = string. empty; <br/> foreach (Excel. worksheet sheet in sheets) <br/>{< br/> list. add (sheet. name); <br/>}< br/> return list; <br/>}< br/> Public excel. worksheet getworksheetbyname (string name) <br/>{< br/> excel. worksheet sheet = NULL; <br/> excel. sheets sheets = wbclass. worksheets; <br/> foreach (Excel. worksheet s in sheets) <br/>{< br/> If (S. name = Name) <br/>{< br/> Sheet = s; <br/> break; <br/>}< br/> return sheet; <br/>}< br/>/**/<br/> // <summary> <br/> // <br/> /// /// </Summary> <br/> /// <Param name = "sheetname"> Sheet Name </param> <br/> ///// /<returns> </returns> <br/> Public array getcontent (string sheetname) <br/>{< br/> excel. worksheet sheet = getworksheetbyname (sheetname); <br/> // obtain the cell from A1 to am24 <br/> excel. range rang = sheet. get_range ("A1", "C11"); <br/> // read the content of a cell <br/> // sheet. get_range ("A1", type. missing); <br/> // The area, column, and number of rows that are not empty <br/> // int L = sheet. usedrange. columns. count; <br/> // int W = sheet. usedrange. rows. count; <br/> // object [,] Dell = sheet. usedrange. get_value (missing. value) as object [,]; <br/> system. array values = (array) rang. cells. value2; <br/> return values; <br/>}</P> <p> Public void close () <br/>{< br/> excelapp. quit (); <br/> excelapp = NULL; <br/>}

Add reference:

COM: Microsoft Excel 11.0 Object Library