Reading an Excel 2007 cell formula value using C# -


i've got large , complex excel 2007 file , cell formula references cell in worksheet. i've tried many things try value (as in 1 can see when loaded in excel itself) related trying child objects of openxmlpart's. value of cell 40178, there no list in file many indices. formula in cell "'input control sheet'!$f$8". i'm (perhaps stupidly) assuming string can used directly on openxml api read value cell referenced string, wrong?

if tell me how value correct cell out based on formula happy - i've been basing work far on code provided microsoft (terrible) page: http://msdn.microsoft.com/en-us/library/cc850837.aspx

thanks,

matt.

probably u can use code read each cell value. u can modify code accordingly, code reading values excel file , returning list of values read:

first put this: using excel = microsoft.office.interop.excel;

private list<string> getkeywordslist(string xlsfilepath)     {         excel.application xlapp;         excel.workbook xlworkbook;         excel.worksheet xlworksheet;         excel.range range;         string str;         int rcnt = 0;         int ccnt = 0;          list<string> keywords = new list<string>();         xlapp = new excel.applicationclass();         xlworkbook = xlapp.workbooks.open(xlsfilepath, 0, true, 5, "", "", true, microsoft.office.interop.excel.xlplatform.xlwindows, "\t", false, false, 0, true, 1, 0);         xlworksheet = (excel.worksheet)xlworkbook.worksheets.get_item(1);          range = xlworksheet.usedrange;         (rcnt = 1; rcnt <= range.rows.count; rcnt++)         {             (ccnt = 1; ccnt <= range.columns.count; ccnt++)             {                  if (!(((range.cells[rcnt, ccnt] excel.range).value2) == null))                 {                     if ((range.cells[rcnt, ccnt] excel.range).value2.gettype().tostring() == "system.double")                     {                         double d1 = (double)(range.cells[rcnt, ccnt] excel.range).value2;                         str = convert.tostring(d1);                         keywords.add(str);                     }                     else                     {                         str = (string)(range.cells[rcnt, ccnt] excel.range).value2;                         keywords.add(str);                     }                 }             }          }          xlworkbook.close(true, null, null);         xlapp.quit();          releaseobject(xlworksheet);         releaseobject(xlworkbook);         releaseobject(xlapp);         return keywords;      }  private void releaseobject(object obj)     {         try         {             system.runtime.interopservices.marshal.releasecomobject(obj);             obj = null;         }         catch (exception ex)         {             obj = null;         }                 {             gc.collect();         }     }

Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc...
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use...
Read more