oBrw:ToCalc() OpenOffice, similiar to oBrw:ToExcel()

[anserkk]

Antonio and Friends,

How about having a Method in xBrowse to export data to Calc (OpenOffice) similiar to oBrw:ToExcel() in future xBrowse updates.

Nowadays I find that more people are getting used to OpenOffice and are insisting to have reports in Calc instead of Excel.

OpenOffice Calc can be configured to open MS Excel files, but you still need MS-Excel installed on the PC (OLE) for xBrowse to convert to Excel.

Regards

Anser


Regards

Anser

[anserkk]

Friends,

From another forum I found that in Mr.Manual Mercados' TSBrowse there is a Method to export TsBrowse Data to Excel Format without using OLE. This TSBrowse has 2 methods to transfer browser data to Excel

Method 1 : using OLE similiar to xBrowse:ToExcel() method
Method 2 : Data is transfered to excel without using OLE

The advantage of the 2nd method is that it can convert Browser data to Excel format without having Excel installed in the PC.

Once Excel file is created, then it can be opened using OpenOffice Calc.

In my part of the world there are lot of people using OpenOffice instead of MS-Office. As a developer I can give flexibilty to my users to choose MS-Office or OpenOffice, xBrowse will work

I have the code of the method without OLE. I don't know whether it is OK if I post the source code of that method here. (It is an opensource). If somebody confirm, I shall paste the code here

If experts here can convert that method to FWH xBrowse equivalent, then
xBrowse will have two methods to transfer Browser data to Excel

oBrw:ToExcel() and
oBrw:ToExcelNoOle()

Regards

Anser