Menu
I use iTextSharp to print a grid view but I face some problems:
No arabic characters appears at all.
The direction is LTR and I wany it RTL instead.
Some columns in the gridview are templatefields (label, imagebutton,...), and I can't handle this case. I won't show all of them (like delete button , ...)
The code :
protected void ExportToPDF(GridView gvReport, bool LandScape)
{
int noOfColumns = 0, noOfRows = 0;
DataTable tbl = null;
if (gvReport.AutoGenerateColumns)
{
tbl = gvReport.DataSource as DataTable; // Gets the DataSource of the GridView Control.
noOfColumns = tbl.Columns.Count;
noOfRows = tbl.Rows.Count;
}
else
{
noOfColumns = gvReport.Columns.Count;
noOfRows = gvReport.Rows.Count;
}
float HeaderTextSize = 8;
float ReportNameSize = 10;
float ReportTextSize = 8;
float ApplicationNameSize = 7;
// Creates a PDF document
Document document = null;
if (LandScape == true)
{
// Sets the document to A4 size and rotates it so that the orientation of the page is Landscape.
document = new Document(PageSize.A4.Rotate(), 0, 0, 15, 5);
}
else
{
document = new Document(PageSize.A4, 0, 0, 15, 5);
}
// Creates a PdfPTable with column count of the table equal to no of columns of the gridview or gridview datasource.
iTextSharp.text.pdf.PdfPTable mainTable = new iTextSharp.text.pdf.PdfPTable(noOfColumns);
// Sets the first 4 rows of the table as the header rows which will be repeated in all the pages.
mainTable.HeaderRows = 4;
// Creates a PdfPTable with 2 columns to hold the header in the exported PDF.
iTextSharp.text.pdf.PdfPTable headerTable = new iTextSharp.text.pdf.PdfPTable(2);
// Creates a phrase to hold the application name at the left hand side of the header.
Phrase phApplicationName = new Phrase("Contact List", FontFactory.GetFont("Arial", ApplicationNameSize, iTextSharp.text.Font.TIMES_ROMAN));
// Creates a PdfPCell which accepts a phrase as a parameter.
PdfPCell clApplicationName = new PdfPCell(phApplicationName);
// Sets the border of the cell to zero.
clApplicationName.Border = PdfPCell.NO_BORDER;
// Sets the Horizontal Alignment of the PdfPCell to left.
clApplicationName.HorizontalAlignment = Element.ALIGN_LEFT;
// Creates a phrase to show the current date at the right hand side of the header.
Phrase phDate = new Phrase(DateTime.Now.Date.ToString("dd/MM/yyyy"), FontFactory.GetFont("Arial", ApplicationNameSize, iTextSharp.text.Font.NORMAL));
// Creates a PdfPCell which accepts the date phrase as a parameter.
PdfPCell clDate = new PdfPCell(phDate);
// Sets the Horizontal Alignment of the PdfPCell to right.
clDate.HorizontalAlignment = Element.ALIGN_RIGHT;
// Sets the border of the cell to zero.
clDate.Border = PdfPCell.NO_BORDER;
// Adds the cell which holds the application name to the headerTable.
headerTable.AddCell(clApplicationName);
// Adds the cell which holds the date to the headerTable.
headerTable.AddCell(clDate);
// Sets the border of the headerTable to zero.
headerTable.DefaultCell.Border = PdfPCell.NO_BORDER;
// Creates a PdfPCell that accepts the headerTable as a parameter and then adds that cell to the main PdfPTable.
PdfPCell cellHeader = new PdfPCell(headerTable);
cellHeader.Border = PdfPCell.NO_BORDER;
// Sets the column span of the header cell to noOfColumns.
cellHeader.Colspan = noOfColumns;
// Adds the above header cell to the table.
mainTable.AddCell(cellHeader);
// Creates a phrase which holds the file name.
Phrase phHeader = new Phrase("Contact List", FontFactory.GetFont("Arial", ReportNameSize, iTextSharp.text.Font.BOLD));
PdfPCell clHeader = new PdfPCell(phHeader);
clHeader.Colspan = noOfColumns;
clHeader.Border = PdfPCell.NO_BORDER;
clHeader.HorizontalAlignment = Element.ALIGN_CENTER;
mainTable.AddCell(clHeader);
// Creates a phrase for a new line.
Phrase phSpace = new Phrase("\n");
PdfPCell clSpace = new PdfPCell(phSpace);
clSpace.Border = PdfPCell.NO_BORDER;
clSpace.Colspan = noOfColumns;
mainTable.AddCell(clSpace);
// Sets the gridview column names as table headers.
for (int i = 0; i < noOfColumns; i++)
{
Phrase ph = null;
if (gvReport.AutoGenerateColumns)
{
ph = new Phrase(tbl.Columns[i].ColumnName, FontFactory.GetFont("Arial", HeaderTextSize, iTextSharp.text.Font.BOLD));
}
else
{
ph = new Phrase(gvReport.Columns[i].HeaderText, FontFactory.GetFont("Arial", HeaderTextSize, iTextSharp.text.Font.BOLD));
}
mainTable.AddCell(ph);
}
// Reads the gridview rows and adds them to the mainTable
for (int rowNo = 0; rowNo < noOfRows; rowNo++)
{
for (int columnNo = 0; columnNo < noOfColumns; columnNo++)
{
if (gvReport.AutoGenerateColumns)
{
string s = gvReport.Rows[rowNo].Cells[columnNo].Text.Trim();
Phrase ph = new Phrase(s, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
mainTable.AddCell(ph);
}
else
{
if (gvReport.Columns[columnNo] is TemplateField)
{
try
{
Label lc = gvReport.Rows[rowNo].Cells[columnNo].Controls[1] as Label;
string s = lc.Text.Trim();
Phrase ph = new Phrase(s, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
mainTable.AddCell(ph);
}
catch (NullReferenceException ee)
{
noOfColumns--;
}
catch (Exception ee)
{
noOfColumns--;
}
}
else
{
string s = gvReport.Rows[rowNo].Cells[columnNo].Text.Trim();
Phrase ph = new Phrase(s, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
mainTable.AddCell(ph);
}
}
}
// Tells the mainTable to complete the row even if any cell is left incomplete.
mainTable.CompleteRow();
}
// Gets the instance of the document created and writes it to the output stream of the Response object.
PdfWriter.GetInstance(document, Response.OutputStream);
// Creates a footer for the PDF document.
HeaderFooter pdfFooter = new HeaderFooter(new Phrase(), true);
pdfFooter.Alignment = Element.ALIGN_CENTER;
pdfFooter.Border = iTextSharp.text.Rectangle.NO_BORDER;
// Sets the document footer to pdfFooter.
document.Footer = pdfFooter;
// Opens the document.
document.Open();
// Adds the mainTable to the document.
document.Add(mainTable);
// Closes the document.
document.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment; filename= ContactList.pdf");
Response.End();
}
The original one is Here
I change this line and add try and catch to avoid the exception (problem 3) :
DataBoundLiteralControl lc = gvReport.Rows[rowNo].Cells[columnNo].Controls[0] as DataBoundLiteralControl;
TO
Label lc = gvReport.Rows[rowNo].Cells[columnNo].Controls[1] as Label;
How to fix these problems?
450
In the out put you can see that English Columns on LTR and Arabic Column on RTL. if you want to display GridView on page with RTL than you can use <div dir="rtl">Put the Grid View here</div>.
GridView:
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="False">
<Columns>
<asp:TemplateField HeaderText="العربية" SortExpression="العربية">
<ItemTemplate>
<asp:Label ID="arabic" runat="server" Text='<%# Eval("العربية")%>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<Columns>
<asp:TemplateField HeaderText="English" SortExpression="English">
<ItemTemplate>
<asp:Label ID="english" runat="server" Text='<%# Eval("English") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="deleteButton" runat="server" Text="Delete" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:HyperLink ID="open" runat="server" Text="Open" NavigateUrl="~/Default.aspx"/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [English], [العربية] FROM [Test]"></asp:SqlDataSource>
<br />
<asp:Button ID="btnExport" runat="server" OnClick="btnExport_Click" Text="Export to PDF" />
CS Code:
protected void ExportPDF(GridView gridViewReport)
{
int columnNumber = 0, rowNumber = 0;
DataTable tbl = null;
if (gridViewReport.AutoGenerateColumns)
{
tbl = gridViewReport.DataSource as DataTable; // Gets the DataSource of the GridView Control.
columnNumber = tbl.Columns.Count;
rowNumber = tbl.Rows.Count;
}
else
{
columnNumber = gridViewReport.Columns.Count;
rowNumber = gridViewReport.Rows.Count;
}
// Creates a PDF document
Document document = null;
document = new Document(PageSize.A4, 0, 0, 15, 5);
PdfPTable _table = new PdfPTable(GridView1.Columns.Count);
_table.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
BaseFont baseFont = BaseFont.CreateFont("c:\\\\windows\\\\fonts\\\\tahoma.ttf", BaseFont.IDENTITY_H, true); // Font which has Arabic characters
iTextSharp.text.Font font = new iTextSharp.text.Font(baseFont, 10, iTextSharp.text.Font.NORMAL);
// Sets the gridview column names as table headers.
for (int i = 0; i < columnNumber; i++)
{
iTextSharp.text.pdf.PdfPCell ph = null;
if (gridViewReport.AutoGenerateColumns)
{
ph = new PdfPCell(new Phrase(10, tbl.Columns[i].ColumnName, font));
}
else
{
ph = new PdfPCell(new Phrase(10, gridViewReport.Columns[i].HeaderText, font));
}
if (ph != null && gridViewReport.Columns[i].HeaderText != "")
{
if (Regex.IsMatch(gridViewReport.Columns[i].HeaderText, "^[a-zA-Z0-9 ]*$")) // Check if Header Text is English
{
ph.RunDirection = PdfWriter.RUN_DIRECTION_LTR; // Left to Right
BaseColor color = new BaseColor(Color.Red);
ph.BackgroundColor = color;
_table.AddCell(ph);
}
else
{
ph.RunDirection = PdfWriter.RUN_DIRECTION_RTL; //Right to Left
BaseColor color = new BaseColor(Color.Red);
ph.BackgroundColor = color;
_table.AddCell(ph);
}
}
else
{
ph.Border = iTextSharp.text.Rectangle.NO_BORDER;
_table.AddCell(ph);
}
}
// Get the gridview rows and adds them to the _table
for (int rowIteration = 0; rowIteration < rowNumber; rowIteration++)
{
for (int columnIteration = 0; columnIteration < columnNumber; columnIteration++)
{
if (gridViewReport.AutoGenerateColumns) //Check if AutoGenrated Colunms
{
string s = gridViewReport.Rows[rowIteration].Cells[columnIteration].Text.Trim();
PdfPCell ph = new PdfPCell(new Phrase(10, s, font));
_table.AddCell(ph);
}
else
{
if (gridViewReport.Columns[columnIteration] is TemplateField) // Check if Item Template
{
PdfPCell ph = null;
Label lc = gridViewReport.Rows[rowIteration].Cells[columnIteration].Controls[1] as Label; // Label
Button btn = gridViewReport.Rows[rowIteration].Cells[columnIteration].Controls[1] as Button;// Button
HyperLink hyperLink = gridViewReport.Rows[rowIteration].Cells[columnIteration].Controls[1] as HyperLink; // HyperLink
if (lc != null)
{
string s = lc.Text.Trim();
ph = new PdfPCell(new Phrase(10, s, font));
if (Regex.IsMatch(s, "^[a-zA-Z0-9 ]*$")) //Check if cell string is English
{ ph.RunDirection = PdfWriter.RUN_DIRECTION_LTR; // Left to Right
_table.AddCell(ph);
}
else
{
ph.RunDirection = PdfWriter.RUN_DIRECTION_RTL; // Right to Left
_table.AddCell(ph);
}
}
else if (btn != null)
{
ph = new PdfPCell(new Phrase(10, btn.Text, font));
ph.Phrase.Clear(); // Clear the Cell Phrase
ph.Border = iTextSharp.text.Rectangle.NO_BORDER;
_table.AddCell(ph);
}
else if (hyperLink != null)
{
ph = new PdfPCell(new Phrase(10, hyperLink.Text, font));
ph.Phrase.Clear(); //Clear the Cell Phrase
ph.Border = iTextSharp.text.Rectangle.NO_BORDER;
_table.AddCell(ph);
}
else
{
_table.AddCell("--");
}
}
else
{
string s = gridViewReport.Rows[rowIteration].Cells[columnIteration].Text.Trim();
PdfPCell ph = new PdfPCell(new Phrase(10, s, font));
_table.AddCell(ph);
}
}
}
_table.CompleteRow();
}
PdfWriter.GetInstance(document, Response.OutputStream);
// Opens the document.
document.Open();
// Adds the _table to the document.
document.Add(_table);
// Closes the document.
document.Close();
Page.Response.ContentType = "application/pdf";
Page.Response.AddHeader("content-disposition", "attachment;filename=MyGrid.pdf");
Page.Response.Cache.SetCacheability(HttpCacheability.NoCache);
Page.Response.Write(document);
Page.Response.End();
}
This code might not be the perfectly coded but I hope this will help you to get your required results.
183
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
