Laurence, for the code below, could you please tell me what exceptions the ImportFromDataReader could throw? I am particularly interested in boundary conditions, like for large amounts of data. What are the break points?
No, my mistake. ArgumentException will be only thrown when the first row or column index is out of range. When number of rows or columns in DataReader is out of range, no exception will be throw. However, data will be truncated to be filled into the worksheet.