Excel
lazarus / 5-Lazarus Extra Components

----------------------------------------------------------------------
mizarra · 2005-05-18 20:21

Anybody know if exist a package that can read and write a xls
file?[/b]. Thank

----------------------------------------------------------------------
Anonymous · 2005-09-05 19:19

The ole automation not supported in Free Pascal yet..
Try write a little dll in C or Delphi.

----------------------------------------------------------------------
Pavel · 2005-09-23 12:29

Quote from: "mizarra"Anybody know if exist a package that can read and
write a xls file?[/b]. Thank

You can try freeexcelsylk unit for delphi. : http://freeware.brotherso
ft.com/software_developer/delphi/freeexcelsylk_download_22614.html
This unit export your data to excel without excel. But cannot read
excel files.

----------------------------------------------------------------------
melone · 2006-10-23 19:07

trying to export a dbgrid to an excel file, ive tried the unit u
kindly linked.
any of you tried to compile it?
i am a bit noob, this is what i encountered..

  FFileStream.WriteBuffer(Pointer(Value)^,Length(Value));
illegal type conversion: ShortString to ^untyped

  FFileStream.Write(PChar(Value)^, length(Value));
illegal type conversion: ShortString to ^Char

i used:
FreeExcelSylk_1.13beta.zip

i mirrored it atm here:
http://www.gbadat.altervista.org/FreeExcelSylk_1.13beta.zip
(if link doesnt work, copy it to address bar)

----------------------------------------------------------------------
Marc · 2006-10-24 09:41

try to use WriteBuffer(Value[1], Lenght(Value))

Don't know if ir work with shortstrings, but it does with ansi strings
(wiich is btw, advisable to use)

----------------------------------------------------------------------
Vincent Snijders · 2006-10-24 12:13

If you use a component written for Delphi, compile with the -Sd
compiler option (or add {$mode delphi} to all sources) to make sure
are strings are actually ansistrings.

----------------------------------------------------------------------
melone · 2006-10-25 18:24

{$mode delphi}  worked!!!!!!    
big big thanks and sorry for the stupid question  :wink: