Eureka.im

Simply the best answers.

Get 100$ bonus

How can a user export DesignXplorer or DesignXplorer-VT data to an Excel file?


In DesignXplorer 8.1, use the following macro to export the data.

1. Save the attached file to Designs_to_excel.js
2. In DesignXplorer, select Tools > Run Macro > Designs_to_excel.js
3. File will be written to : C:TempDesignSets.xls (Editable in Script)

Note: In DesignXplorer 8.1, this function was inadvertently omitted from the menu when the interface was redesigned. It is planned to be reinstated in a future release.


---------------------------------<Cut Here>---------------------------------------------------------
/******************************************************************
* Source File Name: Designs_to_excel.js *
* Created: 06/28/2004 - abenek *
* Description: Macro to export DesignXplorer Design Data to *
* Microsoft Excel *
* *
* Usage: Use via the Tools->Run Macro... in DesignXplorer *
* *
* Variables: *
* fileName - File for the DX design data.*
* (File path must be an existing directory) *
* eAutomaticDesigns - Use as 2nd argument to *
* ExportDesignsToExcel function to write *
* the AUTOMATIC designs *
* eUserDesigns - Use as 2nd argument to ExportDesignsToExcel *
* function to write the custom (user *
* generated) designs *
* *
******************************************************************/

var fileName= "C:TempDesignSets.xls";
var eAutomaticDesigns = 1;
var eUserDesigns =2;

try
{
ExportDesignsToExcel(fileName, eAutomaticDesigns);
}
catch (err)
{
WBScript.Out("Error in ExportDesignsToExcel: " + err.description, true);
}

function ExportDesignsToExcel(fName, designType)
{
var SDR = DE.EvaluationManager.RepositoryByIndex(0);

var designSets = SDR.Designs(designType, 1);
if (designSets == null)
WBScript.Out("Error retrieving designs from Data Repository", true);

designSets.ExportToExcel(fName);

WBScript.Out("Designs Saved to ""+ fName + "" successfully.", true);
}

---------------------------------<Cut Here>---------------------------------------------------------





Show Form
No comments yet. Be the first to add a comment!