LazFlexCel

[wOvAN]

Hello, I've ported Delphi's FlexCel (Free 2.5.3 version) component.
(Native Excel Report tool).
Tested  it on Win32/Win64 and a little on Lin64.

LazFlexCel_0.0.3.7z

It needs some more testing on Linux. So try it. I hope it'll be useful.

[Leledumbo]

Isn't it a commercial component? What about the license?

[wOvAN]

The version Flexcel v2.5.3  is free under MPL license

License
This is free software, subject to the Mozilla Public License. If you find it useful, and if you can afford it (it's $30) you can register it at

http://shareit1.element5.com/product.html?productid=161531

You will make my day a little happier :-) .If you can't afford it, well, don't worry, you can use it the same. (I would like an email anyway, telling me that you use it and how, but that's up to you). The real reason behind me asking you to contact, is that I would like to know how many people if someone is using this, and how many people thinks it's so good they can pay $30 for it. Supporting a product is a complex work, and I want to be sure it's being useful to someone.

Now, for the cut and paste…

The contents of this file are subject to the Mozilla Public License Version 1.1 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
http://www.mozilla.org/MPL/
Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF
ANY KIND, either express or implied. See the License for the specific language governing rights and
limitations under the License. 

[JuhaManninen]

Linker error:
/usr/bin/ld: cannot find -lgsf-1

Opensuse 11.2 Linux.

[wOvAN]

Linker error:
/usr/bin/ld: cannot find -lgsf-1

Opensuse 11.2 Linux.

On Linux it depends on following libraries:

libglib-2.0.so
libgobject-2.0.so
libgsf-1.so
libxml2.so

I tested on Fedora 64 and placed this libraries from it in folder "Lin64_Required_Libs"

they might be present in the system but not linked to actual names, like:
libglib-2.0.so.0.2200.3  ->  libglib-2.0.so 

so you need to find 'em and create symbolic link in that case.

[mica]

Linker error:
/usr/bin/ld: cannot find -lgsf-1

Opensuse 11.2 Linux.

install libgsf and libgsf-devel with yast/smart/whatever you use.

[JuhaManninen]

I got the lib. FlexCel package now installs and show nice icons in palette.
How am I supposed to use it? I don't have Excel in my Linux.

Juha

[mica]

Yes,some Demos woulde be nice.

[wOvAN]

Yes,some Demos woulde be nice.

There are docs and delphi's demos in the original distribution.

[faber]

Works Great (Import).
Finally got something sensible to read xls. BIG THX 

[JuhaManninen]

It needs some more testing on Linux. So try it. I hope it'll be useful.

This component is highly windows specific. It uses OLE for example.
Under Linux, the best result I got was SIGSEGV.
What kind of testing you want that people do on Linux?

The examples are Delphi specific. They use BDE controls TTable and TQuery + others.
You could convert or create some examples that work on Windows at least.

Still, I believe this is a good component for those who make Win-only programs with Lazarus.
Next you can make something similar for OpenOffice suite. :-)

Juha

[mica]

hmm same problem with Linux 32 bit here.
A simple

FlexCelImport1.OpenFile(filename);
 try
  FlexCelImport1.Save('filename);
 finally
FlexCelImport1.CloseFile;

brings strange errors like sigsev or list out of bounds......

[wOvAN]

hmm same problem with Linux 32 bit here.
A simple

FlexCelImport1.OpenFile(filename);
 try
  FlexCelImport1.Save('filename);
 finally
FlexCelImport1.CloseFile;

brings strange errors like sigsev or list out of bounds......

Try to find out, what is wrong with it and fix it. 

[wOvAN]

It needs some more testing on Linux. So try it. I hope it'll be useful.

This component is highly windows specific. It uses OLE for example.
Under Linux, the best result I got was SIGSEGV.
What kind of testing you want that people do on Linux?

The examples are Delphi specific. They use BDE controls TTable and TQuery + others.
You could convert or create some examples that work on Windows at least.

Still, I believe this is a good component for those who make Win-only programs with Lazarus.
Next you can make something similar for OpenOffice suite. :-)

Juha

It doesn't use OLE, if you need this component to work on Linux and you get errors you should fix it and publish if you want so.

For now I don't have time and the need to make it work on linux, I've converted it enough to be compilable on linux. You can't make it work

[José Mejuto]

It doesn't use OLE, if you need this component to work on Linux and you get errors you should fix it and publish if you want so.

For now I don't have time and the need to make it work on linux, I've converted it enough to be compilable on linux. You can't make it work

Hello,

It uses OLE in Windows and depends on libgsf, libxml2, libgobject and libglib in Linux. So at least the first is not present in standard non gnome distributions, but I'm not sure, my Linux skills are quite limited.