<?xml version='1.0' encoding="utf-8"?>
      <rss version='2.0'>
      <channel>
      <title>Форум на Исходниках.RU</title>
      <link>https://forum.sources.ru</link>
      <description>Форум на Исходниках.RU</description>
      <generator>Форум на Исходниках.RU</generator>
  	
      <item>
        <guid isPermaLink='true'>https://forum.sources.ru/index.php?showtopic=80666&amp;view=findpost&amp;p=588652</guid>
        <pubDate>Mon, 24 Jan 2005 12:59:48 +0000</pubDate>
        <title>XLS -&amp;gt; TStringGrid</title>
        <link>https://forum.sources.ru/index.php?showtopic=80666&amp;view=findpost&amp;p=588652</link>
        <description><![CDATA[Kostas: <div class='tag-code'><span class='pre_code'></span><div class='code  code_collapsed ' title='Подсветка синтаксиса доступна зарегистрированным участникам Форума.' style=''><div><div><ol type="1"><div class="code_line">function Xls_To_StringGrid(AGrid: TStringGrid; AXLSFile: string): Boolean;</div><div class="code_line">const</div><div class="code_line">&nbsp;&nbsp;xlCellTypeLastCell = {text}00000B;</div><div class="code_line">var</div><div class="code_line">&nbsp;&nbsp;XLApp, Sheet: OLEVariant;</div><div class="code_line">&nbsp;&nbsp;RangeMatrix: Variant;</div><div class="code_line">&nbsp;&nbsp;x, y, k, r: Integer;</div><div class="code_line">begin</div><div class="code_line">&nbsp;&nbsp;Screen.Cursor:=crAppStart;</div><div class="code_line">&nbsp;&nbsp;Result := False;</div><div class="code_line">&nbsp;&nbsp;XLApp := CreateOleObject(&#39;Excel.Application&#39;);</div><div class="code_line">&nbsp;&nbsp;try</div><div class="code_line">&nbsp;&nbsp; &nbsp;XLApp.Visible := False;</div><div class="code_line">&nbsp;&nbsp; &nbsp;XLApp.Workbooks.Open(AXLSFile);</div><div class="code_line">&nbsp;&nbsp; &nbsp;Sheet := XLApp.Workbooks[ExtractFileName(AXLSFile)].WorkSheets[1];</div><div class="code_line">&nbsp;&nbsp; &nbsp;Sheet.Cells.SpecialCells(xlCellTypeLastCell, EmptyParam).Activate;</div><div class="code_line">&nbsp;&nbsp; &nbsp;x := XLApp.ActiveCell.Row;</div><div class="code_line">&nbsp;&nbsp; &nbsp;y := XLApp.ActiveCell.Column;</div><div class="code_line">&nbsp;&nbsp; &nbsp;AGrid.RowCount := x;</div><div class="code_line">&nbsp;&nbsp; &nbsp;AGrid.ColCount := y; &nbsp;</div><div class="code_line">&nbsp;&nbsp; &nbsp;RangeMatrix := XLApp.Range[&#39;A1&#39;, XLApp.Cells.Item[X, Y]].Value;</div><div class="code_line">&nbsp;&nbsp; &nbsp;k := 1;</div><div class="code_line">&nbsp;&nbsp; &nbsp;repeat</div><div class="code_line">&nbsp;&nbsp; &nbsp; &nbsp;for r := 1 to y do</div><div class="code_line">&nbsp;&nbsp; &nbsp; &nbsp; AGrid.Cells[(r - 1), (k - 1)] := RangeMatrix[K, R];</div><div class="code_line">&nbsp;&nbsp; &nbsp; &nbsp;Inc(k, 1);</div><div class="code_line">&nbsp;&nbsp; &nbsp; &nbsp;AGrid.RowCount := k + 1; &nbsp;</div><div class="code_line">&nbsp;&nbsp; &nbsp;until k &#62; x; &nbsp;</div><div class="code_line">&nbsp;&nbsp; &nbsp;RangeMatrix := Unassigned;</div><div class="code_line">&nbsp;&nbsp;finally</div><div class="code_line">&nbsp;&nbsp; &nbsp;if not VarIsEmpty(XLApp) then</div><div class="code_line">&nbsp;&nbsp; &nbsp;begin &nbsp;</div><div class="code_line">&nbsp;&nbsp; &nbsp; &nbsp;XLApp.Quit; &nbsp;</div><div class="code_line">&nbsp;&nbsp; &nbsp; &nbsp;XLAPP := Unassigned; &nbsp;</div><div class="code_line">&nbsp;&nbsp; &nbsp; &nbsp;Sheet := Unassigned; &nbsp;</div><div class="code_line">&nbsp;&nbsp; &nbsp; &nbsp;Result := True; &nbsp;</div><div class="code_line">&nbsp;&nbsp; &nbsp;end; &nbsp;</div><div class="code_line">&nbsp;&nbsp;end;</div><div class="code_line">&nbsp;&nbsp;Screen.Cursor:=crDefault;</div><div class="code_line">end;</div></ol></div></div></div></div><script>preloadCodeButtons('1');</script><br>
<br>
<span class="tag-color tag-color-named" data-value="gray" style="color: gray"><span class='tag-size' data-value='7' style='font-size:7pt;'>Эта тема была разделена из темы &quot;<a class='tag-url' href='http://forum.sources.ru/index.php?showtopic=80637' target='_blank'>MS Excel + Delphi</a>&quot;</span></span>]]></description>
        <author>Kostas</author>
        <category>ActiveX, COM, DCOM, CORBA, MIDAS, интерфейсы, OLE, DDE</category>
      </item>
	
      </channel>
      </rss>
	