import pdfplumber
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
path="c:\Users\NING MEI\Desktop\filename.pdf"
pdf = pdfplumber.open(path)
print('\n')
print('開始讀取資料')
print('\n')
print(pdf.pages[1].extract_tables()[0][0])
ws.append(pdf.pages[1].extract_tables()[0][0])
for page in pdf.pages:
# print(page.extract_text())
for table in page.extract_tables():
# print(table)
for row in table:
if "序號" not in row:
# print(type(row))
rowlist=str(row).replace("[","",).replace("]","").replace("'","").replace("\\n","").split(",")
print(rowlist)
ws.append(rowlist)
print('---------- 分割線 ----------')
pdf.close()
# 保存Excel表
wb.save('filename.xlsx')
print('\n')
print('寫入excel成功')
print('保存位置：')
print('filename.xlsx')
print('\n')
報錯
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape
請問大神們這是什么原因？
uj5u.com熱心網友回復：
在那一行出錯？pdf = pdfplumber.open(path) 如果是這行。
把 path="c:\Users\NING MEI\Desktop\filename.pdf"
改成 path="c:/Users/NING MEI/Desktop/filename.pdf"
試試
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/16591.html
下一篇：selenium判斷元素是否加載