Re: [Lazarus] New version of Excel Interface unit available

2009-08-26 Thread Leslie Kaye
Thierry Coq wrote: div class=moz-text-flowed style=font-family: -moz-fixedA new version of ExcelInterface is now available (version 0.4) here: Tip for a basic and simple solution (Windows but presumably similar on other platforms?) you can just write your data to a Comma Separated Variable

Re: [Lazarus] New version of Excel Interface unit available

2009-08-26 Thread Žilvinas Ledas
other platforms?) you can just write your data to a Comma Separated Variable (csv) text file and do a ShellExecute 'open' on it. This will Maybe it will help someone: one can write xml file and rename it to .xls and excel will open it without any difference ;) To know the right xml format one

Re: [Lazarus] New version of Excel Interface unit available

2009-08-26 Thread Felipe Monteiro de Carvalho
On Wed, Aug 26, 2009 at 6:55 AM, Leslie Kayeles.k...@couchmansfarm.plus.com wrote: Tip for a basic and simple solution (Windows but presumably similar on other platforms?) you can just write your data to a Comma Separated Variable (csv) text file and do a ShellExecute 'open' on it. Or you can

Re: [Lazarus] New version of Excel Interface unit available

2009-08-26 Thread Thierry Coq
Yes, there are several alternatives now to read/write spreadsheets: a) - using CSV files, b) - using XML files, c) - using FPSpreadsheet, d) - now using ExcelInterface. Unlike a) and b) ExcelInterface controls Excel directly using the COM interface, so the interaction with the Excel program is

Re: [Lazarus] New version of Excel Interface unit available

2009-08-26 Thread Felipe Monteiro de Carvalho
Some time ago there were people asking in the forum how to use COM to interface with Excel. I think it would be cool if you could add a link to this component in the Lazarus wiki for easier future reference: http://wiki.lazarus.freepascal.org/Components_and_Code_examples thanks, -- Felipe

Re: [Lazarus] New version of Excel Interface unit available

2009-08-26 Thread Thierry Coq
Good idea, Felipe, ;-) I will do so Thierry Felipe Monteiro de Carvalho wrote: Some time ago there were people asking in the forum how to use COM to interface with Excel. I think it would be cool if you could add a link to this component in the Lazarus wiki for easier future reference:

Re: [Lazarus] New version of Excel Interface unit available

2009-08-26 Thread Luiz Americo Pereira Camara
Thierry Coq escreveu: Yes, there are several alternatives now to read/write spreadsheets: a) - using CSV files, b) - using XML files, c) - using FPSpreadsheet, d) - now using ExcelInterface. Unlike a) and b) ExcelInterface controls Excel directly using the COM interface, so the interaction