Excel.dxl, How can i set Dialog Options and Start the Excel Export

Hi everybody,

i use Doors "9.6.0.0 64bit".

I want to start a Excel-Export of my View by calling "#include <standard/export/office/excel.dxl>". 

After calling this i get a Dialog box in which i want to set Options like "Main Column = Object Heading and Text" and set "Include column titles" and set "Preserve rich text formatting". Also the Export was not starting.

How can i set this Dialog Options and start the export ?

Information: The excel.dxl is encrypted.

Can you please support me ?

Best regards,

Osman

Re: Excel.dxl, How can i set Dialog Options and Start the Excel Export
O.Wilkop - Wed Jul 11 05:39:07 EDT 2018

Try this:

void actualRealize(DB x){
        realize(x);
}

void actualShow(DB x){
        show(x);
}

void realize(DB x){
}

void show(DB x){
}


#include <standard/export/office/excel.dxl>

actualRealize(excelBox)

set(mainChoice, 4);
set(titleToggle, true);
set(preserveRichTextFormattingToggle, true);


doExcel(excelBox);
//actualShow(excelBox);

Re: Excel.dxl, How can i set Dialog Options and Start the Excel Export
osman089 - Wed Jul 11 07:22:42 EDT 2018

void actualRealize(DB x){
        realize(x);
}

void actualShow(DB x){
        show(x);
}

void realize(DB x){
}

void show(DB x){
}


#include <standard/export/office/excel.dxl>

actualRealize(excelBox)

set(mainChoice, 4);
set(titleToggle, true);
set(preserveRichTextFormattingToggle, true);


doExcel(excelBox);
//actualShow(excelBox);

Hi O.Wilkop, thanks it works. But why we need two steps "actualRealize" and "Realize" ? Can you explain shortly why we need this void functions ?

Where do you declare "excelBox" ? 

"doExcel" i dont found in the reference manual ?

Last question how can i "close" the DialogBox after finishing the export ?

THANK YOU VERY MUCH

Re: Excel.dxl, How can i set Dialog Options and Start the Excel Export
O.Wilkop - Wed Jul 11 08:21:33 EDT 2018

Hm, in this case you don't even need realize() and actualRealize(), you do, however, need the empty override of the show() function. This example should work and also close the DialogBox afterwards:

void show(DB x){
}

#include <standard/export/office/excel.dxl>

set(mainChoice, 4);
set(titleToggle, true);
set(preserveRichTextFormattingToggle, true);


doExcel(excelBox);
hide(excelBox);

Including the excel.dxl means DOORS executes its contents fully. Since the script uses the show(DB) function to display the DialogBox and the show(DB) function stops any of the following code lines from executing you can't easily place your set() functions after the include. We need to prevent the included script from calling show() and we do this by declaring (and overwriting) our own show function (that does nothing) before including the original script.

excelBox and doExcel() are declared inside the excel.dxl script. The variable names you can get by using startDXLTracing_(string path) before and stopDXLTracing_() after the include. The resulting text file shows you the declared variable names, which leads to excelBox, mainChoice, titleToggle and preserveRichTextFormattingToggle. doExcel() is the function name used for the Export-button. This one you have to either guess (or by taking a look at the unencrypted files in DOORS 9.3)

Re: Excel.dxl, How can i set Dialog Options and Start the Excel Export
osman089 - Thu Jul 12 06:07:13 EDT 2018

void show(DB x){
}

#include <standard/export/office/excel.dxl>

set(mainChoice, 4);
set(titleToggle, true);
set(preserveRichTextFormattingToggle, true);


doExcel(excelBox);
hide(excelBox);

Hi O.Wilkop, Thank you for your support, the script works very well.

I got following error by starting this command:

startDXLTracing_(string path)

#include <standard/export/office/excel.dxl>

stopDXLTracing_()

Error:

DXL halted with run-time error

-R-E- DXL: <Line:1> An unexpected error has occurred: MSVCR80.dll caused an EXCEPTION_ACCESS_VIOLATION in module MSVCR80.dll at 0000000056D76CF1

-R-F- DXL: <Line:1> internal error, please submit a bug report
-I- DXL: execution halted

Is something wrong with the command ?