pen pene
asked on
delphi with excel with out ole
Hello,
I ask you to help me on this subject.
I want to make an application with delphi 10.2 tokyo, which can create and read and write in an excel 2003 and 2007 file, without ole and without the ms excel set installs in the pc.
Is what can be done with teen, what are the commands and procedure
And is that there is another method
thank you
I ask you to help me on this subject.
I want to make an application with delphi 10.2 tokyo, which can create and read and write in an excel 2003 and 2007 file, without ole and without the ms excel set installs in the pc.
Is what can be done with teen, what are the commands and procedure
And is that there is another method
thank you
ASKER
Hi
This librery is not free, l need ado, thankyou
This librery is not free, l need ado, thankyou
You must set connection string similar to my answer (to old EE question). Then use ado components like with some other (.mdb) database.
let's get things straight first
you don't have a free solution, even if you get free components for doing this
> you bought Delphi, which isn't free either
but if you don't want to spend more money ...
as stated above, use ADO.
but i doubt it will work without excel installed
devexpress quantumgrid has procedures/functions to create excels from data without excel installed !
https://www.devexpress.com/products/vcl/
they write directly to a file, it only works for writing complete excel files
changing them doesn't work
you don't have a free solution, even if you get free components for doing this
> you bought Delphi, which isn't free either
but if you don't want to spend more money ...
as stated above, use ADO.
but i doubt it will work without excel installed
devexpress quantumgrid has procedures/functions to create excels from data without excel installed !
https://www.devexpress.com/products/vcl/
they write directly to a file, it only works for writing complete excel files
changing them doesn't work
ASKER
Hello,
I thank you for your reply.
I would like to write in an excel 2003 file with firedac via odbc driver, on delphi 10.2 tokyo.
Finally I will opt by the firedac component TFDConnection1 via odbc driver
And tfdquery and tfdcommand;
The select request works very well: select * from [feuil1 $]
For sql insert or update ca does not work
It gives the following message
[firedac][phys] [odbc] [microsoft] [pilote odbc excel] operation must use an updateable query
How to do with these queries, and what is the syntax;
How to select a single cell and several cells
thank you
I thank you for your reply.
I would like to write in an excel 2003 file with firedac via odbc driver, on delphi 10.2 tokyo.
Finally I will opt by the firedac component TFDConnection1 via odbc driver
And tfdquery and tfdcommand;
The select request works very well: select * from [feuil1 $]
For sql insert or update ca does not work
It gives the following message
[firedac][phys] [odbc] [microsoft] [pilote odbc excel] operation must use an updateable query
How to do with these queries, and what is the syntax;
How to select a single cell and several cells
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it is possible
have a look at this component
TMS FlexCel for VCL & FMX
https://www.tmssoftware.com/site/flexcel.asp