Viewing intermediate results

From Apache OpenOffice Wiki
< Python
Revision as of 15:40, 3 September 2013 by Marcoagpinto (Talk | contribs)

Jump to: navigation, search


This script was published by kilorun and at the OpenOffice Basic, Python, BeanShell, JavaScript Forum.

kilorun is developing a Python macro embedded in a Calc document to scrape data from various web pages and paste some results in cells in the spreadsheet.

It worked, but when starting the first version of the macro, we had wait until the macro has finished before seeing the results.

It has now been fixed with the following code:


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


Process of the script

Personal tools