RE: [DUG] deleting row from excel spreadsheet

Mon, 21 Feb 2005 16:26:03 -0800

Hoping not to install any 3rd party components…

I do see the advantage of not needing Excel installed, but since this will only be used by one user, here in the IT dept, that really isn’t an issue….

Is there another way?

 

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy Coulter
Sent: Tuesday, 22 February 2005 1:16 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] deleting row from excel spreadsheet

 

Have you looked at the components that talk directly to the XLS file, not using COM but the actual file?

XLSReadWrite I thik they re called.

I had a play and they are great, and since you are dealing with the xls file you dont even need Excel installed.

 

Jeremy

-----Original Message-----
From: "tracey" <[EMAIL PROTECTED]>
To: "NZ Borland Developers Group - Delphi List" <[email protected]>
Date: Tue, 22 Feb 2005 12:11:24 +1300
Subject: [DUG] deleting row from excel spreadsheet

Hi there

 

I have gone through this article :

http://delphi.about.com/od/database/l/aa090903a.htm

and have a wee app that will load data into a DBGrid from an Excel spreadsheet, and allow the user to edit and insert new rows.

 

Unfortunately deleting is not so easy.  As Zarko states, “Deleting the selected "record" is somehow problematic. You cannot delete the record in Excel data source, since rows in Excel are not compatible with rows in traditional (relation) databases. What you can do, is to clear the contents of every cell (field) the row contains.

 

Can someone point me in the right direction to achieve this please?

 

 

 

 

_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to