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.
Debra DuchenePosted May 30, 2014, 4:32 AM
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.
Santosh ThakurPosted Dec 24, 2013, 5:03 AM
Ref the links:
http://www.codeproject.com/Articles/16670/DataGridView-Printing-by-Selecting-Columns-and-Row