Home / Questions / 259695
Accepted
Juan Andres solanas
Asked: 2020-05-01 07:56:14 +0800 CST 2020-05-01 07:56:14 +0800 CST

Export datagrid to PDF and leave a whole row for a data

  • 772

enter image description hereI am exporting a Datagridto PDF with iTextSharp. Everything works fine, but I need to give the space of an entire row to a data that is long.

For example:

Record 1: id= 1, name ="Pedro", last name ="Perez", description= "This is the description of pedro and it is very long".

I need id, nombreand apellidoto be in row 1, and in the row below is the description. So with all the records that make up the table! Does anyone have an idea how to do that?

I want PartFound to be below the first record (and occupy the entire column)

c#

1 Answers

  1. Best Answer

    Without knowing your code of how you export your data to PDF it is difficult to help you as you intend, however I had a similar situation as the one you have and I obtained the solution, I clarify that my case was with Windows Formand DataGridViewbut using the library iTextSharp.

    From the outset I think the way it was solved can help you a bit (if I understood what you require), I don't think it's the best solution but it does solve the problem and I'll share it with you.

    Basically what I do is get the columns of my datagridview (in this case there are 11, adapting to the data of your problem). With

    datatable.SetWidths(new float[] { 10, 10, 25, 10, 30, 20, 15, 10, 30, 20, 0 });

    I am defining the width of each column and if you notice the last one I put a zero (0), this is because in the first instance, we only want to show the data of the first 10 columns and the last column that is not visible.

    With PdfPCellwe declare a cell that prints all the columns (in this case of my dgv) In fact it prints up to column 11 but since the last one has a width of 0 the data is not visible

    At last we compare that if the column is 10 (remember that the for loop starts from 0) then a new cell is created again and the data from column 11 is stored there, which in your example would be "PartFound" , We combine all the columns as if it were an excel with the instructioncelda1.Colspan = 11;

    and with that you get a result as shown in the image.

    enter image description here

    Attached the complete code.

    private void exportarPDF(Document doc)
{
    PdfPTable datatable = new PdfPTable(DataGridView1.ColumnCount);
    datatable.SetWidths(new float[] { 10, 10, 25, 10, 30, 20, 15, 10, 30, 20, 0 });   //Un DGV de 11 columnas, no mostrar la ultima columna (para ello, colocar 0).
    datatable.WidthPercentage = 100;
    datatable.DefaultCell.BorderWidth = 1;

    for (int i = 0; i <= DataGridView1.RowCount - 1; i++)
    {
        for (int j = 0; j <= DataGridView1.ColumnCount - 1; j++)
        {
            // Solo muestra la  columna 1 hasta la columna 10
            PdfPCell celda = new PdfPCell(new Phrase(DataGridView1(j, i).Value.ToString()));
            celda.VerticalAlignment = Element.ALIGN_MIDDLE;
            datatable.AddCell(celda);

            if (j == 10)
            {
                // Mostrar la columna 11
                PdfPCell celda1 = new PdfPCell(new Phrase(DataGridView1(10, i).Value.ToString()));
                celda1.Colspan = 11;
                celda1.VerticalAlignment = Element.ALIGN_MIDDLE;
                celda1.PaddingBottom = 15;
                datatable.AddCell(celda1);
            }
        }
    }
    doc.Add(datatable);
}
    • 1