[groovy]groovyでodsを読む

read_ods.groovy

@Grab('org.jopendocument:jOpenDocument:latest.release')
import org.jopendocument.dom.spreadsheet.*

def odsPath = '/Users/kanemu/Desktop/画像整理.ods'
def odsFile = new File(odsPath)

def odsDoc = SpreadSheet.createFromFile(odsFile)
def odsSheetLastIndex = odsDoc.getSheetCount()-1

MutableCell cell = null
for(int i in 0..odsSheetLastIndex){
    def odsSheet = odsDoc.getSheet(i)
    int colLastIndex = odsSheet.getColumnCount()-1
    int rowLastIndex = odsSheet.getRowCount()-1
    for(int r in 0..rowLastIndex){
        for(int c in 0..4){
            cell = odsSheet.getCellAt(c, r);
            println cell.getValue()
        }
    }
}