Difference between revisions of "Python/ViewingIntermediateResults"
From Apache OpenOffice Wiki
< Python
Marcoagpinto (talk | contribs) (Python/Calc: Viewing intermediate results) |
Marcoagpinto (talk | contribs) ([Python/Calc]: Viewing intermediate results) |
||
Line 1: | Line 1: | ||
{{DISPLAYTITLE:Printing selected sheets and ranges}} | {{DISPLAYTITLE:Printing selected sheets and ranges}} | ||
− | This script was published by kilorun and at the [http://forum.openoffice.org/en/forum/viewtopic.php?f=45&t=63067 | + | 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]. |
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. | 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. |
Revision as of 15:00, 3 September 2013
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" )