Short Description

Versions

• Version 2 • Released on: 2017-11-21 15:54:15
  Download
  Description:

  Fixed a small bug

  importClass(Packages.icy.gui.dialog.MessageDialog) importClass(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 sequence s = getSequence() if (s == null) { MessageDialog.showDialog("You should open an image first") exit } // get sequence ROIs rois = s.getROIs() if (rois.size() > 0) { // request path to save XLS result file = FileDialog.open() if (file != null) { // display progress frame p = new ProgressFrame("exporting...") // set XLS extension path = FileUtil.setExtension(file.getAbsolutePath(), ".xls") //create a new excel document wb = XLSUtil.createWorkbook(path) for(c = 0; c < s.getSizeC(); c++) { sh = XLSUtil.createNewPage(wb, "Pixels - " + s.getChannelName(c)) line = 0 for(i = 0; i < rois.size(); i++) { // get current roi r = rois.get(i) // create an iterator through the given sequence and ROI it = new SequenceDataIterator(s, r, false, -1, -1, c) XLSUtil.setCellString(sh, 0, line, r.getName()) XLSUtil.setCellNumber(sh, 1, line, i) XLSUtil.setCellString(sh, 3, line, "Number of pixel =") XLSUtil.setCellNumber(sh, 4, line, Math.floor(r.getNumberOfPoints())) line += 2 // set column titles XLSUtil.setCellString(sh, 0, line, "X") XLSUtil.setCellString(sh, 1, line, "Y") XLSUtil.setCellString(sh, 2, line, "Z") XLSUtil.setCellString(sh, 3, line, "T") XLSUtil.setCellString(sh, 4, line, "Value") line++ while(!it.done()) { // set position information XLSUtil.setCellNumber(sh, 0, line, it.getPositionX()) XLSUtil.setCellNumber(sh, 1, line, it.getPositionY()) XLSUtil.setCellNumber(sh, 2, line, it.getPositionZ()) XLSUtil.setCellNumber(sh, 3, line, it.getPositionT()) // set value XLSUtil.setCellNumber(sh, 4, line, it.get()) // pass to next value it.next() line++ } line++ } } // save and close excel document XLSUtil.saveAndClose(wb) // done p.close() } } else MessageDialog.showDialog("You should have at least 1 ROI in your image")

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91

  importClass(Packages.icy.gui.dialog.MessageDialog) importClass(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 sequence s = getSequence()   if (s == null) { MessageDialog.showDialog("You should open an image first") exit }   // get sequence ROIs rois = s.getROIs()   if (rois.size() > 0) { // request path to save XLS result file = FileDialog.open()   if (file != null) { // display progress frame p = new ProgressFrame("exporting...") // set XLS extension path = FileUtil.setExtension(file.getAbsolutePath(), ".xls")   //create a new excel document wb = XLSUtil.createWorkbook(path)   for(c = 0; c < s.getSizeC(); c++) { sh = XLSUtil.createNewPage(wb, "Pixels - " + s.getChannelName(c)) line = 0   for(i = 0; i < rois.size(); i++) { // get current roi r = rois.get(i) // create an iterator through the given sequence and ROI it = new SequenceDataIterator(s, r, false, -1, -1, c)   XLSUtil.setCellString(sh, 0, line, r.getName()) XLSUtil.setCellNumber(sh, 1, line, i) XLSUtil.setCellString(sh, 3, line, "Number of pixel =") XLSUtil.setCellNumber(sh, 4, line, Math.floor(r.getNumberOfPoints())) line += 2   // set column titles XLSUtil.setCellString(sh, 0, line, "X") XLSUtil.setCellString(sh, 1, line, "Y") XLSUtil.setCellString(sh, 2, line, "Z") XLSUtil.setCellString(sh, 3, line, "T") XLSUtil.setCellString(sh, 4, line, "Value") line++ while(!it.done()) { // set position information XLSUtil.setCellNumber(sh, 0, line, it.getPositionX()) XLSUtil.setCellNumber(sh, 1, line, it.getPositionY()) XLSUtil.setCellNumber(sh, 2, line, it.getPositionZ()) XLSUtil.setCellNumber(sh, 3, line, it.getPositionT()) // set value XLSUtil.setCellNumber(sh, 4, line, it.get()) // pass to next value it.next() line++ }   line++ } }   // save and close excel document XLSUtil.saveAndClose(wb)   // done p.close() } } else MessageDialog.showDialog("You should have at least 1 ROI in your image")

• Version 1 • Released on: 2014-06-10 10:46:52
  Download
  Description:

  initial version

  importClass(Packages.icy.gui.dialog.MessageDialog) importClass(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 sequence s = getSequence() if (s == null) { MessageDialog.showDialog("You should open an image first") exit } // get sequence ROIs rois = s.getROIs() if (rois.size() > 0) { // request path to save XLS result path = FileDialog.open() if (path != null) { // display progress frame p = new ProgressFrame("exporting...") // set XLS extension path = FileUtil.setExtension(path, ".xls") //create a new excel document wb = XLSUtil.createWorkbook(path) for(c = 0; c < s.getSizeC(); c++) { sh = XLSUtil.createNewPage(wb, "Pixels - " + s.getChannelName(c)) line = 0 for(i = 0; i < rois.size(); i++) { // get current roi r = rois.get(i) // create an iterator through the given sequence and ROI it = new SequenceDataIterator(s, r, false, -1, -1, c) XLSUtil.setCellString(sh, 0, line, r.getName()) XLSUtil.setCellNumber(sh, 1, line, i) XLSUtil.setCellString(sh, 3, line, "Number of pixel =") XLSUtil.setCellNumber(sh, 4, line, Math.floor(r.getNumberOfPoints())) line += 2 // set column titles XLSUtil.setCellString(sh, 0, line, "X") XLSUtil.setCellString(sh, 1, line, "Y") XLSUtil.setCellString(sh, 2, line, "Z") XLSUtil.setCellString(sh, 3, line, "T") XLSUtil.setCellString(sh, 4, line, "Value") line++ while(!it.done()) { // set position information XLSUtil.setCellNumber(sh, 0, line, it.getPositionX()) XLSUtil.setCellNumber(sh, 1, line, it.getPositionY()) XLSUtil.setCellNumber(sh, 2, line, it.getPositionZ()) XLSUtil.setCellNumber(sh, 3, line, it.getPositionT()) // set value XLSUtil.setCellNumber(sh, 4, line, it.get()) // pass to next value it.next() line++ } line++ } } // save and close excel document XLSUtil.saveAndClose(wb) // done p.close() } } else MessageDialog.showDialog("You should have at least 1 ROI in your image")

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91

  importClass(Packages.icy.gui.dialog.MessageDialog) importClass(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 sequence s = getSequence()   if (s == null) { MessageDialog.showDialog("You should open an image first") exit }   // get sequence ROIs rois = s.getROIs()   if (rois.size() > 0) { // request path to save XLS result path = FileDialog.open()   if (path != null) { // display progress frame p = new ProgressFrame("exporting...") // set XLS extension path = FileUtil.setExtension(path, ".xls")   //create a new excel document wb = XLSUtil.createWorkbook(path)   for(c = 0; c < s.getSizeC(); c++) { sh = XLSUtil.createNewPage(wb, "Pixels - " + s.getChannelName(c)) line = 0   for(i = 0; i < rois.size(); i++) { // get current roi r = rois.get(i) // create an iterator through the given sequence and ROI it = new SequenceDataIterator(s, r, false, -1, -1, c)   XLSUtil.setCellString(sh, 0, line, r.getName()) XLSUtil.setCellNumber(sh, 1, line, i) XLSUtil.setCellString(sh, 3, line, "Number of pixel =") XLSUtil.setCellNumber(sh, 4, line, Math.floor(r.getNumberOfPoints())) line += 2   // set column titles XLSUtil.setCellString(sh, 0, line, "X") XLSUtil.setCellString(sh, 1, line, "Y") XLSUtil.setCellString(sh, 2, line, "Z") XLSUtil.setCellString(sh, 3, line, "T") XLSUtil.setCellString(sh, 4, line, "Value") line++ while(!it.done()) { // set position information XLSUtil.setCellNumber(sh, 0, line, it.getPositionX()) XLSUtil.setCellNumber(sh, 1, line, it.getPositionY()) XLSUtil.setCellNumber(sh, 2, line, it.getPositionZ()) XLSUtil.setCellNumber(sh, 3, line, it.getPositionT()) // set value XLSUtil.setCellNumber(sh, 4, line, it.get()) // pass to next value it.next() line++ }   line++ } }   // save and close excel document XLSUtil.saveAndClose(wb)   // done p.close() } } else MessageDialog.showDialog("You should have at least 1 ROI in your image")