How to Print DataGridView Image Column?

Question

Hi I am using a Datagridview in my Windows Form to display some records in the form of Table. In my Datagridview I have one Image column which shows some Images. I can see the Images when I do a Print Preview of my Datagridview but when I Print the Datagridview instead of Images in the column what I see is a text saying System.Windows.Bitmap. I stuck at this point and findinf no solution. Can anybody help me sort out this problem so that I can display the Images. I am referring this Link : http://www.codeproject.com/Articles/13678/The-DataGridViewPrinter-Class and using the DataGridViewPrinter class to achieve Printing but This class does not support image cells. Please Help.

Santosh Thakur · Answer

Hi Ref the links: http://www.codeproject.com/Articles/16670/DataGridView-Printing-by-Selecting-Columns-and-Row

Debra Duchene · Answer

Hi here is a workaround that you can try. You can first create an excel file in-memory from a DataGridView control and then use that file for printing for example: // Create new file. var file = new ExcelFile(); // Import DataGridView to a new sheet. DataGridViewConverter.ImportFromDataGridView( file.Worksheets.Add(DataGridView Sheet) dataGridView1 new ImportFromDataGridViewOptions() { ColumnHeaders = true }); // Print file to a default printer. file.Print(null new PrintOptions()); The code uses this Excel library for VB.NET developers and not only will it import data from DataGridView but also hyperlinks formatting images and more. Also to print that excel file inside a .NET application is pretty straightforward task as you can see from above sample.