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" )