If cbx_1. Checked=true then
Dw_1. Modify (" xx. Visible=false ")
I will xx this hidden columns, although hides the export to still have this column,
How can the excle is used to derive the export not this column,

CodePudding user response:

You say saveas function of export? Saveas derived directly from the buffer, no matter whether you hide, even in the datawindow material on the column, as long as in the SQL, then use saveas will export,

Use dw2xls, call or write their own code ole objects excel

CodePudding user response:

reference 1st floor zlf19810306 response:

saveas function is derived, you say? Saveas derived directly from the buffer, no matter whether you hide, even in the datawindow material on the column, as long as in the SQL, then use saveas will export,

Use dw2xls, call or write their own code ole objects excel

How to use is to use the saveas dw2xls can't literally, for example, thank you

CodePudding user response:

reference 1st floor zlf19810306 response:

saveas function is derived, you say? Saveas derived directly from the buffer, no matter whether you hide, even in the datawindow material on the column, as long as in the SQL, then use saveas will export,

Use dw2xls, call or write their own code ole objects excel

Sorry I use PB7.0 7.0 there is no dw2xls ole object call what to use

CodePudding user response:

Don't need to write a generic class, before export data to another window, will visible<> 1 all the destroy, saveas again

CodePudding user response:

reference 4 floor pb8 response:

,

don't need to write a generic class, before export data to another window, will visible<> 1 all the destroy, saveas ok

How to write ah can write an example

CodePudding user response:

The modify (' destroy column)