def __init__(self, iface):
"""Constructor.
:param iface: An interface instance that will be passed to this class
which provides the hook by which you can manipulate the QGIS
application at run time.
:type iface: QgsInterface
"""
# Save reference to the QGIS interface
self.iface = iface
# initialize plugin directory
self.plugin_dir = os.path.dirname(__file__)
# initialize locale
locale = QSettings().value('locale/userLocale')[0:2]
locale_path = os.path.join(
self.plugin_dir,
'i18n',
'UkeReader_{}.qm'.format(locale))
if os.path.exists(locale_path):
self.translator = QTranslator()
self.translator.load(locale_path)
if qVersion() > '4.3.3':
QCoreApplication.installTranslator(self.translator)
# Create the dialog (after translation) and keep reference
self.dlg = UkeReaderDialog()
# Declare instance attributes
self.actions = []
self.menu = self.tr(u'&UKE Reader')
# TODO: We are going to let the user set this up in a future iteration
self.toolbar = self.iface.addToolBar(u'UkeReader')
self.toolbar.setObjectName(u'UkeReader')
self.dlg.lineEdit_2.setText("E")
self.dlg.lineEdit_3.setText("F")
self.dlg.spinBox.setValue(2)
self.dlg.pushButton.clicked.connect(self.select_input_file)
class UkeReader:
"""QGIS Plugin Implementation."""
def __init__(self, iface):
"""Constructor.
:param iface: An interface instance that will be passed to this class
which provides the hook by which you can manipulate the QGIS
application at run time.
:type iface: QgsInterface
"""
# Save reference to the QGIS interface
self.iface = iface
# initialize plugin directory
self.plugin_dir = os.path.dirname(__file__)
# initialize locale
locale = QSettings().value('locale/userLocale')[0:2]
locale_path = os.path.join(
self.plugin_dir,
'i18n',
'UkeReader_{}.qm'.format(locale))
if os.path.exists(locale_path):
self.translator = QTranslator()
self.translator.load(locale_path)
if qVersion() > '4.3.3':
QCoreApplication.installTranslator(self.translator)
# Create the dialog (after translation) and keep reference
self.dlg = UkeReaderDialog()
# Declare instance attributes
self.actions = []
self.menu = self.tr(u'&UKE Reader')
# TODO: We are going to let the user set this up in a future iteration
self.toolbar = self.iface.addToolBar(u'UkeReader')
self.toolbar.setObjectName(u'UkeReader')
self.dlg.lineEdit_2.setText("E")
self.dlg.lineEdit_3.setText("F")
self.dlg.spinBox.setValue(2)
self.dlg.pushButton.clicked.connect(self.select_input_file)
# noinspection PyMethodMayBeStatic
def tr(self, message):
"""Get the translation for a string using Qt translation API.
We implement this ourselves since we do not inherit QObject.
:param message: String for translation.
:type message: str, QString
:returns: Translated version of message.
:rtype: QString
"""
# noinspection PyTypeChecker,PyArgumentList,PyCallByClass
return QCoreApplication.translate('UkeReader', message)
def add_action(
self,
icon_path,
text,
callback,
enabled_flag=True,
add_to_menu=True,
add_to_toolbar=True,
status_tip=None,
whats_this=None,
parent=None):
"""Add a toolbar icon to the toolbar.
:param icon_path: Path to the icon for this action. Can be a resource
path (e.g. ':/plugins/foo/bar.png') or a normal file system path.
:type icon_path: str
:param text: Text that should be shown in menu items for this action.
:type text: str
:param callback: Function to be called when the action is triggered.
:type callback: function
:param enabled_flag: A flag indicating if the action should be enabled
by default. Defaults to True.
:type enabled_flag: bool
:param add_to_menu: Flag indicating whether the action should also
be added to the menu. Defaults to True.
:type add_to_menu: bool
:param add_to_toolbar: Flag indicating whether the action should also
be added to the toolbar. Defaults to True.
:type add_to_toolbar: bool
:param status_tip: Optional text to show in a popup when mouse pointer
hovers over the action.
:type status_tip: str
:param parent: Parent widget for the new action. Defaults None.
:type parent: QWidget
:param whats_this: Optional text to show in the status bar when the
mouse pointer hovers over the action.
:returns: The action that was created. Note that the action is also
added to self.actions list.
:rtype: QAction
"""
icon = QIcon(icon_path)
action = QAction(icon, text, parent)
action.triggered.connect(callback)
action.setEnabled(enabled_flag)
if status_tip is not None:
action.setStatusTip(status_tip)
if whats_this is not None:
action.setWhatsThis(whats_this)
if add_to_toolbar:
self.toolbar.addAction(action)
if add_to_menu:
self.iface.addPluginToMenu(
self.menu,
action)
self.actions.append(action)
return action
def initGui(self):
"""Create the menu entries and toolbar icons inside the QGIS GUI."""
icon_path = ':/plugins/UkeReader/icon.png'
self.add_action(
icon_path,
text=self.tr(u'UKE Reader'),
callback=self.run,
parent=self.iface.mainWindow())
def unload(self):
"""Removes the plugin menu item and icon from QGIS GUI."""
for action in self.actions:
self.iface.removePluginMenu(
self.tr(u'&UKE Reader'),
action)
self.iface.removeToolBarIcon(action)
# remove the toolbar
del self.toolbar
def select_input_file(self):
filename = QFileDialog.getOpenFileName(None,
"Open XLSX file", '',
"XLSX file (*.xlsx)")
self.dlg.lineEdit.setText(filename)
def run(self):
"""Run method that performs all the real work"""
# show the dialog
lan = locale.getdefaultlocale()
if lan[0] == "pl_PL":
self.dlg.label.setText(u"Arkusz:")
self.dlg.label_2.setText(u"Kolumna X:")
self.dlg.label_3.setText(u"Kolumna Y:")
self.dlg.label_4.setText(u"Numer pierwszego wiersza:")
self.dlg.show()
# Run the dialog event loop
result = self.dlg.exec_()
# See if OK was pressed
if result:
filename = self.dlg.lineEdit.text()
columnx = self.dlg.lineEdit_2.text()
columny = self.dlg.lineEdit_3.text()
startrow = int(self.dlg.spinBox.value())
wb = load_workbook(filename)
ws = wb.active
x = get_coordinates(columnx, startrow, ws, 10)
y = get_coordinates(columny, startrow, ws, 10)
vl = QgsVectorLayer("Point?crs=EPSG:4326", "uke_coordinates", "memory")
pr = vl.dataProvider()
vl.startEditing()
pr.addAttributes([QgsField("X", QVariant.Double),
QgsField("Y", QVariant.Double)])
columns = column_index_from_string(get_column_letter(ws.get_highest_column()))
for i in range(1, columns+1):
col_name = get_column_letter(i)
if col_name not in [columnx, columny]:
pr.addAttributes([QgsField(unicode(ws.cell(row=startrow-1,column=i).value), QVariant.String)])
for i in range(0, ws.max_row-1):
fet = QgsFeature()
fet.setGeometry(QgsGeometry.fromPoint(QgsPoint(x[i], y[i])))
li = [x[i], y[i]]
for j in range(1, columns+1):
col_name = get_column_letter(j)
if col_name not in [columnx, columny]:
li.extend([unicode(ws.cell(row=i+2,column=j).value)])
fet.setAttributes(li)
pr.addFeatures([fet])
vl.updateExtents()
QgsMapLayerRegistry.instance().addMapLayer(vl)
vl.commitChanges()
