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