Difference between revisions of "Python/ViewingIntermediateResults"
From Apache OpenOffice Wiki
< Python
Marcoagpinto (talk | contribs) |
Marcoagpinto (talk | contribs) |
||
Line 3: | Line 3: | ||
This script was published by kilorun and at the [http://forum.openoffice.org/en/forum/viewtopic.php?f=45&t=63067 OpenOffice Basic, Python, BeanShell, JavaScript Forum]. | This script was published by kilorun and at the [http://forum.openoffice.org/en/forum/viewtopic.php?f=45&t=63067 OpenOffice Basic, Python, BeanShell, JavaScript Forum]. | ||
− | + | Macro to scrap data from various websites and insert it in a spreadsheet using Python, without having to wait until the macro had finished before seeing the results. | |
== Original code == | == Original code == |
Revision as of 15:46, 3 September 2013
This script was published by kilorun and at the OpenOffice Basic, Python, BeanShell, JavaScript Forum.
Macro to scrap data from various websites and insert it in a spreadsheet using Python, without having to wait until the macro had finished before seeing the results.
Original code
import time
def myTest3():
oDoc = XSCRIPTCONTEXT.getDocument()
oSheets = oDoc.getSheets()
mySheet = oSheets.getByName("Sheet1")
# set up Status Indicator
Controller = oDoc.getCurrentController()
DocFrame = Controller.getFrame()
oStatusIndicator = DocFrame.createStatusIndicator()
oStatusIndicator.start( "", 1 )
mySheet.getColumns().removeByIndex(0, 1)
oStatusIndicator.setText( "Process started" )
for i in range(0,5):
oStatusIndicator.setText( "Processing: " + str(i) )
mySheet.getCellByPosition(0,i).Value = i
time.sleep(1)
oStatusIndicator.setText( "Process finished" )