View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amy Amy is offline
external usenet poster
 
Posts: 165
Default Invalid index in foreach(HPageBreak hpb in sheet.HPageBreaks)

My program got the following exception while parsing some excel files (they
usually contain some manual page breaks):
Exception from HRESULT: 0*8002000B <DISP_E_BADINDEX

I used
sheet.HPageBreaks.Count
found it contains 5 objects...
my program can get the first two objects successfully, how ever, it cannot
load the left.

Does anyone know why?
Thanks for any comments.