Document Solutions for Excel, .NET Edition | Document Solutions
File Operations / Export to PDF / Control Pagination / Render Excel Range Inside PDF
In This Topic
    Render Excel Range Inside PDF
    In This Topic

    DsExcel .NET enables users to render Excel cell ranges inside PDF.

    This feature is useful especially when you're dealing with bulk data in the spreadsheets and you want to render only specific Excel range inside an existing PDF file. For instance - let's say you have a worksheet containing large amounts of sales data with fields such as "Number of Products Sold", "Area Sales Manager", "Region" etc. but you want to export only a chunk of useful data (like only "Number of Products Sold" and "Region") at some location in a PDF file and not all the data (you don't want to include the "Area Sales Manager" information). In this scenario, the "Render Excel Range Inside PDF" feature can be used to select some specific ranges in the worksheet and render them to specific location in a PDF file to generate full PDF reports.

    In order to render Excel range inside the PDF file, you need to first create an instance of the PrintManager class and then use the Draw() method to render the Excel range on a PDF page at a location. In case, you want to add some extra information in your PDF file (data which is not present in your Excel file), you can use the AppendPage() method of the PrintManager class after configuring all the pagination settings. Finally, call the UpdatePageNumberAndPageSettings() method in order to update the indexes of the page number and the page settings for each page. When everything is done, simply save your PDF file using the GcPdfDocument.Save() method.   

    Note: In order to render Excel cell ranges inside PDF, you should have a valid license for Document Solutions for PDF.

    Refer to the following example code to allow users to render Excel ranges inside the PDF file .

    C#
    Copy Code 
        // Initialize workbook
    Workbook workbook = new Workbook();
    
    // Fetch default worksheet
    IWorksheet worksheet = workbook.Worksheets[0];

    // Set values
    worksheet.Range["A4:C4"].Value = new string[] 
    { "Device", "Quantity", "Unit Price" };
    worksheet.Range["A5:C8"].Value = new object[,] 
     {
       { "T540p", 12, 9850 },
       { "T570", 5, 7460 },
       { "Y460", 6, 5400 },
       { "Y460F", 8, 6240 }
     };

    // Set styles
    worksheet.Range["A4:C4"].Font.Bold = true;
    worksheet.Range["A4:C4"].Font.Color = Color.White;
    worksheet.Range["A4:C4"].Interior.Color = Color.LightBlue;
    worksheet.Range["A5:C8"].Borders[BordersIndex.InsideHorizontal].Color = 
    Color.Orange;
    worksheet.Range["A5:C8"].Borders[BordersIndex.InsideHorizontal].LineStyle =
    BorderLineStyle.DashDot;

/* NOTE: To use this feature, you should have a valid license 
for Documents Solutions for PDF.*/

// Create a PDF document
GcPdfDocument doc = new GcPdfDocument();
    Page page = doc.NewPage();
    GcPdfGraphics g = page.Graphics;

    // Create an instance of the PrintManager class
    PrintManager printManager = new PrintManager();
    
    // Draw the Range "A4:C8" to the specified location on the page 
    printManager.Draw(page, new PointF(30, 100), worksheet.Range["A4:C8"]);

    // Save the modified pages into PDF file
    doc.Save(@"RenderExcelRangesInsidePDFBasic.pdf");

    Refer to the following example code to allow users to render Excel ranges inside the PDF file along with some custom textual information at runtime to the specified location on the page.

    C#
    Copy Code 
     // Create a PDF file stream
 FileStream outputStream = 
 new FileStream("RenderExcelRangesInsidePDFAdvance.pdf", FileMode.Create);
    
 // Create a new workbook
 var workbook = new GrapeCity.Documents.Excel.Workbook();
 Stream fileStream = 
 GetResourceStream("xlsx\\FinancialReport.xlsx");
 workbook.Open(fileStream);
 IWorksheet worksheet = workbook.Worksheets[0];

/* NOTE: To use this feature, you should have a valid license 
   for Documents Solutions for PDF.*/

// Create a PDF document
Pdf.GcPdfDocument doc = new Pdf.GcPdfDocument();
 doc.Load(GetResourceStream("Acme-Financial Report 2018.pdf"));

 // Create an instance of the PrintManager class
 Excel.PrintManager printManager = new Excel.PrintManager();
  
 // Draw the contents of the sheet3 to the fourth page
 IRange printArea1 = workbook.Worksheets[2].Range["A3:C24"];
 SizeF size1 = printManager.GetSize(printArea1);
 RectangleF position1 = 
 doc.FindText(new GrapeCity.Documents.Pdf.FindTextParams
 ("Proposition enhancements are", true, true), 
 new GrapeCity.Documents.Common.OutputRange(4, 4))[0].Bounds.ToRect();
 printManager.Draw(doc.Pages[3], 
 new RectangleF(position1.X + position1.Width + 
 70, position1.Y, size1.Width, size1.Height), printArea1);
    
 // Draw the contents of the sheet1 to the fifth page 
 IRange printArea2 = workbook.Worksheets[0].Range["A4:E29"];
 SizeF size2 = printManager.GetSize(printArea2);
 RectangleF position2 = 
 doc.FindText(new GrapeCity.Documents.Pdf.FindTextParams(
 "expenditure, an improvement in working", true, true),
 new GrapeCity.Documents.Common.OutputRange(5, 5))[0].Bounds.ToRect();
 printManager.Draw(doc.Pages[4], 
 new RectangleF(position2.X, position2.Y + 
 position2.Height + 20, size2.Width, size2.Height), printArea2);
   
 // Draw the contents of the sheet2 to the sixth page 
 IRange printArea3 = workbook.Worksheets[1].Range["A2:E28"];
 SizeF size3 = printManager.GetSize(printArea3);
 RectangleF position3 = 
 doc.FindText(new GrapeCity.Documents.Pdf.FindTextParams
 ("company will be able to continue", true, true), 
 new GrapeCity.Documents.Common.OutputRange(6, 6))[0].Bounds.ToRect();
 printManager.Draw(doc.Pages[5], 
 new RectangleF(position3.X, position3.Y + 
 position3.Height + 20, doc.Pages[5].Size.Width -
 position3.X * 2 - 10, size3.Height), printArea3);
    
 // Save the modified pages into PDF file
 doc.Save(outputStream);
    
 // Close the PDF stream
 outputStream.Close();

 }

 static Stream GetResourceStream(string resourcePath)
    {
        string resource = "RenderExcelRangesInsideAPDF.Resource." +
        resourcePath.Replace("\\", ".");
        var assembly = typeof(Program).GetTypeInfo().Assembly;
        return assembly.GetManifestResourceStream(resource);
    }