DsExcel .NET enables users to export multiple worksheets to a single page in the PDF file .
This feature is useful especially when you want to analyse all the crucial data at one place in order to facilitate the sharing, manipulation and printing of data in an efficient way. For instance - let's say you have a workbook with multiple worksheets wherein you want to export the content of some worksheets (containing similar type of data) so that all the related data appears on the same page and is saved into a specific page in the PDF file. In this scenario, you can use this feature to export and print data from more than one worksheet to a single page in the PDF file as per your custom requirements and preferences.
In order to export multiple worksheets into a single page of the PDF file, users need to create an instance of the PrintManager class, get the default pagination settings of the workbook using the Paginate() method, use the Draw() method of the PrintManager class and finally save the PDF file using the GcPdfDocument.Save() method.
Refer to the following example code to allow users to export multiple worksheets to a single page in the PDF file.
C# |
Copy Code |
---|---|
// Initialize workbook Workbook workbook = new Workbook(); // Open Excel file workbook.Open("MultipleSheetsOnePage.xlsx"); /* NOTE: To use this feature, you should have a valid license for Documents for PDF.*/ // Create a PDF document GcPdfDocument doc = new GcPdfDocument(); // This page will save data for multiple pages Page page = doc.NewPage(); // Create an instance of the PrintManager class PrintManager printManager = new PrintManager(); // Get the pagination information of the workbook IList<PageInfo> pages = printManager.Paginate(workbook); /* Divide the multiple pages into one row and two columns and print them on one page */ printManager.Draw(page, pages, 1, 2); // Save the document to PDF file doc.Save(@"PrintMultiplePagesToOnePage.pdf"); |