c# - Strange behavior from Excel.Worksheet.Cells[row, column] -


i have following method:

    public static object getvalue(excel.worksheet sheet, int row, int col)     {         excel.range r = sheet.cells[row, col] excel.range;         //i've tried using sheet.get_range(cell, cell); here, same result          if (r.row != row || r.column != col)          {                //why debug statement print?             debug.print("tried read (" + row.tostring() + ", " + col.tostring() + ") got (" + r.row.tostring() + ", " + r.column.tostring() + ")");         }          return r.value2;     }

based on understanding of excel.worksheet.cells[row, column], code should never enter if statement. however, when call getvalue repeatedly read multiple cells, every row , column of range returns different row , column called excel.worksheet.cells with.

example output: "tried read (19, 1) got (56, 5)"

furthermore, if break in if statement, rewind execution point , run excel.worksheet.cells again, correct range.

why be?

this isn't answer direct question, may solve problem.

is getvalue in tight loop? if approach different way. since accessing cells , value2 com-calls slower normal array accessors. if have particular range you're looping on array of values range in memory , access array directly rather looping through cells.

e.g. instead of

for(int r = 1; r <= 10; r++)     for(int c = 1; c <= 20; c++)             double val = sheet.cells[r,c];

do

object[,] values = sheet.range("a1:j20").value for(int r = 1; r <= 10; r++)     for(int c = 1; c <= 20; c++)             double val = values[r,c];

this may fix problem removing com access tight loop , eliminating whatever problem giving strange results.


Comments

Post a Comment

Popular posts from this blog

ios - iPhone/iPad different view orientations in different views , and apple approval process -

i force app's home screen portrait , other views landscape. apple rejects app if this? if not , how force first screen launch in portrait mode? , force other screens launch in landscape. this not duplicate question search every possible answer in website. i force app's home screen portrait , other views landscape. apple rejects app if this? no apple not reject app this. have lot of apps doesn't support orientation. forcing on 1 screen won't cause app reject. if not , how force first screen launch in portrait mode? , force other screens launch in landscape. can on write : -(nsuinteger)supportedinterfaceorientations; function.
Read more

java Extracting Zip file -

i'm looking way extract zip file. far have tried java.util.zip , org.apache.commons.compress, both gave corrupted output. basically, input zip file contain 1 single .doc file. java.util.zip: output corrupted. org.apache.commons.compress: output blank file, 2 mb size. so far commercial software winrar work perfectly. there java library make use of this? this method using java.util library: public void extractzipnative(file filezip) { zipinputstream zis; stringbuilder sb; try { zis = new zipinputstream(new fileinputstream(filezip)); zipentry ze = zis.getnextentry(); byte[] buffer = new byte[(int) ze.getsize()]; fileoutputstream fos = new fileoutputstream(this.tempfolderpath+ze.getname()); int len; while ((len=zis.read(buffer))>0) { fos.write(buffer); } fos.flush(); fos.close(); } catch (filenotfoundexception e) { // todo auto-generated catch block ...
Read more

C# WinForm - loading screen -

i ask how make loading screen (just picture or something) appears while program being loaded, , disappears when program has finished loading. in fancier versions, have seen process bar (%) displayed. how can have that, , how calculate % show on it? i know there form_load() event, not see form_loaded() event, or % property / attribute anywhere. all need create 1 form splash screen , show before main start showing landing page , close splash once landing page loaded. class splashform { //delegate cross thread call close private delegate void closedelegate(); //the type of form displayed splash screen. private static splashform splashform; static public void showsplashscreen() { // make sure launched once. if (splashform != null) return; thread thread = new thread(new threadstart(splashform.showform)); thread.isbackground = true; thread.setapartmentstate(apartmentstate.sta); thread....
Read more