Excel Custom Export

Navigation:  Exports and Outputs > Excel >

Excel Custom Export

Previous pageReturn to chapter overviewNext page

Requires ESdat 4.4.06 or higher.


ESdat Custom Exports are available when users click on the "Graph" or "Excel" buttons from the main ESdat Export Toolbar (right of screen).





ESdat Custom Exports comprise Excel files that have been setup to perform particular data processing.  They usually contain macros or complex Excel formulae.


The file needs to be:

       Saved in an ESdat Template Directory, and


       File naming needs to follow the following convention
       [Type]_[View_Name].xlsm (Type is either "chart" or "excel".  Only .xlsm files are supported)


For example, custom outputs for the view "WL1_Waterlevels_AHD" would be:


chart_WL1_Waterlevels_AHD.xlsm,   (overrides the charting output) , or

excel_WL1_Waterlevels_AHD.xlsm    (overrides the Excel output)



These Excel Custom Outputs need to have a single cell with a named range called "ESdat_Data_Destination" in the active sheet in the workbook.  This cell will be the top left cell of the export from ESdat.


ESdat will automatically attempt to run a macro in the destination workbook called "ESdat_AutoRun".  You can use this to launch any custom macros you may have that you want to run automatically.


Users may also like to read Customising Output Views if the data being output from ESdat needs to be customised.