Output
On the Output tab of the File Transformer form, choose how the report data will be written to one or more report files:
Micromine Report
File
Select a report type. Enter (or double-click to select) the name of the file to which the report data will be written, and optionally specify a title for the report.
Use extended character set
If this option is selected, the file will be created as a Unicode Text Format (UTF-8) file, which provides support for extended character sets and is ideal for multilingual workplaces.
Auto open file for editing
Select this check box to automatically open the newly created file(s) for editing in the File Editor.
Excel Report
File
To write the report to an Excel file, enter (or double-click to select) the name of the file. The following output file formats can be selected:
Format | Extension | Description |
---|---|---|
Excel Workbook | .xlsx | The default Office Excel 2007 XML-based file format. |
CSV | .csv | CSV format compatible with both Excel and Open Office (spreadsheet). |
Sheet name
If you are exporting to a new file, enter the name of the sheet in the file, i.e. Sheet1. If you are exporting to an existing file, double-click (or click on the ellipsis) to select a sheet.
Include metadata header
Select this option to write metadata to the file and optionally add a title for the report.
Open file after export
Select this check box to automatically open the file in Excel after the export is complete.
If you have chosen to generate Excel output and the output file already exists, you will be prompted to overwrite the file or overwrite the sheet: