c# - Excel._Worksheet.Columns.Autofit() method is hanging -


my sqldatareader returning ~200 rows of data. half of rows have column contains entire xml document. i'm assuming column causing autofit() method hang. how can go getting either throw exception, or complete successfully. don't care one, need [automated] program finish.

excel.application xl = null;             excel._workbook wb;             excel._worksheet ws;              try             {                 xl = new microsoft.office.interop.excel.application();                 xl.visible = false;                  while (reader.hasrows && !done)                 {                     wb = (excel._workbook)(xl.workbooks.add(excel.xlwbatemplate.xlwbatworksheet));                     ws = (excel._worksheet)wb.activesheet;                      // insert column headers                     (int counter = 0; counter < reader.fieldcount; counter++)                         ws.cells[1, counter + 1] = reader.getname(counter);                      // write data excel file                     while (reader.read())                     {                         (int counter = 1; counter <= reader.fieldcount; counter++)                         {                             // need format column excel doesn't change how looks                             if (report.reportname == "rptaamvanetbatch" && reader.getname(counter - 1) == "correlationid")                                 ws.cells[rowcounter, counter] = string.format("''{0}'", reader.getvalue(counter - 1));                             else                                 ws.cells[rowcounter, counter] = reader.getvalue(counter - 1);                         }                         rowcounter++;                     }                      recordsprocessed = rowcounter - 1;                      // format excel file liking                     ws.get_range(ws.cells[1, 1], ws.cells[rowcounter - 1, reader.fieldcount]);                     ws.columns.autofit();

further comment above, using particular sample file created couple of days ago in there 100 rows , in col e, have entire body of several emails (i have put red box protect identity , contents of email)

enter image description here

this simple vba code ran check time takes autofit e column

sub test()     dim starttime string     dim endtime string      starttime =      columns("e:e").entirecolumn.autofit      endtime =      debug.print "the process started @ " & starttime & " , got on @ " & endtime end sub

screenshot:

enter image description here

your program taking more time because there 200 rows , maybe have more data in each excel cell compared mine.

so solution?

the best solution can think of widen column it's max (254.86) before write huge data it. this

        excel.range rng = ws.get_range("e:e",system.type.missing);          rng.entirecolumn.columnwidth = 254;

note: don't use autofit column or entire worksheet. if need use autofit break up. example, in case, autofit columns 1 4 , 6 last column


Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more