<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,<br>
a new version is available here: <a class="moz-txt-link-freetext" href="http://www.tcoq.org/composants">http://www.tcoq.org/composants</a>,
correcting glitches and adding improvements (see below).<br>
<br>
A direct link to the download is here:<br>
<a class="moz-txt-link-freetext" href="http://www.tcoq.org/SpreadsheetInterface_sources_V0.11.zip">http://www.tcoq.org/SpreadsheetInterface_sources_V0.11.zip</a><br>
<br>
<br>
<blockquote
cite="mid:AANLkTi=VvRfR0R=RPY+WZpTCO0ptdpGnQxVaYO_TCKWi@mail.gmail.com"
type="cite">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
N° of rows and columns not yet implemented. I could have them
next week-end.<br>
My usual practice is to loop on the cells in a given row or
column until a<br>
condition is met, for example 'end' in the cell value, or ''
empty.<br>
</blockquote>
</div>
</blockquote>
New functions are introduced on the ISheet interface: GetLastColumn
and GetLastRow. That should help you. It took me a little time: I
coded them in both Excel and OpenOffice.<br>
<blockquote
cite="mid:AANLkTi=VvRfR0R=RPY+WZpTCO0ptdpGnQxVaYO_TCKWi@mail.gmail.com"
type="cite">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<br>
</blockquote>
<br>
Some remarks.<br>
There is something wrong with TWorkBook.Close. When I have
DisplayAlerts=TRUE then it always ask "File FALSE.xlsx already
exists. overwrite it ?". Maybe it should have DISPID_CLOSE
instead of DISPID_SAVEAS.<br>
<br>
What <span id="result_box" class="" lang="en"><span
title="Kliknij, aby wyświetlić alternatywne tłumaczenia"
class="hps">should look like</span> <span title="Kliknij,
aby wyświetlić alternatywne tłumaczenia" class="hps">the
correct</span> <span title="Kliknij, aby wyświetlić
alternatywne tłumaczenia" class="hps">procedure for</span> <span
title="Kliknij, aby wyświetlić alternatywne tłumaczenia"
class="hps">closing</span></span> Excel without save file ?
<br>
I use:<br>
<br>
ExcelWb.Close(false); // Close with DISPID_CLOSE<span
id="result_box" class="short_text" lang="en"><span
title="Kliknij, aby wyświetlić alternatywne tłumaczenia"
class="hps"></span></span><br>
ExcelApp.Quit;<br>
</div>
</blockquote>
You're right. This is corrected. The Close now calls DISPID_CLOSE.<br>
You should Save or SaveAs the workbook before closing, or set
displayalerts to false if you wish to close without saving.<br>
<blockquote
cite="mid:AANLkTi=VvRfR0R=RPY+WZpTCO0ptdpGnQxVaYO_TCKWi@mail.gmail.com"
type="cite">
<div class="gmail_quote">
<br>
and Excel process still exists untl I close my app.<br>
With DISPID_CLOSE <span id="result_box" class="short_text"
lang="en"><span title="Kliknij, aby wyświetlić alternatywne
tłumaczenia" class="hps">I see</span> <span title="Kliknij,
aby wyświetlić alternatywne tłumaczenia" class="hps">that
the</span> <span title="Kliknij, aby wyświetlić
alternatywne tłumaczenia" class="hps">process</span> <span
title="Kliknij, aby wyświetlić alternatywne tłumaczenia"
class="hps">releases</span> <span title="Kliknij, aby
wyświetlić alternatywne tłumaczenia" class="hps">some</span>
<span title="Kliknij, aby wyświetlić alternatywne tłumaczenia"
class="hps">memory</span> (</span><span id="result_box"
class="short_text" lang="en"><span title="Kliknij, aby
wyświetlić alternatywne tłumaczenia" class="hps">probably</span>
<span title="Kliknij, aby wyświetlić alternatywne tłumaczenia"
class="hps">correctly</span> <span title="Kliknij, aby
wyświetlić alternatywne tłumaczenia" class="hps">closes</span>
<span title="Kliknij, aby wyświetlić alternatywne tłumaczenia"
class="hps">sheet) b</span></span><span id="result_box"
class="short_text" lang="en"><span title="Kliknij, aby
wyświetlić alternatywne tłumaczenia" class="hps">ut</span> <span
title="Kliknij, aby wyświetlić alternatywne tłumaczenia"
class="hps">the process</span> <span title="Kliknij, aby
wyświetlić alternatywne tłumaczenia" class="hps">still</span>
exists (<span title="Kliknij, aby wyświetlić alternatywne
tłumaczenia" class="hps">hangs</span></span>?).<br>
</div>
</blockquote>
Yes, I don't why yet. Certainly a bug in the interface somewhere. It
doesn't happen for OpenOffice, though. I'm still looking into it. In
the meantime, there should be no remaining compiler warnings or
hints, except in the Pas_Uno_Bridge (needs some investigating).<br>
<br>
I hope this helps,<br>
Best regards,<br>
Thierry<br>
<br>
</body>
</html>