英文:
Transform a json file into a pdf
问题
你应该将一个JSON文件转换为PDF。我在创建一个表格时遇到了困难，这个表格可以自动换行过长的项目，而不会溢出到右侧。
以下是你提供的JSON代码和Python实现：
import jsonfrom fpdf import FPDFimport pandas as pdwith open('input.json') as f:data = json.load(f)pdf = FPDF()pdf.add_page()pdf.set_font('Arial', 'B', 16)# 标题pdf.cell(0, 10, '检查摘要', 0, 1)pdf.set_font('Arial', '', 12)df = pd.DataFrame(data['allIssues'])df = df[['ruleId', 'description', 'help', 'impact', 'selector', 'summary', 'source']]col_width = pdf.w / 2.2row_height = pdf.font_size * 2for issue in df.itertuples(index=False):data = [['ruleId:', str(issue.ruleId)],['description:', issue.description],['help:', issue.help],['impact:', issue.impact],['selector:', issue.selector],['summary:', issue.summary],['source:', issue.source],]# 绘制表格for row in data:pdf.multi_cell(col_width, row_height, str(row[0]), border=0)pdf.multi_cell(col_width, row_height, str(row[1]), border=0)pdf.ln(row_height)# 在表格之间绘制线pdf.line(10, pdf.get_y(), pdf.w - 10, pdf.get_y())pdf.ln(row_height)pdf.output('output.pdf', 'F')
你的实现中似乎有一个问题，导致文本溢出。要解决这个问题，你可以使用MultiCell方法来处理文本的自动换行，而不是MultiCell方法。在MultiCell方法中，你可以设置一个最大宽度，以确保文本自动换行。
要实现你想要的效果，可以尝试使用以下代码替换你的循环部分：
# Draw tablefor row in data:pdf.multi_cell(col_width, row_height, str(row[0]), border=0)pdf.multi_cell(col_width, row_height, str(row[1]), border=0)pdf.ln()
这应该允许文本自动换行并防止溢出到右侧。这样应该更接近你期望的效果。
希望这能帮助你实现你想要的PDF输出。
英文:
I should transform a json file into pdf. I'm having trouble creating a table that allows me to make items that are too long wrap automatically and not overflow to the right side.
I paste an example of the json code that I should transform into pdf and then my implementation in python (which unfortunately returns a bad result)
json code:
"allIssues":[{"ruleId":"name","description":"Description123","help":"Description234","impact":"critical","selector":["abc1234"],"summary":"long text","source":"long text2",},{...},]
My python implementation:
import jsonfrom fpdf import FPDFimport pandas as pdwith open('input.json') as f:data = json.load(f)pdf = FPDF()pdf.add_page()pdf.set_font('Arial', 'B', 16)# Titlepdf.cell(0, 10, 'Inspection summary', 0, 1)pdf.set_font('Arial', '', 12)df = pd.DataFrame(data['allIssues'])df = df[['ruleId', 'description', 'help', 'impact', 'selector', 'summary', 'source']]col_width = pdf.w / 2.2row_height = pdf.font_size * 2for issue in df.itertuples(index=False):data = [['ruleId:', str(issue.ruleId)],['description:', issue.description],['help:', issue.help],['impact:', issue.impact],['selector:', issue.selector],['summary:', issue.summary],['source:', issue.source],]# Draw tablefor row in data:pdf.multi_cell(col_width, row_height, str(row[0]), border=0)pdf.multi_cell(col_width, row_height, str(row[1]), border=0)pdf.ln(row_height)# Draw line between tablespdf.line(10, pdf.get_y(), pdf.w - 10, pdf.get_y())pdf.ln(row_height)pdf.output('output.pdf', 'F')
This is a screenshot of the output:
This is what I'm trying to achive
Can you give me a hand? is it feasible to create something nice?
答案1
得分: 1
以下是翻译好的内容：
"There seems to be a lot of steps in your code. You could simply loop over the columns of your transposed df and export each of them to html. Append all html tables to a root html element and export with pdfkit:
import jsonimport pandas as pdimport lxml.etree as etimport pdfkityour_json = """{"url": "https://www.abc123.com", "extensionVersion": "4.51.0", "axeVersion": "4.6.3", "standard": "WCAG 2.1 AA", "testingStartDate": "2023-04-03T09:35:06.177Z", "testingEndDate": "2023-04-03T09:35:06.177Z", "bestPracticesEnabled": false, "issueSummary": {"critical": 2, "moderate": 0, "minor": 0, "serious": 0, "bestPractices": 0, "needsReview": 0}, "remainingTestingSummary": {"run": false}, "igtSummary": [], "failedRules": [{"name": "button-name", "count": 1, "mode": "automated"}, {"name": "select-name", "count": 1, "mode": "automated"}], "needsReview": [], "allIssues": [{"ruleId": "button-name", "description": "Ensures buttons have discernible text", "help": "Buttons must have discernible text", "helpUrl": "https://www.abc123.com", "impact": "critical", "needsReview": false, "isManual": false, "selector": [".livechat-button"], "summary": "Fix any of the following:\\n Element does not have inner text that is visible to screen readers\\n aria-label attribute does not exist or is empty\\n aria-labelledby attribute does not exist, references elements that do not exist or references elements that are empty\\n Element has no title attribute\\n Element's default semantics were not overridden with role=\\"none\\" or role=\\"presentation\\"", "source": "<button class=\\"livechat-button items-center bg-black shadow-liveChat rounded-full text-white p-2 h-12 transition-all opacity-0 pointer-events-none w-sp-48 opacity-0 pointer-events-none\\">", "tags": ["cat.name-role-value", "wcag2a", "wcag412", "section508", "section508.22.a", "ACT"], "igt": "", "shareURL": "", "createdAt": "2023-04-03T09:35:06.177Z", "testUrl": "", "testPageTitle": "ABC123", "foundBy": "ab@bc.com", "axeVersion": "4.6.3"}, {"ruleId": "select-name", "description": "Ensures select element has an accessible name", "help": "Select element must have an accessible name", "helpUrl": "https://www.abc123.com", "impact": "critical", "needsReview": false, "isManual": false, "selector": ["#plp__sortSelected"], "summary": "Fix any of the following:\\n Form element does not have an implicit (wrapped) <label>\\n Form element does not have an explicit <label>\\n aria-label attribute does not exist or is empty\\n aria-labelledby attribute does not exist, references elements that do not exist or references elements that are empty\\n Element has no title attribute\\n Element's default semantics were not overridden with role=\\"none\\" or role=\\"presentation\\"", "source": "<select class=\\"w-full absolute opacity-0 appearance-none text-value-small font-bold text-black uppercase cursor-pointer bg-transparent outline-0\\" id=\\"plp__sortSelected\\">", "tags": ["cat.forms", "wcag2a", "wcag412", "section508", "section508.22.n", "ACT"], "igt": "", "shareURL": "", "createdAt": "2023-04-03T09:35:06.177Z", "testUrl": "https://www.abc123.com", "testPageTitle": "ABC123", "foundBy": "ab@bc.com", "axeVersion": "4.6.3"}]}""""请注意，以上是代码部分，不进行翻译。<details><summary>英文:</summary>There seems to be a lot of steps in your code. You could simply loop over the columns of your transposed df and export each of them to html. Append all html tables to a root html element and export with `pdfkit`:```pythonimport jsonimport pandas as pdimport lxml.etree as etimport pdfkityour_json = """{"url": "https://www.abc123.com", "extensionVersion": "4.51.0", "axeVersion": "4.6.3", "standard": "WCAG 2.1 AA", "testingStartDate": "2023-04-03T09:35:06.177Z", "testingEndDate": "2023-04-03T09:35:06.177Z", "bestPracticesEnabled": false, "issueSummary": {"critical": 2, "moderate": 0, "minor": 0, "serious": 0, "bestPractices": 0, "needsReview": 0}, "remainingTestingSummary": {"run": false}, "igtSummary": [], "failedRules": [{"name": "button-name", "count": 1, "mode": "automated"}, {"name": "select-name", "count": 1, "mode": "automated"}], "needsReview": [], "allIssues": [{"ruleId": "button-name", "description": "Ensures buttons have discernible text", "help": "Buttons must have discernible text", "helpUrl": "https://www.abc123.com", "impact": "critical", "needsReview": false, "isManual": false, "selector": [".livechat-button"], "summary": "Fix any of the following:\\n Element does not have inner text that is visible to screen readers\\n aria-label attribute does not exist or is empty\\n aria-labelledby attribute does not exist, references elements that do not exist or references elements that are empty\\n Element has no title attribute\\n Element's default semantics were not overridden with role=\\"none\\" or role=\\"presentation\\"", "source": "<button class=\\"livechat-button items-center bg-black shadow-liveChat rounded-full text-white p-2 h-12 transition-all opacity-0 pointer-events-none w-sp-48 opacity-0 pointer-events-none\\">", "tags": ["cat.name-role-value", "wcag2a", "wcag412", "section508", "section508.22.a", "ACT"], "igt": "", "shareURL": "", "createdAt": "2023-04-03T09:35:06.177Z", "testUrl": "", "testPageTitle": "ABC123", "foundBy": "ab@bc.com", "axeVersion": "4.6.3"}, {"ruleId": "select-name", "description": "Ensures select element has an accessible name", "help": "Select element must have an accessible name", "helpUrl": "https://www.abc123.com", "impact": "critical", "needsReview": false, "isManual": false, "selector": ["#plp__sortSelected"], "summary": "Fix any of the following:\\n Form element does not have an implicit (wrapped) <label>\\n Form element does not have an explicit <label>\\n aria-label attribute does not exist or is empty\\n aria-labelledby attribute does not exist, references elements that do not exist or references elements that are empty\\n Element has no title attribute\\n Element's default semantics were not overridden with role=\\"none\\" or role=\\"presentation\\"", "source": "<select class=\\"w-full absolute opacity-0 appearance-none text-value-small font-bold text-black uppercase cursor-pointer bg-transparent outline-0\\" id=\\"plp__sortSelected\\">", "tags": ["cat.forms", "wcag2a", "wcag412", "section508", "section508.22.n", "ACT"], "igt": "", "shareURL": "", "createdAt": "2023-04-03T09:35:06.177Z", "testUrl": "https://www.abc123.com", "testPageTitle": "ABC123", "foundBy": "ab@bc.com", "axeVersion": "4.6.3"}]}"""data = json.loads(your_json)## replace the above lines with the following in your case# with open('your_file.json', 'r') as f:# data = json.load(f)html = et.Element("html")# general infohtml.append(et.fromstring(f"""<h3>Site link: <a href="{data['url']}">{data['url']}</a></h3>"""))html.append(et.fromstring(f"""<h4>Date: {data['testingEndDate']}</h4>"""))html.append(et.fromstring(f"""<h4>Summary:</h4>"""))# summary tablesummary = pd.Series(data['issueSummary'])summary_table = et.fromstring(summary.to_frame().to_html(header=False))summary_table.set('class', 'summary')html.append(summary_table)# issue tablescols_of_interest = ['ruleId', 'description', 'help', 'impact', 'selector', 'summary', 'source']df = pd.DataFrame(data['allIssues'])[cols_of_interest].Tfor col in df.columns:table = et.fromstring(df[[col]].to_html(header=False))table.set('class', 'issue')html.append(table)html.append(et.fromstring('<br/>'))pdfkit.from_string(et.tostring(html, encoding="unicode"), "./output.pdf", css='style.css')
With the following css file:
/* style.css */* {font-family: 'Liberation Sans';}table {margin: 20px;margin-left: auto;margin-right: auto;}table.summary {width: 50%;}table.issue{border: 0;width: 100%;border-collapse: collapse;}table.issue td,table.issue th {border: 0;text-align: left;padding: 5px;}table.issue tr {border-bottom: 1px solid #dddddd;}
You'll get:
Edit: updated json with the data you provided + exporting additional data + improved css
Note: you will need to install wkhtmltopdf and make sure that it is in your path.
Edit2: limiting output to desired fields
答案2
得分: 0
免责声明: 我是这个答案中使用的 borb 库的作者。
假设您的数据如下所示：
data = [{"ruleId":"name","description":"Description123","help":"Description234","impact":"critical","selector":["abc1234"],"summary":"long text","source":"long text2",},]
您可以运行以下代码：
from borb.pdf import Document, Page, PageLayout, SingleColumnLayout, Paragraph, HexColor, Table, TableUtilfrom decimal import Decimal# 创建一个空文档doc: Document = Document()# 创建一个空页面page: Page = Page()doc.add_page(page)# 使用 PageLayout 来方便地添加内容layout: PageLayout = SingleColumnLayout(page)# 为每个问题生成一个表格for i, issue in enumerate(data):# 添加标题 (段落)layout.add(Paragraph("Issue %d" % i, font_size=Decimal(20), font_color=HexColor("#B5F8FE")))# 添加表格 (使用方便的 TableUtil 类)table: Table = TableUtil.from_2d_array([["Rule ID", issue.get("ruleId", "N.A.")],["Description", issue.get("description", "N.A.")],["Help", issue.get("help", "N.A.")],["Impact", issue.get("impact", "N.A.")],["Selector", str(issue.get("selector", []))],["Summary", issue.get("summary", "N.A.")],["Source", issue.get("source", "N.A.")],], header_row=False, header_col=True, flexible_column_width=False)layout.add(table)# 存储为 PDFwith open("output.pdf", "wb") as fh:PDF.dumps(fh, doc)
这将生成以下 PDF：
英文:
disclaimer: I am the author of borb, the library used in this answer.
Assuming your data looks like this:
data = [{"ruleId":"name","description":"Description123","help":"Description234","impact":"critical","selector":["abc1234"],"summary":"long text","source":"long text2",},]
You can run the following code:
from borb.pdf import Document, Page, PageLayout, SingleColumnLayout, Paragraph, HexColor, Table, TableUtilfrom decimal import Decimal# create empty documentdoc: Document = Document()# create empty pagepage: Page = Page()doc.add_page(page)# use a PageLayout to be able to add things easilylayout: PageLayout = SingleColumnLayout(page)# generate a Table for each issuefor i, issue in enumerate(data):# add a header (Paragraph)layout.add(Paragraph("Issue %d" % i, font_size=Decimal(20), font_color=HexColor("#B5F8FE")))# add a Table (using the convenient TableUtil class)table: Table = TableUtil.from_2d_array([["Rule ID", issue.get("ruleId", "N.A.")],["Description", issue.get("description", "N.A.")],["Help", issue.get("help", "N.A.")],["Impact", issue.get("impact", "N.A.")],["Selector", str(issue.get("selector", []))],["Summary", issue.get("summary", "N.A.")],["Source", issue.get("source", "N.A.")],], header_row=False, header_col=True, flexible_column_width=False)layout.add(table)# store the PDFwith open("output.pdf", "wb") as fh:PDF.dumps(fh, doc)
This generates the following PDF:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论