I got the following error while i was trying to load Excel file stream. I am using Infragistics35.WebUI.Excel.v9.2. Version=9.2.20092.2056.

 I can open the file from MS Excel.

Index was out of range. It must be non-negative and less than the size of the collection.

Parameter name: index .

When load Excel file saved as xlsx format, The Excel file loading was succed. but load  a Excel file as xls fomat was faild.

I was debug the source code. the error code is in followwing function.

// BiffRecordStream.cs

  private void CacheNextBlock( ref byte[] buffer, ref int bufferPosition )
  {
   int copyEndCount = 0;
   if ( bufferPosition < buffer.Length )
    copyEndCount = buffer.Length - bufferPosition;

   RecordBlockInfo currentBlockInfo = this.blocks[ this.currentBlock ];
   int currentBlockLength = currentBlockInfo.BlockLength;

   int blockLength;
   if ( this.positionInCurrentBlock == currentBlockLength )
    blockLength = this.blocks[ this.currentBlock + 1 ].BlockLength;
   else
    blockLength = currentBlockLength - this.positionInCurrentBlock;

   byte[] newBuffer = new byte[ copyEndCount + blockLength ];

   if ( copyEndCount != 0 )
    Buffer.BlockCopy( buffer, bufferPosition, newBuffer, 0, copyEndCount );

   this.ReadFromCurrentBlock( newBuffer, copyEndCount, blockLength );

   bufferPosition = 0;
   buffer = newBuffer;
  }

this.blocks.Count has 5, but  this.currentBlock + 1 is 5

We need to use xls format file. Can I received bug Fixed module?

my e-mail address is silspa@korea.com

I wait your answer!