So the addresses of the cells in the new range will depend on the addresses of cells within the source range. In this example, let’s define an area starting two columns to the right of our selected area. We also don’t want to overlap our source area with our target area. To avoid having python to throw an error, we need to make sure that our target area is exactly the same size than our source area. This step is to calculate the addresses for our target range of cells, by defining the columns and rows for the top-left and bottom-right cells or our target range, the range where we are going to transfer the data from the selected area. Set the top-left and bottom-right Cells addresses ODataSource = oRangeSource.getDataArray() # get data from the Range of cells and store in a tuple # ~ oRangeSource = active_sheet.getCellRangeByName('A1:C10') ORangeSource = active_sheet.getCellRangeByPosition(nLeft, nTop, nRight, nBottom) #(note: could the attribute directly instead of using intermediary variable) # store the attribute of CellRangeAddress # get the range of addresses from selection Starting with the code from the previous episode of this series LibreOffice Calc & Python Programming from its corresponding gitHub rep, or a copy paste here: def context():Īctive_sheet = Start with code from the previous chapter Set the top-left and bottom-right Cells addresses.Start with code from the previous chapter.This time we are going to create a new Range of Cells and fill it with the data stored in our tuple created in part 7.

Libreoffice calc python