Google Spreadsheet作为data table动态加载到Web page

import sys import os from PyQt5.QtWidgets import (QApplication, QMainWindow, QWidget, QVBoxLayout, QPushButton, QLabel, QFileDialog, QProgressBar, QMessageBox) from PyQt5.QtCore import Qt, QThread, pyqtSignal from openpyxl import Workbook, load_workbook from openpyxl.drawing.image import Image as xlImage from openpyxl.drawing.spreadsheet_drawing import OneCellAnchor, AnchorMarker from openpyxl.utils import range_boundaries from openpyxl.worksheet.page import PageMargins import docx from openpyxl.drawing.xdr import XDRPositiveSize2D from openpyxl.styles import Alignment, Font, Border, Side from openpyxl.utils.units import pixels_to_EMU def resource_path(relative_path): """ 获取打包后的资源绝对路径 """ try: base_path = sys._MEIPASS # 临时解压目录 except AttributeError: base_path = os.path.abspath(".") return os.path.join(base_path, relative_path) # 在程序启动时设置Qt插件路径 if __name__ == '__main__': os.environ["QT_QPA_PLATFORM_PLUGIN_PATH"] = resource_path("PyQt5/Qt5/plugins") class FileProcessor(QThread): progress_updated = pyqtSignal(int, int, str) # (current, total, filename) finished = pyqtSignal(dict) # 结果数据 def __init__(self, input_dir, output_dir, desc_excel_path): super().__init__() self.input_dir = input_dir self.output_dir = output_dir self.desc_excel_path = desc_excel_path self.running = True self.desc_data = [] def run(self): try: # 读取描述数据 if self.desc_excel_path and os.path.exists(self.desc_excel_path): wb = load_workbook(self.desc_excel_path, read_only=True) ws = wb.active for row in ws.iter_rows(min_col=1, max_col=1, values_only=True): self.desc_data.append(str(row[0]) if row[0] is not None else "") wb.close() doc_files = [f for f in os.listdir(self.input_dir) if f.lower().endswith('.docx')]
03-12
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值