#!/usr/bin/env python
# -*- coding: utf-8 -*-
'''
Created on 2017年4月6日
@author: Irony."[諷刺]
@site: https://pyqt5.com , https://github.com/892768447
@email: [email protected]
@file: ViewOffice
@description:
'''
from PyQt5.QAxContainer import QAxWidget
from PyQt5.QtWidgets import QWidget, QVBoxLayout, QPushButton, QFileDialog,\
QMessageBox
__Author__ = "By: Irony.\"[諷刺]\nQQ: 892768447\nEmail: [email protected]"
__Copyright__ = "Copyright (c) 2017 Irony.\"[諷刺]"
__Version__ = "Version 1.0"
class AxWidget(QWidget):
def __init__(self, *args, **kwargs):
super(AxWidget, self).__init__(*args, **kwargs)
self.resize(800, 600)
layout = QVBoxLayout(self)
self.axWidget = QAxWidget(self)
layout.addWidget(self.axWidget)
layout.addWidget(QPushButton('選擇excel,word,pdf檔案',
self, clicked=self.onOpenFile))
def onOpenFile(self):
path, _ = QFileDialog.getOpenFileName(
self, '請選擇檔案', '', 'excel(*.xlsx *.xls);;word(*.docx *.doc);;pdf(*.pdf)')
if not path:
return
if _.find('*.doc'):
return self.openOffice(path, 'Word.Application')
if _.find('*.xls'):
return self.openOffice(path, 'Excel.Application')
if _.find('*.pdf'):
return self.openPdf(path)
def openOffice(self, path, app):
self.axWidget.clear()
if not self.axWidget.setControl(app):
return QMessageBox.critical(self, '錯誤', '沒有安裝 %s' % app)
self.axWidget.dynamicCall(
'SetVisible (bool Visible)', 'false') # 不顯示窗體
self.axWidget.setProperty('DisplayAlerts', False)
self.axWidget.setControl(path)
def openPdf(self, path):
self.axWidget.clear()
if not self.axWidget.setControl('Adobe PDF Reader'):
return QMessageBox.critical(self, '錯誤', '沒有安裝 Adobe PDF Reader')
self.axWidget.dynamicCall('LoadFile(const QString&)', path)
def closeEvent(self, event):
self.axWidget.close()
self.axWidget.clear()
self.layout().removeWidget(self.axWidget)
del self.axWidget
super(AxWidget, self).closeEvent(event)
if __name__ == '__main__':
import sys
from PyQt5.QtWidgets import QApplication
app = QApplication(sys.argv)
w = AxWidget()
w.show()
sys.exit(app.exec_())
一鍵複制
編輯
Web IDE
原始資料
按行檢視
曆史