|
Data Settings - Load/Save Exporting OP reserves and schedule data to Excel |
Data Settings - Load/Save
To access this dialog:
-
Activate the Reserves ribbon and select Mining Blocks | Evaluate. Select the Report Settings tab.
-
Using the Scheduler ribbon, select Data Settings and select the Report tab.
The functions on this panel can be used to export your current data to Microsoft Excel, and automatically apply a template to format the data into a more accessible form.
If a template file is not specified,
or does not exist, data will still be exported to Excel and can be
manually formatted afterwards. Please note that Datamine do not support
any of the functions offered by the Microsoft Office suite of products.
Field Details:
Template File: enter the path and name of an Excel file (.xls, .xlsx or .xlst). This template file will be applied by Excel to the specified Report File.
Report File: enter the path and name of the Excel file that will be generated and (optionally) formatted by a separate Template File.
Sheet Name: if you want to generate a worksheet in the specified Report File with a specific name, enter it here.
Start Range: enter the cell at which data will be generated. Data will subsequently be generated in a left-right and top-bottom order.
Clear Sheet: if enabled, any existing sheet matching the above details will be cleared before new data is added, otherwise data will not be cleared first.
Related Topics | |
|
About Data SettingsData Settings: Select DataData Settings: Field TreatmentsData Settings: Options |