Hello,
I have downloaded the zip files and it is working but it only prints the data and exclude the column header. I would like to print the column header and I change the index to 0 as below:
1) System.Drawing.Bitmap bitmap = (System.Drawing.Bitmap)sheet.ConvertToImage( 0, 0, lastRow, lastColumn, ImageType.Bitmap, null );
or
2)System.Drawing.Bitmap bitmap = (System.Drawing.Bitmap)sheet.ConvertToImage( 1, 0, lastRow, lastColumn, ImageType.Bitmap, null );
or
3)System.Drawing.Bitmap bitmap = (System.Drawing.Bitmap)sheet.ConvertToImage( 0, 1, lastRow, lastColumn, ImageType.Bitmap, null );
will have exception
"Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index"
Please advise.
Carmen