Remove time in itextsharp pdf document

08.04.2018 12:44:21 datetime now

08.04.2018 I need..

//Adding DataRow
foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString(), calibri));
pdfTable.AddCell(cell2);
}
}

I try this

//Adding DataRow
foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
string dateVal = cell.Value.ToString().Split(',')[0];
PdfPCell cell2 = new PdfPCell(new Phrase(dateVal, calibri));
}
}

But dont work

Complete code for pdf click

private void button9_Click(object sender, EventArgs e)
{
//Creating iTextSharp Table from the DataTable data
//Console.WriteLine(drzaveDataGridView.ColumnCount); test za itext sharp
PdfPTable pdfTable = new PdfPTable(mp_faktura_listaDataGridView.ColumnCount);
pdfTable.DefaultCell.Padding = 3;
pdfTable.WidthPercentage = 100;
pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
pdfTable.DefaultCell.BorderWidth = 1;
pdfTable.DefaultCell.BorderWidth = 1;
float[] sirina = new float[] { 0f, 15f, 40f, 70f, 25f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f };
pdfTable.SetWidths(sirina);
BaseFont bfCalibri = BaseFont.CreateFont("c:\\windows\\fonts\\calibri.ttf", BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
iTextSharp.text.Font calibri = new iTextSharp.text.Font(bfCalibri, 9);
iTextSharp.text.Font calibri10bold3 = new iTextSharp.text.Font(bfCalibri, 9, iTextSharp.text.Font.BOLD, iTextSharp.text.BaseColor.WHITE);
//Adding Header row
foreach (DataGridViewColumn column in mp_faktura_listaDataGridView.Columns)
{
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText, calibri10bold3));
cell.BackgroundColor = new iTextSharp.text.BaseColor(243, 70, 5);
pdfTable.AddCell(cell);
}
//Adding DataRow
foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString(), calibri));
pdfTable.AddCell(cell2);
}
}
string folderPath = "C:\\PDFs\\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
using (FileStream stream = new FileStream(folderPath + "Lista MP faktura.pdf", FileMode.Create))
{
iTextSharp.text.Font calibriTitle = new iTextSharp.text.Font(bfCalibri, 14, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font calibriSubTitle = new iTextSharp.text.Font(bfCalibri, 12);
iTextSharp.text.Font calibriSubTitlebold = new iTextSharp.text.Font(bfCalibri, 14, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font calibri10bold = new iTextSharp.text.Font(bfCalibri, 10, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font calibri22bold = new iTextSharp.text.Font(bfCalibri, 22, iTextSharp.text.Font.BOLDITALIC);
iTextSharp.text.Font calibrinaslov = new iTextSharp.text.Font(bfCalibri, 16);
iTextSharp.text.Font calibriukupno = new iTextSharp.text.Font(bfCalibri, 12, iTextSharp.text.Font.BOLDITALIC);
Document pdfDoc = new Document(PageSize.A4, 27f, 10f, 10f, 30f);
// PdfWriter.GetInstance(pdfDoc, stream);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
pdfDoc.Add(new ListItem(korisnik_programa, calibriTitle));
pdfDoc.Add(new ListItem(adresa, calibriSubTitle));
pdfDoc.Add(new ListItem(mesto, calibriSubTitle));
pdfDoc.Add(new ListItem("JIB:" + " " + jib2, calibriSubTitle));
pdfDoc.Add(new ListItem("PIB:" + " " + pib2, calibriSubTitle));
pdfDoc.Add(new ListItem("Žiro-racun:" + " " + ziro_racun2, calibriSubTitle));
pdfDoc.Add(new ListItem("E-mail:" + " " + e_mail, calibriSubTitle));
pdfDoc.Add(new ListItem(" "));
// pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" Lista maloprodajnih faktura ", calibrinaslov));
pdfDoc.Add(new ListItem(" "));
// pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
PdfContentByte cb = writer.DirectContent;
PdfContentByte cb1 = writer.DirectContent;
cb.SetColorStroke(new BaseColor(41, 128, 185));// boja linija
iTextSharp.text.Rectangle fakturisao = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 520f, 50f);
iTextSharp.text.Rectangle primio = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 60f, 50f);
iTextSharp.text.Rectangle otpremio = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 330f, 50f);
iTextSharp.text.Rectangle ukupno_za_uplatu = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 462f, 590f);
// iTextSharp.text.Rectangle slogan_korisnika2 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 340f, 10f, pdfDoc.PageSize.Width - 20f, 10f);
//cb.SetColorStroke(new CMYKColor(1f, 0f, 0f, 0f));// boja linija
// cb.SetColorStroke(new BaseColor(41,128,185));// boja linija
// cb.SetColorFill(new CMYKColor(0f, 0f, 1f, 0f));
cb1.SetLineWidth(2);
cb1.RoundRectangle(20f, 691f, 560f, 140f, 10f); // zaglavlje rectangle
cb1.Stroke();
cb.SetLineWidth(1);
cb.MoveTo(20f, 681f); //linija gornja zaglavlje
cb.LineTo(580f, 681f);
cb.Stroke();
cb.SetLineWidth(1);
cb.MoveTo(20f, 652f); // linija donja zaglavlje
cb.LineTo(580f, 652f);
cb.Stroke();
cb.SetLineWidth(0.5);
cb.MoveTo(20f, 20f); // linija donja slogan firme
cb.LineTo(585f, 20f);
cb.Stroke();
pdfDoc.Add(pdfTable);
Paragraph par = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 40.0F, BaseColor.BLACK, Element.ALIGN_RIGHT, 1)));
pdfDoc.Add(par);
double[] columnData = new double[mp_faktura_listaDataGridView.Rows.Count];
columnData = (from DataGridViewRow row in mp_faktura_listaDataGridView.Rows
where row.Cells["iznos_sa_pdv"].FormattedValue.ToString() != string.Empty
select Convert.ToDouble(row.Cells["iznos_sa_pdv"].FormattedValue)).ToArray();
label16.Text = columnData.Sum().ToString("#,0.00");
par = new Paragraph("UKUPNO: " + label16.Text + " KM", calibriukupno);
par.Alignment = Element.ALIGN_RIGHT;
pdfDoc.Add(par);
cb.SetLineWidth(0.5);
cb.MoveTo(20f, 20f); // linija donja slogan firme
cb.LineTo(585f, 20f);
cb.Stroke();
// cb.SetLineWidth(1.5);
// cb.MoveTo(5f, 5f); //linija korisnik programa
// cb.LineTo(5f, 820f);
// cb.Stroke();
pdfDoc.Close();
stream.Close();
System.Diagnostics.Process.Start(folderPath + "Lista MP faktura.pdf");
}
}
}
}
}
}

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Goran Bibic8y ago
Amit my dear friend
//Adding DataRow
           foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows)
           {

               foreach (DataGridViewCell cell in row.Cells)
               {


                   //PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString(), calibri));
                   //    pdfTable.AddCell(cell2);

                   if (cell.ColumnIndex == 2) // change 2 wiyh your datetime column
                   {
                       string dateVal = Convert.ToDateTime(cell.Value).ToString("dd-MM-yyyy"); PdfPCell cell2 = new PdfPCell(new Phrase(dateVal, calibri));
                   }

                   else
                   {
                       PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString(), calibri));
                   }
               }


   }
Amit Gupta8y ago
Look at the line no 36. You haven't applied the code that I had posted.

Please apply the code before asking that something is not working
Goran Bibic8y ago
Complete code for pdf click
private void button9_Click(object sender, EventArgs e)
        {
            //Creating iTextSharp Table from the DataTable data
            //Console.WriteLine(drzaveDataGridView.ColumnCount); test za itext sharp
            PdfPTable pdfTable = new PdfPTable(mp_faktura_listaDataGridView.ColumnCount);
            pdfTable.DefaultCell.Padding = 3;
            pdfTable.WidthPercentage = 100;
            pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
            pdfTable.DefaultCell.BorderWidth = 1;
            pdfTable.DefaultCell.BorderWidth = 1;
            float[] sirina = new float[] { 0f, 15f, 40f, 70f, 25f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f };
            pdfTable.SetWidths(sirina);
            BaseFont bfCalibri = BaseFont.CreateFont("c:\\windows\\fonts\\calibri.ttf", BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
            iTextSharp.text.Font calibri = new iTextSharp.text.Font(bfCalibri, 9);
            iTextSharp.text.Font calibri10bold3 = new iTextSharp.text.Font(bfCalibri, 9, iTextSharp.text.Font.BOLD, iTextSharp.text.BaseColor.WHITE);

            //Adding Header row
            foreach (DataGridViewColumn column in mp_faktura_listaDataGridView.Columns)
            {
                    PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText, calibri10bold3));
                cell.BackgroundColor = new iTextSharp.text.BaseColor(243, 70, 5);
                pdfTable.AddCell(cell);
            }
            //Adding DataRow
            foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows)
            {
                foreach (DataGridViewCell cell in row.Cells)
                {
                    PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString(), calibri));
                        pdfTable.AddCell(cell2);
                }
            }
    string folderPath = "C:\\PDFs\\";
            if (!Directory.Exists(folderPath))
            {
                Directory.CreateDirectory(folderPath);
            }
            using (FileStream stream = new FileStream(folderPath + "Lista MP faktura.pdf", FileMode.Create))
            {
                                iTextSharp.text.Font calibriTitle = new iTextSharp.text.Font(bfCalibri, 14, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font calibriSubTitle = new iTextSharp.text.Font(bfCalibri, 12);
iTextSharp.text.Font calibriSubTitlebold = new iTextSharp.text.Font(bfCalibri, 14, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font calibri10bold = new iTextSharp.text.Font(bfCalibri, 10, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font calibri22bold = new iTextSharp.text.Font(bfCalibri, 22, iTextSharp.text.Font.BOLDITALIC);
iTextSharp.text.Font calibrinaslov = new iTextSharp.text.Font(bfCalibri, 16);
iTextSharp.text.Font calibriukupno = new iTextSharp.text.Font(bfCalibri, 12, iTextSharp.text.Font.BOLDITALIC);
Document pdfDoc = new Document(PageSize.A4, 27f, 10f, 10f, 30f);
// PdfWriter.GetInstance(pdfDoc, stream);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
                                pdfDoc.Add(new ListItem(korisnik_programa, calibriTitle));
                                pdfDoc.Add(new ListItem(adresa, calibriSubTitle));
                                pdfDoc.Add(new ListItem(mesto, calibriSubTitle));
                                pdfDoc.Add(new ListItem("JIB:" + " " + jib2, calibriSubTitle));
                                pdfDoc.Add(new ListItem("PIB:" + " " + pib2, calibriSubTitle));
                                pdfDoc.Add(new ListItem("Žiro-racun:" + " " + ziro_racun2, calibriSubTitle));
                                pdfDoc.Add(new ListItem("E-mail:" + " " + e_mail, calibriSubTitle));
                                pdfDoc.Add(new ListItem(" "));
                                // pdfDoc.Add(new ListItem(" "));
                                pdfDoc.Add(new ListItem("                                                    Lista maloprodajnih faktura ", calibrinaslov));
                                pdfDoc.Add(new ListItem(" "));
                                // pdfDoc.Add(new ListItem(" "));
                                pdfDoc.Add(new ListItem(" "));
                                PdfContentByte cb = writer.DirectContent;
PdfContentByte cb1 = writer.DirectContent;
cb.SetColorStroke(new BaseColor(41, 128, 185));// boja linija
                                iTextSharp.text.Rectangle fakturisao = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 520f, 50f);
iTextSharp.text.Rectangle primio = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 60f, 50f);
iTextSharp.text.Rectangle otpremio = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 330f, 50f);
iTextSharp.text.Rectangle ukupno_za_uplatu = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 462f, 590f);
//     iTextSharp.text.Rectangle slogan_korisnika2 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 340f, 10f, pdfDoc.PageSize.Width - 20f, 10f);
//cb.SetColorStroke(new CMYKColor(1f, 0f, 0f, 0f));// boja linija
// cb.SetColorStroke(new BaseColor(41,128,185));// boja linija
// cb.SetColorFill(new CMYKColor(0f, 0f, 1f, 0f));
cb1.SetLineWidth(2);
                                cb1.RoundRectangle(20f, 691f, 560f, 140f, 10f); // zaglavlje rectangle
                                cb1.Stroke();
                                cb.SetLineWidth(1);
                                cb.MoveTo(20f, 681f);  //linija gornja zaglavlje
                                cb.LineTo(580f, 681f);
                                cb.Stroke();
                                cb.SetLineWidth(1);
                                cb.MoveTo(20f, 652f); // linija donja zaglavlje
                                cb.LineTo(580f, 652f);
                                cb.Stroke();
                                cb.SetLineWidth(0.5);
                                cb.MoveTo(20f, 20f); // linija donja slogan firme
                                cb.LineTo(585f, 20f);
                                cb.Stroke();
                                pdfDoc.Add(pdfTable);
                                Paragraph par = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 40.0F, BaseColor.BLACK, Element.ALIGN_RIGHT, 1)));
pdfDoc.Add(par);
                                double[] columnData = new double[mp_faktura_listaDataGridView.Rows.Count];
columnData = (from DataGridViewRow row in mp_faktura_listaDataGridView.Rows
              where row.Cells["iznos_sa_pdv"].FormattedValue.ToString() != string.Empty
              select Convert.ToDouble(row.Cells["iznos_sa_pdv"].FormattedValue)).ToArray();
label16.Text = columnData.Sum().ToString("#,0.00");

par = new Paragraph("UKUPNO:   " + label16.Text + "   KM", calibriukupno);
par.Alignment = Element.ALIGN_RIGHT;
                                pdfDoc.Add(par);
                                cb.SetLineWidth(0.5);
                                cb.MoveTo(20f, 20f); // linija donja slogan firme
                                cb.LineTo(585f, 20f);
                                cb.Stroke();
                                //     cb.SetLineWidth(1.5);
                                //   cb.MoveTo(5f, 5f);   //linija korisnik programa
                                //   cb.LineTo(5f, 820f);
                                //   cb.Stroke();

                                pdfDoc.Close();
                stream.Close();
                System.Diagnostics.Process.Start(folderPath + "Lista MP faktura.pdf");

                }
            }
            }
                }
            }
        }
Goran Bibic8y ago
No have solution?
Goran Bibic8y ago
Reslut is... in line 13 need ToString() and open pdf document
Column are mixed and datetimevalue is same 15.04.2018. 00:00:00

No have changes
Goran Bibic8y ago
I try this...in line 13 ..

Error 1: cannot convert from object to float
Error 2: cannot convert from ItextSharp.text.Font to ITextSharp.text.Chunk
foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows)
            {

                foreach (DataGridViewCell cell in row.Cells)
                {
                    if (cell.ColumnIndex == 2) // change 2 wiyh your datetime column
                    {
                        string dateVal = Convert.ToDateTime(cell.Value).ToString("dd-MM-yyyy"); PdfPCell cell2 = new PdfPCell(new Phrase(dateVal, calibri));
                    }

                     else
                    {
                        PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value, calibri));
                        pdfTable.AddCell(cell2);
                    }


        }
Amit Gupta8y ago
1. foreach (DataGridViewCell cell in row.Cells)
2. {
3. if(cell.ColnIndex ==2) // change 2 wiyh your datetime column
4. {
5. string dateVal = Convwet.ToDateTime(cell.Value).ToString("dd-MM-yyyy"); PdfPCell cell2 = new PdfPCell(new Phrase(dateVal, calibri)); }
6. }
7. else
8. PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value, calibri)); }
9. }
Just you need to verify your datetime column before converting