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
Post a Comment