Exporting Columns with Conditional Values

[osquiabro]

NT 8.71, is possible export a local variable with value? i have a variable like this and work perfect:

CASE ETH:STATUS
OF 'P'
    Loc:Status='PICKUP REQUESTED BY CUSTOMER'
OF 'P'
    IF Bil3:PickupSchedule=1
        Loc:Status='PICKUP SCHEDULED'
    END
OF 'W'
    Loc:Status='RECEIVED AT TERMINAL'
OF 'PA'
END

 and how export a column not define in browse but is define in a view fields??

thanks

[Bruce]

Hi Osa,

>> NT 8.71, is possible export a local variable with value?

I presume you mean export to Excel?

>> how export a column not define in browse but is define in a view fields?

You've manually added a field to the view? Like as a view field, and you want it in the excel export but not visible on the window?
I guess add it manually to the ExportExcel routine, inside the loop?

cheers
Bruce

[osquiabro]

the field is in view but not work.

[Bruce]

exactly, the Export is exporting the Browse, not the View.
If you want to add to the export, add code in the supplied embed points.

cheers
Bruce

[osquiabro]

what embed? and how can export a value of local variable that exit in a browse?

[Bruce]

Hi Osa,

If you right-click on the procedure, choose Source, then inspect the code.
The routine you are looking for is ExportExcel.

you'll probably also find the xFiles docs on xCell useful.
http://www.capesoft.com/docs/xFiles/xfiles.htm#xCellClass

Cheers
Bruce

[osquiabro]

i found embed point and is new for me that x files have a class for excel thanks..