从GridView输出到PDF的数据有编码问题

本文关键字:数据 编码 问题 PDF GridView 输出 | 更新日期: 2023-09-27 18:05:18

我正在从页面上的gridview生成PDF(使用iTextSharp),但是PDF输出有编码问题。例如在页面上:

Aplicação para posicionar

在PDF上显示如下:

Aplicação para posicionar

我是一个直接从gridview生成这个,因为我需要用户输入(例如复选框),所以我不能从数据库中读取此数据。我假设某种编码/解码是有序的,但我在这里相当茫然。

创建PDF的步骤:

BaseFont helvetica = BaseFont.CreateFont(BaseFont.HELVETICA, BaseFont.CP1252, false);
Font helvetica14 = new Font(helvetica, 14, Font.NORMAL);
Font helvetica12BOLDITALIC = new Font(helvetica, 12, Font.BOLDITALIC);
Font helvetica8BOLDITALIC = new Font(helvetica, 8, Font.BOLDITALIC);
Font helvetica6 = new Font(helvetica, 6, Font.NORMAL);
//Create PDF document
Document doc = new Document(PageSize.A4);
MemoryStream outputStream = new MemoryStream();
PdfWriter.GetInstance(doc, outputStream);
doc.Open();

        //Add title
        doc.Add(new Paragraph(importantlblTitleGlobal + "'n'n'n'n", helvetica14));
        //Copy the Api Transaction table
        if (detailsApiTransactionRowCount > 1)
        {
            //Create PDF table
            PdfPTable tableDetailsInput = new PdfPTable(detailsApiTransactionCellCount);

            //Create title table
            PdfPCell cell = new PdfPCell(new Phrase("Api Transaction List", helvetica12BOLDITALIC));
            cell.BackgroundColor = new BaseColor(128, 128, 128);
            cell.Colspan = detailsApiTransactionCellCount;
            cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right
            tableDetailsInput.AddCell(cell);
            string[] headers = { "Transaction Name", "Transaction Description" };
            for (iteratorCell = 0; iteratorCell < detailsApiTransactionCellCount; iteratorCell++)
            {
                PdfPCell newCell = new PdfPCell(new Phrase(headers[iteratorCell], helvetica8BOLDITALIC));
                newCell.BackgroundColor = new BaseColor(192, 192, 192);
                tableDetailsInput.AddCell(newCell);
            }
            //Create content table
            for (iteratorRow = 0; iteratorRow < detailsApiTransactionRowCount; iteratorRow++)
            {
                for (iteratorCell = 0; iteratorCell < detailsApiTransactionCellCount; iteratorCell++)
                {
                    Phrase newPhrase = new Phrase(apiTransactionListGrid.Rows[iteratorRow].Cells[iteratorCell].Text, helvetica6);
                    tableDetailsInput.AddCell(newPhrase);
                }
            }
            doc.Add(tableDetailsInput);
        }

        //Line break
        doc.Add(new Paragraph("'n'n'n"));
        //Copy the INPUT/OUTPUT table
        if (detailsInputOutputRowCount > 0)
        {
            //Create PDF table
            PdfPTable tableDetailsInputOutput = new PdfPTable(detailsInputOutputCellCount);

            //Create title table
            PdfPCell cell = new PdfPCell(new Phrase("Input/Output Details", helvetica12BOLDITALIC));
            cell.BackgroundColor = new BaseColor(128, 128, 128);
            cell.Colspan = detailsInputOutputCellCount;
            cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right
            tableDetailsInputOutput.AddCell(cell);

            //Create headers table
            string[] headers = { "Name", "Format", "Description", "Observation", "isInput", "isOutput", "SpecialType" };
            for (iteratorCell = 0; iteratorCell < detailsInputOutputCellCount; iteratorCell++)
            {
                PdfPCell newCell = new PdfPCell(new Phrase(headers[iteratorCell], helvetica8BOLDITALIC));
                newCell.BackgroundColor = new BaseColor(192, 192, 192);
                tableDetailsInputOutput.AddCell(newCell);
            }
            for (iteratorRow = 0; iteratorRow < detailsInputOutputRowCount; iteratorRow++)
            {
                for (iteratorCell = 0; iteratorCell < detailsInputOutputCellCount; iteratorCell++)
                {
                    switch (iteratorCell)
                    {
                        case 3:
                            {
                                if (apiInputOutputGrid.Rows[iteratorRow].Cells[iteratorCell].Text == "&nbsp;")
                                    tableDetailsInputOutput.AddCell(new Phrase("", helvetica6));
                                else
                                    tableDetailsInputOutput.AddCell(new Phrase(apiInputOutputGrid.Rows[iteratorRow].Cells[iteratorCell].Text, helvetica6));
                            }
                            break;
                        case 4:
                            {
                                if (iteratorRow >= 9)
                                {
                                    Phrase newPhrase = new Phrase("", helvetica6);
                                    if (booleanIsInput[iteratorRow])
                                    {
                                        newPhrase = new Phrase("X", helvetica6);
                                        tableDetailsInputOutput.AddCell(newPhrase);
                                    }
                                    else
                                        tableDetailsInputOutput.AddCell(newPhrase);
                                }
                                else
                                {
                                    Phrase newPhrase = new Phrase("", helvetica6);
                                    PdfPCell newCell = new PdfPCell(newPhrase);
                                    newCell.BackgroundColor = new BaseColor(192, 192, 192);
                                    tableDetailsInputOutput.AddCell(newCell);
                                }
                            }
                            break;
                        case 5:
                            {
                                if (iteratorRow >= 9)
                                {
                                    Phrase newPhrase = new Phrase("", helvetica6);
                                    if (booleanIsOutput[iteratorRow])
                                    {
                                        newPhrase = new Phrase("X", helvetica6);
                                        tableDetailsInputOutput.AddCell(newPhrase);
                                    }
                                    else
                                        tableDetailsInputOutput.AddCell(newPhrase);
                                }
                                else
                                {
                                    Phrase newPhrase = new Phrase("", helvetica6);
                                    PdfPCell newCell = new PdfPCell(newPhrase);
                                    newCell.BackgroundColor = new BaseColor(192, 192, 192);
                                    tableDetailsInputOutput.AddCell(newCell);
                                }
                            }
                            break;
                        case 6:
                            {
                                tableDetailsInputOutput.AddCell(new Phrase(specialType[iteratorRow], helvetica6));
                            }
                            break;
                        default:
                            tableDetailsInputOutput.AddCell(new Phrase(apiInputOutputGrid.Rows[iteratorRow].Cells[iteratorCell].Text, helvetica6));
                            break;
                    }
                }
            }
            doc.Add(tableDetailsInputOutput);
        }

                //CloseDocument
                doc.Close();
                //Clear the response buffer'
                Response.Clear();
                //Set the output type as a PDF'
                Response.ContentType = "application/pdf";
                //Disable caching'
                Response.AddHeader("Expires", "0");
                Response.AddHeader("Cache-Control", "");
                //Set the filename'
                string filename = "filename.pdf";
                filename = filename.Replace(' ', '_');
                Response.AddHeader("Content-Disposition", "attachment; filename=" + filename);
                //Set the length of the file so the browser can display an accurate progress bar'
                Response.AddHeader("Content-length", outputStream.GetBuffer().Length.ToString());
                //Write the contents of the memory stream'
                Response.OutputStream.Write(outputStream.GetBuffer(), 0, outputStream.GetBuffer().Length);
                //Close the response stream'
                Response.End();

提示吗?

编辑:添加新行。页面是UTF-8,当我定义基字体时,我无法在iTextSharp的常量中找到UTF。我刚刚在adobereader中检查了PDF文件的属性,它说它的编码是Ansi。

谢谢。

从GridView输出到PDF的数据有编码问题

尝试从网格中解码文本,即改为

apiInputOutputGrid.Rows[iteratorRow].Cells[iteratorCell].Text
use (from System.Web):
HttpUtility.HtmlDecode(apiInputOutputGrid.Rows[iteratorRow].Cells[iteratorCell].Text)

要么是pdf组件的编码问题,pdf的解析,要么是从网格返回的数据可能不是新的信息:)检查网格结果并查看每个字段等。它们都被编码了吗?有些东西是html编码-所以需要弄清楚它是你的网格代码还是pdf代码。

将此添加到您的函数中:

Response.charset="utf-8"

…或者应该是什么字符集,如果不是utf-8,也许是拉丁1?

否则,这篇文章看起来可能与你的有关:Html到pdf的一些字符丢失(itextsharp)