<?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 Re: Ilogic read excel cell with format in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-read-excel-cell-with-format/m-p/8581608#M94162</link>
    <description>&lt;P&gt;Currently I am doing a lot with reading from and writing to type of coding to support huge assemblies.&lt;/P&gt;
&lt;P&gt;The code is giving me some idea: will explore over the weekend.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Fri, 08 Feb 2019 00:41:16 GMT</pubDate>
    <dc:creator>RoyWickrama_RWEI</dc:creator>
    <dc:date>2019-02-08T00:41:16Z</dc:date>
    <item>
      <title>Ilogic read excel cell with format</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-read-excel-cell-with-format/m-p/6504787#M66195</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;is it possible to read excel cells with the format (different fontsizes, underlined words,...)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;At the moment i am using this code:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;SyntaxEditor Code Snippet&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;FindRow&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;\\SV-VAULT2\VaultDaten\Vorlagen allgemein\Beschriftung Zeichnungskopf.xlsx&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;Tabelle1&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;Parameter&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;=&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;SYMBOLTEXT1&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;
&lt;SPAN&gt;iProperties&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;Value&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;Custom&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;SYMBOLTEXT1&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;Sprache&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;But i can read the information only and not the excel format.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;André&lt;/P&gt;</description>
      <pubDate>Wed, 17 Aug 2016 08:33:40 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-read-excel-cell-with-format/m-p/6504787#M66195</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-08-17T08:33:40Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic read excel cell with format</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-read-excel-cell-with-format/m-p/6504823#M66197</link>
      <description>&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 17 Aug 2016 08:54:31 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-read-excel-cell-with-format/m-p/6504823#M66197</guid>
      <dc:creator>jurgen.galba</dc:creator>
      <dc:date>2016-08-17T08:54:31Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic read excel cell with format</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-read-excel-cell-with-format/m-p/6504839#M66199</link>
      <description>&lt;P&gt;Sorry, i've posted under my collegue his account&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This sample checks if the first cell is bold or not, you can modify change it according to your needs&lt;/P&gt;&lt;P&gt;This is done using COM, so you may check for errors, other open documents and so one before proceeding&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;ExcelApp = GetObject(,"Excel.Application")

'MsgBox(ExcelApp.activeworkbook.ActiveSheet.cells(1,1).Value)
If ExcelApp.activeworkbook.ActiveSheet.cells(1,1).Font.Bold = True Then
MsgBox("Cell 1,1 is Bold")
Else
MsgBox("Cell 1,1 is not Bold")
End If&lt;/PRE&gt;</description>
      <pubDate>Wed, 17 Aug 2016 08:56:26 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-read-excel-cell-with-format/m-p/6504839#M66199</guid>
      <dc:creator>frederic.vandenplas</dc:creator>
      <dc:date>2016-08-17T08:56:26Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic read excel cell with format</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-read-excel-cell-with-format/m-p/8581608#M94162</link>
      <description>&lt;P&gt;Currently I am doing a lot with reading from and writing to type of coding to support huge assemblies.&lt;/P&gt;
&lt;P&gt;The code is giving me some idea: will explore over the weekend.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 08 Feb 2019 00:41:16 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-read-excel-cell-with-format/m-p/8581608#M94162</guid>
      <dc:creator>RoyWickrama_RWEI</dc:creator>
      <dc:date>2019-02-08T00:41:16Z</dc:date>
    </item>
  </channel>
</rss>

