Call and Run PyQGIS script by plugin

Question

I wrote a code that work well in console python, an example:

from qgis.core import QgsProject, QgsLayerTreeGroup, QgsLayerTreeLayer, QgsLayerTree
from PyQt5.QtCore import Qt, QVariant, QSettings, QTranslator, qVersion, 

QCoreApplication
from PyQt5 import QtGui
from PyQt5.QtGui import QAction, QIcon, QFileDialog, QProgressDialog, QProgressBar, QShortcut, QKeySequence
from osgeo import ogr
from shutil import copyfile

from urllib.request import urlopen
import re

import processing, glob, os, time


newLyrName1 = '1_PdR da controllare 4326'
newLyrName2 = '2_PdR attivi da controllare 4326'

#definisco il progressivo delle operazioni
m=0
n=0

#Definisco il nome dei campi da utilizzare come variabili
fieldX = 'X_COORD'
fieldY = 'Y_COORD'

m=m+1
n=0
#creo un popup che richiede una risposta
msgBOX = QtGui.QMessageBox.question(iface.mainWindow(), '',#titolo
    str(m) + " - Importare i PdR da file excel?", #messaggi
    QtGui.QMessageBox.Yes, QtGui.QMessageBox.No) #pulsanti

And I saved it in a file called "importXLS.py" stored in a folder "script". Then I built a plugin with a custom toolbar.

Now, what I want to do is that when I press a button it call and execute a pyqgis script inside a console python but, for now, I can only open a console python but I cannot execute nothing inside it.

Answer 1

Add the following line to the imports of the plugin file.

from pathlib import Path # import section

Then use the next lines in the code that will run when the button is clicked.

python_file_path = "c:/test/importXLS.py"
exec(Path(python_file_path ).read_text())

Answer 2

Looking around, I found this post: How to call QgisInterface class in a plugin. It helps me having and idea: first I changed iface before call and run a script:

Then anytime, when the script is called and run by QGis, if on console python QGis advised me that it cannot run the script because a function is not defined:

I will add it at the start of the code that I call by plugin script:

In that way I can run python console scripts by QGis plugin.