:ToExcel() method error

[Marco Turco]

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 ?

[karinha]

how are you doing?

Code: Select all  Expand view

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

[Marco Turco]

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:bStrData:={||dtoc(aObjects[6]:aRow[xxxx])}
endif