Print in Spreadsheet

[Administrator]

Hello

We have interest in your WPF-Xls component. For Our users is very important printing.
 I can not find print in your demo (documentation). Is your component supporting print in WPF?
Please could you send a demo or documentation for print Spreadsheet in WPF?

Thanks
Miro

[Ponraja A]

Hi Chrastina,

Thanks for using Syncfusion products.

Currently we don’t have the direct support for printing in spreadsheet control.  But we can achieve this by converting the worksheet to Image using ConvertToImage method and then we can print that image. For that we have created the sample, please find the sample in the below location.

Please let us know if you have any queries.

Regards,

Ponraja

SpreadsheetDemo_3580cd4f.zip

[CEO - Hui Lian]

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

[Pannir Selvam S]

Hi Chrastina,

Sorry for the inconvenience.

Currently we don’t have support in the SpreadsheetControl for printing the data which includes column header and row header.

Please let us know if any other concerns.

Regards,

Pannir.