I'm running the following Python macro in LibreOffice Calc , which is working correctly:
Code: Select all
import urllib.request
from html.parser import HTMLParser
class MyParser(HTMLParser):
def __init__(self,target_tag):
HTMLParser.__init__(self)
self.targetTag=target_tag
self.targetFound=False
self.dataArray=[]
def handle_starttag(self,tag,attrs):
self.targetFound=False
if (tag==self.targetTag):
self.targetFound=True
def handle_endtag(self,tag):
if tag==self.targetTag:
self.targetFound=False
def handle_data(self, data):
if (self.targetFound):
self.dataArray.append(data)
####### target URL #######################
MyUrl='https://coinmarketcap.com/#currencies_wrapper'
OpenUrl=urllib.request.urlopen(MyUrl)
####### get the html code ################
responseHTML=OpenUrl.read().decode('utf-8')
parser=MyParser("a")
parser.feed(responseHTML)
# LibreOffice code #
activeSheet=XSCRIPTCONTEXT.getDocument().getCurrentController().getActiveSheet()
def LastMessage(*args):
activeSheet.getCellRangeByName("A1").setString(parser.dataArray[45])
activeSheet.getCellRangeByName("B1").setString(parser.dataArray[46])
activeSheet.getCellRangeByName("A2").setString(parser.dataArray[47])
activeSheet.getCellRangeByName("B2").setString(parser.dataArray[48])
here is the Basic macro information I want to run at the end of the above python macro:
filename: connexion
library: Standard
module: Module1
macro: ajustar_colunas
I did search in the forum and found a python code, I also found another python code , but neither code is working for me .
I'm grateful now for all the Help .