View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] temp@deltasero.com is offline
external usenet poster
 
Posts: 2
Default C# Value2 intermittent exception

I'm writing an app that has C# creating an Excel workbook.
I'm using the Value2 command to assign a range a value (typically a
string array).

Intermittently, on only some machines, and only some of the time, the
use of the Value2 command
will result in an exception. I then catch the exception and write the
cells one by one. This
has the unfortunate consequence of blowing up my construction time from
4 minutes to over 6 hours.

Any one have any experience with the Value2 command intermittently
failing.

TIA

TayBill