Difference between revisions of "Python/ViewingIntermediateResults"

From Apache OpenOffice Wiki
Jump to: navigation, search
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].
  
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.
+
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" )


Process of the script

Personal tools