Short Description
Export the min / mean / max intensity of the selected ROI of active sequence over time in an excel file. The excel file use the same filename as the image file except it has ".xls" extension.Versions
-
Version 2 • Released on: 2014-08-07 15:54:30DownloadDescription:
Added min / max intensity information.
1234567891011121314151617181920212223242526272829303132333435363738394041importClass(Packages.icy.file.FileUtil)importClass(Packages.icy.util.XLSUtil)importClass(Packages.icy.roi.ROIUtil)sequence = getSequence()if (sequence != null){roi = sequence.getSelectedROI()if (roi != null){// create new excel filexls = XLSUtil.createWorkbook(FileUtil.setExtension(sequence.getFilename(), ".xls"))// create a new pagexlsPage = XLSUtil.createNewPage(xls, roi.getName())// write headerXLSUtil.setCellString(xlsPage, 0, 0, "T position")XLSUtil.setCellString(xlsPage, 2, 0, "Min intensity")XLSUtil.setCellString(xlsPage, 3, 0, "Mean intensity")XLSUtil.setCellString(xlsPage, 4, 0, "Max intensity")for(t = 0; t < sequence.getSizeT(); t++){// compute intensities for this framemin = ROIUtil.getMinIntensity(sequence, roi, -1, t, -1)mean = ROIUtil.getMeanIntensity(sequence, roi, -1, t, -1)max = ROIUtil.getMaxIntensity(sequence, roi, -1, t, -1)// write valueXLSUtil.setCellNumber(xlsPage, 0, t + 2, t)XLSUtil.setCellNumber(xlsPage, 2, t + 2, min)XLSUtil.setCellNumber(xlsPage, 3, t + 2, mean)XLSUtil.setCellNumber(xlsPage, 4, t + 2, max)}// save excel fileXLSUtil.saveAndClose(xls)}} -
Version 1 • Released on: 2014-08-07 15:50:45DownloadDescription:
initial version
1234567891011121314151617181920212223242526272829303132333435importClass(Packages.icy.file.FileUtil)importClass(Packages.icy.util.XLSUtil)importClass(Packages.icy.roi.ROIUtil)sequence = getSequence()if (sequence != null){roi = sequence.getSelectedROI()if (roi != null){// create new excel filexls = XLSUtil.createWorkbook(FileUtil.setExtension(sequence.getFilename(), ".xls"))// create a new pagexlsPage = XLSUtil.createNewPage(xls, roi.getName())// write headerXLSUtil.setCellString(xlsPage, 0, 0, "T position")XLSUtil.setCellString(xlsPage, 1, 0, "Mean intensity")for(t = 0; t < sequence.getSizeT(); t++){// compute mean intensity for this framed = ROIUtil.getMeanIntensity(sequence, roi, -1, t, -1)// write valueXLSUtil.setCellNumber(xlsPage, 0, t + 2, t)XLSUtil.setCellNumber(xlsPage, 1, t + 2, d)}// save excel fileXLSUtil.saveAndClose(xls)}}