c# - Reading to an Excel file -


i trying read excel sheet using c# , store each row array. able open file code using reads "2d-object" array read info 1d-string arrays.

static void main(string[] args) {     // reference excel application.     excel.application xlapp = new excel.application();      excel.workbook xlworkbook = xlapp.workbooks.open(path.getfullpath("excelpractice1.xlsx"));      // first worksheet.     excel.worksheet xlworksheet = (excel.worksheet)xlworkbook.sheets.get_item(1);     // range of cells has data.     excel.range xlrange = xlworksheet.usedrange;      // object array of of cells in worksheet values.     object[,] valuearray = (object[,])xlrange.get_value(excel.xlrangevaluedatatype.xlrangevaluedefault);     // close workbook.     xlworkbook.close(false);      // relase com object decrementing reference count.     marshal.releasecomobject(xlworkbook);      // close excel application.     xlapp.quit();      // release com object.     marshal.finalreleasecomobject(xlapp);      console.readline();      } } } 

`

sorry, trying comment only. =x did worked anyway? linqtoexcel great library manipulate spreadsheets! please, let me know if has doubt yet.

=)


Comments

Popular posts from this blog

android - Sent Blob results empty -

javascript - Bootstrap Popover: iOS Safari strange behaviour -