Difference between revisions of "Python/ViewingIntermediateResults"
From Apache OpenOffice Wiki
< Python
Marcoagpinto (Talk | contribs) |
Marcoagpinto (Talk | contribs) |
||
| Line 4: | Line 4: | ||
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. | 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. | ||
| + | |||
| + | It only focus on eliminating the "threshold of the process by updating the status indicator". | ||
== Original code == | == Original code == | ||
Revision as of 15:56, 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.
It only focus on eliminating the "threshold of the process by updating the status indicator".
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" )
