topic-31431

Board index FiveWin for Harbour/xHarbour :ToExcel() method error

Posts: 858

Joined: Fri Oct 07, 2005 12:00 PM

:ToExcel() method error
Posted: Tue Oct 06, 2015 02:20 PM

Hi all,
I'm having a problem using the oBrw:ToExcel() method after upgrading my old 2010 FW to the current version.
It seems it is a valtype problem, all runs well with the old fwh 2010 version.

See image. Any ideas ?

Best Regards,

Marco Turco

SOFTWARE XP LLP

karinha

Posts: 8515

Joined: Tue Dec 20, 2005 07:36 PM

Re: :ToExcel() method error
Posted: Tue Oct 06, 2015 02:29 PM

how are you doing?

Code (fw): Select all Collapse

oHoja:Cells(nX,nColuna):set("NumberFormat","0,00")
oHoja:Cells(nX,nColuna):Value := transform(aDados[nFor][1],"@E 999,999.99")
oHoja:Cells(nX,nColuna):set("NumberFormat","DD-MM-AAAA")
oHoja:Cells(nX,nColuna):Value := dtoc(aDados[nFor][1])
oHoja:Cells(nX,nColuna):set("NumberFormat","@")

http://www.44342.com/xharbour-f1105-t2226-p1.htm

João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341

Marco Turco

Posts: 858

Joined: Fri Oct 07, 2005 12:00 PM

Re: :ToExcel() method error
Posted: Tue Oct 06, 2015 02:36 PM

This way

ADD COLUMN oCol TO XBROWSE aObjects[6] DATA ARRAY ELEM aBrwDetails[i,3];
HEADER oemtoansi(aBrwDetails[i,1]) SIZE aBrwDetails[i,2] ORDER ABRWDETAILS[I,3]
if valtype(aBrwArray[1,aBrwDetails[i,3]])="D" && if date
xxxx:=aBrwDetails[i,3]
oCol:={||dtoc(aObjects[6]:aRow[xxxx])}
endif

Best Regards,

Marco Turco

SOFTWARE XP LLP

FiveTech Support Forums

Continue the discussion