Viewing intermediate results
From Apache OpenOffice Wiki
< Python
Revision as of 15:44, 3 September 2013 by Marcoagpinto (talk | contribs)
This script was published by kilorun and at the OpenOffice Basic, Python, BeanShell, JavaScript Forum.
kilorun wanted to develop a Python macro embedded in a Calc document to scrape data from various web pages and paste some results in cells in the spreadsheet, 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" )