<HTML><BODY>
<DIV>Have you looked at the components that talk directly to the XLS file,
not using COM but the actual file?</DIV>
<DIV>XLSReadWrite I thik they re called.</DIV>
<DIV>I had a play and they are great, and since you are dealing with the xls
file you dont even need Excel installed.</DIV>
<DIV> </DIV>
<DIV>Jeremy<BR></DIV>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">-----Original
Message-----<BR>From: "tracey" <tracey@logis.co.nz><BR>To: "NZ Borland
Developers Group - Delphi List" <delphi@ns3.123.co.nz><BR>Date: Tue,
22 Feb 2005 12:11:24 +1300<BR>Subject: [DUG] deleting row from excel
spreadsheet<BR><BR>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial">Hi there<?xml:namespace prefix = o /><o:p></o:p></SPAN>
</FONT></DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial">I have gone through this article :<o:p></o:p></SPAN>
</FONT></DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial"><A
href="http://delphi.about.com/od/database/l/aa090903a.htm" target=_blank>
http://delphi.about.com/od/database/l/aa090903a.htm</A><o:p></o:p></SPAN>
</FONT></DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial">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.<o:p></o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial">Unfortunately deleting is not so easy. As Zarko
states, “</SPAN></FONT><FONT color=black><SPAN style="COLOR: black">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.<o:p></o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Verdana color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black"><o:p> </o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Verdana color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black">Can someone point me in the right
direction to achieve this please?<o:p></o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Verdana color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black"><o:p> </o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV></DIV></BLOCKQUOTE>
</BODY></HTML>