FiveTech Software tech support forums

nageswaragunupudi wrote:2) ArrTranspose( aArray ) --> aTransposeedArray is a function available in FWH. I am not sure if that function was available in 10.06.

Function ArrTranspose( aArray ) is availabe from FWH 10.8 onwads

Regards
Anser

... "Excel.Application" ) 2. oBook := oExcel:WorkBooks:Open( cBook ) 3. oSheet := oBook:WorkSheets( cSheet ) 4 Return oSheet:Range( cRange ) ArrTranspose() is also a recent function which transposes rows and columns of an array. I am sure you can write it yourself.

Mr.Rao, oRange := GetExcelRange( ExePath() + "xl2array", "ArrayTest", "B3:D6" ) aData := ArrTranspose ( oRange:Value ) I am not able to trace the above functions either in FWH or in xHarbour Libraries. Please tell me which libs are to be linked. Regards, ...

1) Please change DATASOURCE as ALIAS in the @ ... XBROWSE command. This should solve syntax error problem. 2) ArrTranspose( aArray ) --> aTransposeedArray is a function available in FWH. I am not sure if that function was available in 10.06. In case you get linking error that ...

Rao: Thank you very much. Very kind on your part. I'll test it and give you my feedback. For now, what the ArrTranspose function does ? I can't find it in the FWH manual I'm getting a compiler error: Compiling...xHarbour Compiler build 1.2.1 (SimpLex) (Rev. 6717)Copyright ...

... aData   oRange   := GetExcelRange( ExePath() + "xl2array", "ArrayTest", "B3:D6" )   aData    := ArrTranspose( oRange:Value )   oRange:WorkSheet:Parent:Close()   XBrowse( aData )return nilfunction ExePath()return ...