FlexPro and MS Excel
To enhance export data to Microsoft Excel and FlexPro, the following procedures can be used:
Select application - click on either FlexPro (ActiveX) or MS Excel (ActiveX) on Export option
Template Management - Template Management controls are only available for Microsoft Excel and FlexPro export option to manage template - scripts, which are listed on central Post-processing in FlexPro / MS Excel part of screen; templates can be created and changed or deleted |
Select template (script) - appropriate script should be selected from the list of available scripts
Import FlexPro-Databases - MergeDB script allows the user to import existing FlexPro-Databases to the exported measurement data
If you click on either FlexPro (ActiveX) or MS Excel (ActiveX) on Export option, additional Template management controls in left bottom part of screen and list of available templates - scripts on central Post-processing in FlexPro / MS Excel part of screen are displayed:
For both Microsoft Excel and FlexPro export option you will see that a list of pre-formatted scripts appears in the center of the screen with two columns Setup name and Description of script. Now you should select from the list of available scripts. You can select any one of them and then click the Export Data button below the format icons to perform the exporting. Don’t forget to select the channels to be exported before you press the Export Data button.
Transportable data file
To export to a transportable file which can be moved to another computer running MS Excel and FlexPro, or your favorite other analysis software, use the File export button and from list select Text *.txt file type to make a delimited ASCII text file.
FlexPro and Excel scripts for Data export
Experienced MS Excel and FlexPro users can examine the preformatted scripts and macros that are loaded in the \
NOTE: The available scripts depend on the Dewesoft version and may change.
NOTE: Please note that FlexPro and Excel export REQUIRE that these applications be installed properly already on this computer, or else the exporting will fail.
The concept is a nice one: once the script is created, just load any data file and run the script. What happens next is a big time-saver. Dewesoft runs this script:
- automatically starting the other application (you will see a notice on the screen that it is starting the other application, and there will be a slight delay as it does so and establishes communication)
- creates the data-set and
- runs the script.
Let‘s say that you have a script that takes four incoming signals, runs 3rd octave analysis on them, creates a polished looking report, complete with your company‘s title bar and logo, automatically puts in the data and other variables from the data file, and formats it for your color printer. After you click the Export button and this process runs, you will see your final report on the screen, and just need to click print to complete your report!
This is the power of “hot script” ActiveX data exporting from Dewesoft to either MS Excel or FlexPro.
Typical FlexPro screen:
Typical MS Excel screen:
NOTE: Our MS Excel export function knows about Excel‘s built-in limitation of 65536 rows per worksheet. If your data is longer than that, it simply creates multiple-worksheets within the workbook that it creates! It also makes a simple chart with the first several thousand data points for each input channel shown. You can use all of MS Excel built-in tools to change the chart format and make additional calculations and graphical outputs. But please be aware that MS Excel is not intended to handle million of data points.
Template management controls
You can easily create your own scripts in MS Excel or FlexPro, or edit the existing ones.
Just press the New template button to create a new one or Edit template to change an existing script.
To delete an existing script simply select it and press Delete template button.
When you press the New template button, you have to enter a Setup name, Description and a comment for the new script:
When you confirm your entries click on Process button or select Edit button to change an existing script, MS Excel or FlexPro will automatically start with currently selected template.
NOTE: For more details about creating scripts please refer to the original MS Excel or FlexPro documentation.