Is it possible to use the UltraPrintPreviewControl with an Excel spreadsheet?
I basically need to print a spreadsheet, and ultimately export it to PDF.
How could I accomplish that?
At the moment all I can achieve is opening an existing spreadsheet.
Hi,m using report object for generating print preview for xamdatagrid , however if the grid contains data in bulk,preview generation gets very slow and takes quite a long time.is there any solution or work arund to make its performance better? i m working on wpf application
Hi,m using report object for generating print preview for xamdatagrid , however if the grid contains data in bulk,preview generation gets very slow and takes quite a long time.is there any solution or work arund to make its performance better? i m working on wof application
I'm not aware of any way to print an Excel workbook through C#. There's nothing in NetAdvantage that would do this for you automatically.
You could launch the Excel file in Excel and let the user print it that way, of course.
Or you could print the data using the WinGrid.
I am able to create&save Excel report, but Workbook to automatically open in Print Preview and as well as i want to print excel preview report using C#.Net.
armandsmit said:I thought of using that work-around, but the obvious draw-back is that you lose all your formatting and such.
I thought of using that work-around, but the obvious draw-back is that you lose all
your formatting and such.
Yes, that's true. But if you decided not to use the grid, you would have to create a whole structure in your PDF report with tables and/or grids. And then you would need to manually apply the formatting to the cells, anyway. You would have to do everything.
If you used the grid, then the grid would give you the structure. Then you would just need to translate your Excel formatting into the grid.