In this article I will explain how to export DataGridView data to PDF file in Windows Forms (WinForms) Applications using iTextSharp PDF. Hi! I have a datagrid that I want to transfer to a PDF Im using iTextSharp and VB How?!? J.O. hi all i have successfully created a PDF button, but the problem is that when i export my data grid to PDF format it doesn’t show all my data.

Export datagridview data to pdf C#

As I said before, if there is empty in the datagridview-cell, the type of this cell is null, so the reason of this error message is there are some empty cells and I guess they belong to the last line.

But I guess maybe not only the last line is empty, other cells may also be empty, so you can determine whether it is empty and if so, replace it with a specific character:. This can be beneficial to other community members reading this thread.

You only output data for each row of cells in datagridview without outputting the data for each column header, I suggest you can add it:. This site uses cookies for analytics, personalized content and ads.

By continuing to browse this site, you agree to this use. Remove From My Forums. Windows Forms General https: Sign in to vote.

Saving datagridview to PDF using iTextSharp?

Here’s my current code GetInstance pdf, new FileStream savepdf. Add pdfTable ; cb.

Friday, June 9, 6: So you can use the for statement instead of foreach to exclude the last line: The above method that using for statement can also solve this confusion.

But I guess maybe not only the last line is empty, other cells may also be empty, so you can determine whether it is empty and if so, replace it with a specific character: A2, 10f, 10f, 10f, 0f ; PdfWriter.

GetInstance pdfDoc, stream ; pdfDoc. Add pdfTable ; pdfDoc. Tuesday, June 13, 9: Hi Rob, I tried to test your code and then found a few deficiencies: You only output data for each row of cells in datagridview without outputting the data for each column header, I suggest you can add it: Object datagridvlew not set to an instance of an object.

Please add the below code in the form load event: Monday, June 12, 5: I’m getting this error: An unhandled exception of type ‘System. NullReferenceException’ occurred in Weatherization Assessor. It is highlighting the itetxsharp line: ToString ; And I cannot add your above code to keep it from happening because users need to able to add rows.

That’s the point of the datagridview. It doesn’t load data from a spreadsheet, users are inputting their own data. Edited by Robmeister Monday, June 12, 1: Monday, June 12, 1: