Printing selected sheets and ranges

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

I'm 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.

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