Short Description
This small script export all contained pixel (position and value) into a CSV file. Warning: this script may require a lot of memory to run !Versions
-
Version 2 • Released on: 2018-06-26 10:04:03Download123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566importClass(Packages.icy.gui.frame.progress.ProgressFrame)importClass(Packages.icy.file.FileUtil)importClass(Packages.plugins.tprovoost.scripteditor.uitools.filedialogs.FileDialog)importClass(Packages.icy.util.XLSUtil)importClass(Packages.icy.util.XMLUtil)importClass(Packages.icy.util.ShapeUtil)importClass(Packages.icy.roi.ROIUtil)importClass(Packages.icy.sequence.SequenceDataIterator)importClass(Packages.java.io.PrintWriter)// get active sequences = getSequence()// merge all ROI from image in a single one (OR operation)r = ROIUtil.merge(s.getROIs(), ShapeUtil.BooleanOperator.OR)if (r != null){// request path to save XLS resultfile = FileDialog.open()if (file != null){// display progress framep = new ProgressFrame("exporting...")// set XLS extensionpath = FileUtil.setExtension(file.getAbsolutePath(), ".csv")// create empty sheetsheet = ""// create an iterator through the given sequence and ROIit = new SequenceDataIterator(s, r)// set column titlessheet += "XtYtCtZtTtValuen"while(!it.done()){// set position informationsheet += it.getPositionX() + "t" +it.getPositionY() + "t" +it.getPositionC() + "t" +it.getPositionZ() + "t" +it.getPositionT() + "t"// set valuesheet += it.get() + "n"// pass to next valueit.next()}try{// save fileFileUtil.save(path, sheet.getBytes(), true)}catch(e){// error ? use another methodout = new PrintWriter(path)out.println(sheet)out.close()}// donep.close()}}
-
Version 1 • Released on: 2017-11-21 15:56:03DownloadDescription:
initial version
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354importClass(Packages.icy.gui.frame.progress.ProgressFrame)importClass(Packages.icy.file.FileUtil)importClass(Packages.plugins.tprovoost.scripteditor.uitools.filedialogs.FileDialog)importClass(Packages.icy.util.XLSUtil)importClass(Packages.icy.util.XMLUtil)importClass(Packages.icy.util.ShapeUtil)importClass(Packages.icy.roi.ROIUtil)importClass(Packages.icy.sequence.SequenceDataIterator)// get active sequences = getSequence()// merge all ROI from image in a single one (OR operation)r = ROIUtil.merge(s.getROIs(), ShapeUtil.BooleanOperator.OR)if (r != null){// request path to save XLS resultfile = FileDialog.open()if (file != null){// display progress framep = new ProgressFrame("exporting...")// set XLS extensionpath = FileUtil.setExtension(file.getAbsolutePath(), ".csv")// create empty sheetsheet = ""// create an iterator through the given sequence and ROIit = new SequenceDataIterator(s, r)// set column titlessheet += "XtYtCtZtTtValuen"while(!it.done()){// set position informationsheet += it.getPositionX() + "t" +it.getPositionY() + "t" +it.getPositionC() + "t" +it.getPositionZ() + "t" +it.getPositionT() + "t"// set valuesheet += it.get() + "n"// pass to next valueit.next()}// save fileFileUtil.save(path, sheet.getBytes(), true)// donep.close()}}