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

    GcExcel .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 SavePDF() method.   

    Note: In order to render Excel cell ranges inside PDF, you should have a valid license for GrapeCity Documents 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 GrapeCity Documents 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 GrapeCity Documents 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);
       }