Creating an analysis configuration file using the DNS-IJXwriter Excel Macro
Contents
In this section, you will learn how to use the DNS-IJXwriter.xlsm Excel macro to automatically generate an .ijx analysis configuration file. The DNS-IJXwriter.xlsm Excel macro is an Excel file containing a macro, written by Peter Haub, that will automatically read filenames and generate an .ijx file from a folder of images.
1. Open the DNS-IJXwriter.xlsm macro-enabled Excel file, located in the ImageJ Tutorial→ImageJ DNS Macros folder of the Tutorial Sample Data Archive.
2. Click on Enable Content button if not already enabled (Figure T27.2)
Figure T27.2 Enabling Macros in Microsoft Excel
3. Click the Read File Names button (Figure T27.3).
Figure T27.3 Clicking Read File Names Macro Button
4. Navigate to the Multi Channel Image Experiment folder within ImageJ tutorial subfolder for the Tutorial Sample Data archive.
5. Click OK (Figure T27.4).
Figure T27.4 Navigating to the ImageJ Tutorial folder within the Tutorial Sample Data Archive
6. Type the corresponding channel name (i.e., "DAPI" or "FITC") for each image into the "Channel" column (Column D) of the spreadsheet.
Your spreadsheet should now resemble Figure T27.5.
Figure T27.5 DNS-IJXwriter.xlsm Excel File after Adding Data Files
7. Click the Write IJX File button (Figure T27.5, red outline).
"DeNovo.IJX" an Analysis Configuration file has been written to the TutorialSampleData/ImageJ Tutorial/Multi Channel Image Experiment directory folder. This .ijx file now may be processed in ImageJ using the DNS MacroExample.ijm macro in order to render the .ijout files which are readable by FCS Express.
In the next section, we will use the newly created .ijx file to analyze and export results from ImageJ to FCS Express