<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic delete all cell in a collumn   in an excel  with ilogic in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9195392#M103899</link>
    <description>&lt;P&gt;is that a to dele all not emtry cell under collum A and B&amp;nbsp; start form cell A3 And B3&amp;nbsp; with ilogic?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am using it as a log fil... but want to cleal the file if I start my ilogic on a new file&lt;/P&gt;</description>
    <pubDate>Wed, 11 Dec 2019 09:50:06 GMT</pubDate>
    <dc:creator>Darkforce_the_ilogic_guy</dc:creator>
    <dc:date>2019-12-11T09:50:06Z</dc:date>
    <item>
      <title>delete all cell in a collumn   in an excel  with ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9195392#M103899</link>
      <description>&lt;P&gt;is that a to dele all not emtry cell under collum A and B&amp;nbsp; start form cell A3 And B3&amp;nbsp; with ilogic?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am using it as a log fil... but want to cleal the file if I start my ilogic on a new file&lt;/P&gt;</description>
      <pubDate>Wed, 11 Dec 2019 09:50:06 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9195392#M103899</guid>
      <dc:creator>Darkforce_the_ilogic_guy</dc:creator>
      <dc:date>2019-12-11T09:50:06Z</dc:date>
    </item>
    <item>
      <title>Re: delete all cell in a collumn   in an excel  with ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9195422#M103900</link>
      <description>&lt;P&gt;i have none code to test with but probaly you could do something like:&lt;/P&gt;&lt;PRE&gt;xlSheet.Range("A3:A9999").Delete&lt;/PRE&gt;</description>
      <pubDate>Wed, 11 Dec 2019 10:04:46 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9195422#M103900</guid>
      <dc:creator>JelteDeJong</dc:creator>
      <dc:date>2019-12-11T10:04:46Z</dc:date>
    </item>
    <item>
      <title>Re: delete all cell in a collumn   in an excel  with ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9196381#M103911</link>
      <description>&lt;P&gt;Using iLogic, I'm not seeing any easy way to actually 'delete' a cell in an Excel file. Nor be able to set which option to use for either shifting the other cells, Entire Row, or Entire Column, after you delete it, as you have within Excel.&lt;/P&gt;&lt;P&gt;I see a method to 'Clear' its value, though, if that's all you need.&lt;/P&gt;&lt;P&gt;You would most likely have to do this using Inventors API and VBA code with the VBA Editor, once you've included the right "References" for working with Microsoft Excel.&lt;/P&gt;</description>
      <pubDate>Wed, 11 Dec 2019 16:08:47 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9196381#M103911</guid>
      <dc:creator>WCrihfield</dc:creator>
      <dc:date>2019-12-11T16:08:47Z</dc:date>
    </item>
    <item>
      <title>Re: delete all cell in a collumn   in an excel  with ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9196768#M103913</link>
      <description>&lt;P&gt;replied to wrong post&lt;/P&gt;</description>
      <pubDate>Wed, 11 Dec 2019 18:28:25 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9196768#M103913</guid>
      <dc:creator>J-Camper</dc:creator>
      <dc:date>2019-12-11T18:28:25Z</dc:date>
    </item>
    <item>
      <title>Re: delete all cell in a collumn   in an excel  with ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9196781#M103914</link>
      <description>&lt;DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"&gt;&lt;DIV class="lia-message-body-content"&gt;&lt;P&gt;I think this code should work:&lt;/P&gt;&lt;PRE&gt;Dim FilePath As String = "C:\Projects\testing.xlsx"
Dim SheetName As String = "This_Sheet"
Dim Column As String = "B"
Dim Row As Integer = 3

GoExcel.Open(FilePath, SheetName)

While Row &amp;lt; 99
GoExcel.CellValue(Column &amp;amp; Row) = "" 'Value
Row = Row+1
End While

GoExcel.Save

GoExcel.Close&lt;/PRE&gt;&lt;P&gt;Should be easy enough for you to change the string values to look for the correct workbook.&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;</description>
      <pubDate>Wed, 11 Dec 2019 18:29:14 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/delete-all-cell-in-a-collumn-in-an-excel-with-ilogic/m-p/9196781#M103914</guid>
      <dc:creator>J-Camper</dc:creator>
      <dc:date>2019-12-11T18:29:14Z</dc:date>
    </item>
  </channel>
</rss>

