Exception from HRESULT: 0x800A03EC during Excel 2007 operation

• 2008년 7월 10일 목요일 오후 6:49

   

   
  

  0
  Hello all,
  
  I have a weird situation that I cannot figure out. The code below iterates through all of the worksheets in a workbook (Excel 2007) and takes the sheet name and a link to a particular cell on each sheet. On all my tests everything works perfectly, until the workbook has too many sheets (haven't figured out what the magic number is yet - 20 seems fine.) If there are too many sheets (at least, that is the only thing that I have isolated it down to) then I get an Exception from HRESULT: 0x800A03EC thrown. Any ideas on what is causing this and how to get around it?
  
  Thanks! 

  Excel.Worksheet tmpSheet;
  for(q=2; q<total;q++)
  {
  tmpSheet = (Excel.Worksheet)doc.Worksheets[q];

  tmpSheetname = "='" + tmpSheet.Name + "'!D40";

  cell = "B" + (q+8).ToString();

  SummarySheet.get_Range(cell, cell).Value2 = tmpSheetname;

  cell = "A" + (q + 8).ToString();

  SummarySheet.get_Range(cell, cell).Value2 = tmpSheet.get_Range("D9", "D9").Value2.ToString().Remove(0, 15);

  }

  • 이동됨 David DoBell 2008년 7월 10일 목요일 오후 8:59 Post is not related to Microsoft Interoperability
  •  
  • 응답
  • 인용