FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour oBRW:ToExcel() works only with character columns?
max
Posts: 130
Joined: Fri Jun 30, 2006 02:14 PM
oBRW:ToExcel() works only with character columns?
Posted: Wed Nov 12, 2008 01:57 PM

I try to use oBRW:TOEXCEL() method to export the content of my xbrowse in a xls file.
I note that it works fine only if i specify all columns as "character" expression.
If i put just one column as a "numeric" expression in my xbrowse, i receive this error at runtime:
"Error Excel.Application:ACTIVESHEET:COLUMNS/0 S_OK: _STYLE" and my application quit.

Is it normal?
There is another more stable / powerful way for export the content of my xbrowse in a xls file?

Thank you.
Max

Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
oBRW:ToExcel() works only with character columns?
Posted: Thu Nov 13, 2008 07:35 AM

Works for all types of columns perfectly for Excel English installation. We are noticing some problems with other language installations We are addressing this issue..

regards, saludos

Antonio Linares
www.fivetechsoft.com
max
Posts: 130
Joined: Fri Jun 30, 2006 02:14 PM
oBRW:ToExcel() works only with character columns?
Posted: Thu Nov 13, 2008 07:41 AM

Thank you, Antonio.

Let me know when you have a solution or something i can try for this issue.

Max

PeterHarmes
Posts: 363
Joined: Wed Feb 15, 2006 02:06 PM
oBRW:ToExcel() works only with character columns?
Posted: Thu Nov 13, 2008 04:42 PM

I'm quite interested in this - are there any examples of :ToExcel() anywhere?

Regards

Pete

max
Posts: 130
Joined: Fri Jun 30, 2006 02:14 PM
oBRW:ToExcel() works only with character columns?
Posted: Fri Nov 14, 2008 07:18 AM

You can find examples in mallorca.prg and testxbr3.prg in \FWH\SAMPLES.

Max

Continue the discussion

Static archive · New replies & topics via GitHub Discussions