Search found 500 matches: toexcel

Return to advanced search

Re: error oBrw:ToExcel

We get this error with some versions of Excel.

We need to modify xbrowse.prg
Please locate this line of code in the method ToExcel()
Code: Select all  Expand view
oWin:FreezePanes := .t.


Replace with:
Code: Select all  Expand view
  TRY
      oWin:FreezePanes := .t.
   CATCH
   END
by nageswaragunupudi
Wed Jan 10, 2024 2:37 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: error oBrw:ToExcel
Replies: 2
Views: 513

error oBrw:ToExcel

Hi, My app run on 15 pcs but I get error only on 2 pcs when I call function oBrw:ToExcel() I get this error: Application =========== Path and name: myexe.exe (32 bits) Size: 7,345,664 bytes Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20161218) FiveWin ...
by damianodec
Tue Jan 09, 2024 4:38 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: error oBrw:ToExcel
Replies: 2
Views: 513

Re: Xlsxlibhb_ver2

If you set
Code: Select all  Expand view
UseXLSXLIB(  .T.  )

All toExcel methods will use this lib instead of Using Excel
by nageswaragunupudi
Sat Nov 04, 2023 1:25 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Xlsxlibhb_ver2
Replies: 57
Views: 8404

Re: problem with report to excel

Can you please make these changes in fwh\source\function\olefuncs.prg and test with toexcel() methods of Report and XBrowse please? Please replace these three functions function ExcelLangID()function ExcelLang()function ExcelTranslate( cFunc )  ...
by nageswaragunupudi
Mon Sep 04, 2023 8:00 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: problem with report to excel
Replies: 18
Views: 3348

Re: problem with report to excel

... = C =SUBTOTAL(9,D4:D12) Stack Calls =========== Called from: => TOLEAUTO:_FORMULA( 0 ) Called from: .\source\classes\REPORT.PRG => TREPORT:TOEXCEL( 0 ) Called from: .\source\classes\RPREVIEW.PRG => (b)TPREVIEW( 0 ) Called from: .\source\classes\RPREVIEW.PRG => TPREVIEW:EXPORTTOMSEXCEL( ...
by bart
Mon Sep 04, 2023 11:35 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: problem with report to excel
Replies: 18
Views: 3348

Re: not ISOEM(), ISANSI() or IsUTF8()

... version of FWH to be released, will come with an interface to DrXlsx lib. Conversion of AnsiToUtf8 is automatic. Using FWH methods/functions like :ToExcel() or DbfToExcel() do not require the user to convert data into utf8. What all the work a programmer needs to do is to set oBrw:lOemAnsi := .t. ...
by nageswaragunupudi
Sat Sep 02, 2023 3:25 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: not ISOEM(), ISANSI() or IsUTF8()
Replies: 34
Views: 1927

Re: problem with report to excel

... 'SUBTOTAAL(9;' I see. So will you be kind enough to let us know what is working correctly with Dutch installation of Excel? Also please try oBrw:ToExcel() from XBrowse, Both have the same language issues for SUBTOTAL. Please help us to support Dutch installation by advising us the correct keyword ...
by nageswaragunupudi
Fri Sep 01, 2023 6:39 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: problem with report to excel
Replies: 18
Views: 3348

Re: DBF to Excel Sheet, without Excel, using ADO ?

METHOD ToExcel() need Excel Did you try on a PC, where Excel is not installed, if these two functions FW_OpenADOExcelBook(...) and FW_OpenADOExcelSheet(...) are working? If they are not working and if you have access to a PC ...
by nageswaragunupudi
Tue Aug 08, 2023 5:00 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2321

DBF to Excel Sheet, without Excel, using ADO ?

hi METHOD ToExcel() need Excel MsgAlert( FWString( "Excel not installed" ), FWString( "Alert" ) ) did Fivewin already have a Function to use ADO to "create" a XLSx Sheet :?: --- Idea :!: it seem function ...
by Jimmy
Tue Aug 08, 2023 6:37 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2321

EXCEL description: (DOS Error -2147352567) WINOLE/1007 Imp

... (0x800A03EC): Microsoft Excel Stack Calls =========== Called from: => TOLEAUTO:PASTE( 0 ) Called from: prog\xBrowse.prg => TXBROWSE:TOEXCEL( 10582 ) Called from: .\source\function\XBROWSER.PRG => (b)XBROWSE( 176 ) Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:CLICK( 713 ...
by mauri.menabue
Mon Jul 31, 2023 10:58 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: EXCEL description: (DOS Error -2147352567) WINOLE/1007 Imp
Replies: 4
Views: 224

Re: Exportar datos MySql a Excel con FiveWin

Jose, la manera mas simples es hacer las consultas a la base de datos, y mostrarlas en un xbrowse, y ahi simplemente poner un boton de exportar al excel que el mismo xbrowse te provee.
oBrw:ToExcel() o oBrw:Report() para imprimir
by cmsoft
Mon Jun 12, 2023 3:17 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Exportar datos MySql a Excel con FiveWin
Replies: 8
Views: 377

Re: ToExcel

Hola karinha, así lo quiere el cliente.
El problema me parece que es windows XP. En mi computadora con win 11 no tengo problema. El dbf es adt (ads). Tiene la opción de hacerlo con FileXls.

Muchas gracias.
Saludos
Ruben Dario Fernandez

Enviado desde mi 21081111RG mediante Tapatalk
by rubenfernandez01
Sat Apr 22, 2023 3:22 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: ToExcel
Replies: 2
Views: 225

Re: ToExcel

Crea que sea más simple, pasar a .PDF usando PRINTER.PRG. Ó hacer usando el RPREVIEW.PRG. Porquê tiene que ser en EXCEL?

¿Es posible hacer que el archivo .DBF esté disponible para la prueba?

Gracias.

Regards, saludos.
by karinha
Sat Apr 22, 2023 12:26 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: ToExcel
Replies: 2
Views: 225

How w/DBFToExcel

Hi friends.

How can I do this whith ToExcel from dbf
https://1drv.ms/b/s!AlgXo33R8wy97RnjERV_WRuxqGJj?e=23uAgA

Thanks

Best regards

Ruben Fernandez
by D.Fernandez
Fri Apr 21, 2023 5:33 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: How w/DBFToExcel
Replies: 2
Views: 354
Next

Return to advanced search