FiveTech Software tech support forums

... variable, si ésta indica que deseo con Calc, entonces después de definir XBrowse debo indicar: If lQuieroCalc bDummyBloc := { | oBrw, bProgress, nGroupBy, aCols | ( oBrw:bToExcel := Nil, oBrw:ToCalc( bProgress, nGroupBy,,, aCols ), oBrw:bToExcel := bDummyBloc ) } oMiwBrowse:bToExcel := { | oBrw, ...

... ), oBrw:oCol( "Brandid" ), oBrw:oCol( "Benaming" ) } )  //METHOD ToExcel( bProgress, nGroupBy, aCols, lShow, cPDF, bPrePDF ) CLASS TXBrowse  set filter to  oBrw:refresh()return  I get a excel with the 3 columns = OK, but i also ...

... llevarlo a excel y se vea subtotalizado, asi: https://i.postimg.cc/xNH3LZXD/excel.jpg No logro hacerlo, existe el parametro nGroupby del metodo toExcel pero no se como usarlo, uso fwh 17.12 Otra opcion seria usar el metodo subtotal de la clase TexcelScript, alguien tiene ...

From wiki http://wiki.fivetechsoft.com/doku.php?id=fivewin_class_txbrowse ToExcel XLS,PDF ( [bProgress], [nGroupBy], [aCols], [lShow], [cPDF], [bPrePDF] ) –> oSheet Exports contents of the browse to a new Excel Sheet and returns the sheet object. If Excel is not installed ...

... saved by inline edit. - Enhanced: ToExce() method now exports Group Headers also if any - Export to PDF through Excel: METHOD ToExcel( bProgress, nGroupBy, aCols, lShow, cPDF, bPrePDF ) New 5th and 6th parameters pdffilename and an optional codeblock to evaluate prior to generation of pdf. This ...

Puedes mirar el METHOD ToExcel( bProgress, nGroupBy, aCols ) CLASS TXBrowse

Richard, In class TXBrowse METHOD ToExcel( bProgress, nGroupBy, aCols ) ToTop is included, but Excel moves behind the window or dialog defined in class TXbrowse oExcel:ScreenUpdating := .t. oExcel:visible := .T. ShowWindow( oExcel:hWnd, 3 ) BringWindowToTop( ...

... Thank You very much. I will test it. In METHOD To Excel there is a BringWindowToTop, but doesn't work in my situation. METHOD ToExcel( bProgress, nGroupBy, aCols ) CLASS TXBrowse ... ... oExcel:ScreenUpdating := .t. oExcel:visible := .T. ShowWindow( oExcel:hWnd, 3 ) BringWindowToTop( oExcel:hWnd ...

... := left( uValue, 1 )            endif      end   endifreturn cListSeparator In class XBROWSE in method METHOD ToExcel( bProgress, nGroupBy, aCols ) CLASS TXBrowse i changed lines: if ! Empty( cxlSum ) cxlAggr := cxlSum with: if ! Empty( cxlSum ) // cxlAggr := cxlSum cxlAggr := ...

Dear Mr.Ruben, oBrw:ToExcel() accepts the following parameters. ToExcel( bProgress, nGroupBy, aCols ) You can specify an array containing the column numbers and then pass as parameter to ToExcel() For eg. ToExcel(,,{1,2,5,6}) transfers only the column 1,2,5 and 6 ...

Dear Mr.Ruben,

oBrw:ToExcel() accepts the following parameters.
ToExcel( bProgress, nGroupBy, aCols )

You can specify an array containing the column numbers and then pass as parameter to ToExcel()

For eg.
ToExcel(,,{1,2,5,6}) transfers only the column 1,2,5 and 6 to Excel

Regards
Anser

Please substitute the present line 5993 in METHOD ToExcel( ... )

return ::ToCalc( bProgress, nGroupBy,, aCols )

as

return ::ToCalc( bProgress, nGroupBy,,, aCols )

One more comma is needed in the parameters.

... nHeaderType 0 = Normale '' 1 = of type + '' 2 = INIT |- '' 3 = END -| * Nuevo: Soporte de OpenOffice para XBrowse! Nuevo método ToCalc( bProgress, nGroupBy, nPasteMode ), este exporta datos del xBrowse a OpenOffice Calc (Hoja de cálculo de OpenOffice, similara a Excel de Microsoft). Gracias a Anser ...

Dear Mr.Antonio, * New: OpenOffice support for XBrowse! New METHOD ToCalc( bProgress, nGroupBy, nPasteMode ) exports data from xBrowse to OpenOffice Calc. Thanks to Anser! the following are the limitations as of now: 1) Group totals not implemented. 2) Another drawback ...

... nHeaderType 0 = Normale '' 1 = of type + '' 2 = INIT |- '' 3 = END -| * New: OpenOffice support for XBrowse! New METHOD ToCalc( bProgress, nGroupBy, nPasteMode ) exports data from xBrowse to OpenOffice Calc. Thanks to Anser! the following are the limitations as of now: 1) Group totals not ...