keep the table grid lines align when use Chinese fonts

[l1t1]

Is your feature request related to a problem? Please describe.
I want to the output the query result of duckdb to a pdf file.
when I use font name "Courier", It cannot output the grid lines and Chinese charactors, so I visit
#329 and use "china-s", it shows the output, but the grid lines are not aligned.

Describe the solution you'd like
It output to pdf like windows CMD or NotePad does.

Describe alternatives you've considered
Are there several options for how your request could be met?

Additional context

import pymupdf
import duckdb
text = duckdb.sql("select '张三' 名字") # some text
doc = pymupdf.open() # empty pdf
text1=str(text)
print(text1)
n = doc.insert_page(-1, # default insertion point
                    text = text1, 
                    fontsize = 11,
                    width = 595,
                    height = 842,
                    fontname = "china-s", # or "Courier"
                    fontfile = None, # any font file name
                    color = (0, 0, 0)) # text color (RGB)
doc.save(
    "duckdboutput.pdf",
)

it output
┌─────────┐
│  名字   │
│ varchar │
├─────────┤
│ 张三    │
└─────────┘

duckdboutput.pdf

[JorjMcKie]

This is not an enhancement request.
You are asking for advice on how to draw table structures and fill them with some text.
Therefore transferring this to a Discussions item.

[JorjMcKie]

In PyMuPDF, there are several ways to do this.

• Option 1: Define a table within a given rectangle of a page, draw the cell gridlines and fill them with arbitrary text using page.insert_htmlbox() for each table cell.

• Option 2: Define a table completely in HTML syntax and output this on a selected rectangle on the page using page.insert_htmlbox(). In this case, table cell dimensioning and all the styling is done automatically.

Example for option 1:

import pymupdf

doc = pymupdf.open()
page = doc.new_page()
rect = pymupdf.Rect(100, 100, 400, 400)
cols = 3
rows = 5
cells = pymupdf.make_table(rect, rows=rows, cols=cols)
for i in range(rows):
    for j in range(cols):
        page.draw_rect(cells[i][j], color=(1, 0, 0))
        page.insert_htmlbox(cells[i][j], f"第 {i} 行、第 {j} 列的任意文本")
doc.ez_save("x.pdf")

[l1t1]

it's not a draw table question.
as text1 is a plain text string.

[JorjMcKie]

Well, then pass that string into page.insert_htmlbox() and see what happens.

[l1t1]

@JorjMcKie
thanks for your options, I need to convert the results to a list or a data frame first to use it.

[l1t1]

I tried

page = doc.new_page()
page.insert_htmlbox(page.rect,text1)

it output the text without new lines, in other words, it omits the \n chars in the string.

[JorjMcKie]

do text = text.replace("\n","<br>").

[JorjMcKie]

the method interprets the passed-in text as html syntax.

[l1t1]

page.insert_htmlbox(page.rect,text1.replace("\n","<br>")) output multiple lines, but it's gridlines are still not aligned.
btw, the file size increased to 3 MB from original 2KB.

[JorjMcKie]

Use doc.subset_fonts() before you save using doc.ez_save().
Also recommend to read the documentation!

[JorjMcKie]

Lines are no text. So don't be surprised if text strings that contain Unicode characters that look like line elements do not follow an alignment by some magic.
In your input text, you must differentiate between actual text components and other Unicodes that should be interpreted as graphical.

[l1t1]

btw, by using wkhtmltopdf tools can output a fine aligned pdf. --not yet,see
\wkhtmltox\bin\wkhtmltopdf \htm.txt wkhtmltopdf.pdf
wkhtmltopdf.pdf

the notepad print to pdf does output a fine aligned pdf, see
notepadprint.pdf

[l1t1]

doc.subset_fonts()
doc.ez_save()

reduces the file size, but also cannot display the horizon gridlines. such as

┌─────────┐ cannot display this line
│ 名字 │
 varchar 
├─────────┤ cannot display this line
│ 张三 │
└────────  cannot display this line

[l1t1]

I tried many fonts,
china-s show all, but the english letters with space
cjk show all, but cannot aligned
ubuntm show only non-Chinese content, and aligned

[l1t1]

I solved the question by using a font file
page.insert_text((0,0),text1,fontname="milk",fontfile='d:/milky-term-cn-normal.ttf')