Print WebWorksheet

Aspose.Cells Product Family
1

Hi Amjad,

I have gone through following link

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/printing-workbooks.html

But i want to print the webworksheet. Please suggest

Regards,

Nikhil

2

Hi,

Do you want to take the snapshot of your webpage, I mean, as browser renders the webworksheet?

Or do you want to take the snapshot of your worksheet as Ms-Excel displays it? Please elaborate.

3

Hi Amjad,

I want snapshot of the excel worksheet and not the webpage

Regards,

Nikhil

4
Hi,


Please try "GridWeb1.print();" method at client side for your need.


Thank you.
5

Hi Amjad,

No such method found..Please elaborate

Regards,

Nikhil

6
Hi,

Well, you need to call/use it on the client side, see some demos on how you can work on client side (in javascript) using some events/functions:

Thank you.
7

Hi Amjad,

Its not working, i have tried many trials and errors but not able to print it

Could you please suggest me some code which i will try and get the result

Regards,

Nikhil

8

Hi,

You can also get the snapshot of your Excel workbook/worksheets using Aspose.Cells. So you can use both Aspose.Cells and Aspose.Cells.GridDesktop side by side.

Please see the following articles how to take images of your worksheets.
Printing Workbooks
Converting Worksheet to Image using ImageOrPrint Options
Converting Worksheet to Image

</div>
9

Hi Amjad,

Thanks, printing works very nicely now

But page is going directly for the printing and not asking for the print dialog

Want to ask for the print dialog and as per the setting print the sheet...Is it possible? Is there any workaround?

Regards,

Nikhil

10

Hi,


If you are using GridWeb control we have only GridWeb.print() client side method, it will print directly, we don’t provide any option that would go to printer first to adjust the dialog.

If you are using Aspose.Cells library, you may use:
SheetRender.ToPrinter() or WorkbookRender.ToPrinter() method

Thank you.