<?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>tema Insert Google sheet data AND Collect data from blocks to an extern sheet document. en AutoCAD for Mac Forum</title>
    <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9891675#M39766</link>
    <description>&lt;P&gt;Dear forum members.&lt;BR /&gt;I have the following problems that I would like to present to you:&lt;BR /&gt;1) I want to import a data sheet from Google Sheet into my AutoCAD 2021 drawing. This is not possible because I do not have Microsoft EXCEL installed on the Mac.&lt;BR /&gt;Therefore I turn my Sheet data into a PDF file, add this file to my AutoCAD drawing and it is just there.&lt;BR /&gt;No problem you would say.&lt;BR /&gt;Only if I plot the drawing now it prints everything except the inserted PDF file.&lt;BR /&gt;Of course I will first check whether the PDF file is on the wrong layer and therefore cannot be plotted.&lt;BR /&gt;This is not the case !&lt;BR /&gt;Let's try it in a different way:&lt;/P&gt;&lt;P&gt;If I insert the sheet data by selecting it in Google sheet and pasting it as text in AutoCAD, AutoCAD pastes all data from the columns together and you get 1 full text of data.&lt;BR /&gt;If you do this again per column of about 30 rows, the text in AutoCAD is not long enough and the lines no longer run evenly in the drawing.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;2) I would like to make a (Dynamic) block of, for example, a sewer pipe and this data (about the entire drawing) should be placed in a Google sheet.&lt;BR /&gt;So if I draw 4 tubes of 6 meters with a certain diameter, they have to come back in the sheet. However, if I stretch a block to only 4 meters, this must also be indicated and adjusted in the sheet file.&lt;/P&gt;&lt;P&gt;Who can give me a guide on how I can handle this?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance for your cooperation.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;John&lt;/P&gt;</description>
    <pubDate>Tue, 24 Nov 2020 11:18:06 GMT</pubDate>
    <dc:creator>jvgerwen-PlantLab</dc:creator>
    <dc:date>2020-11-24T11:18:06Z</dc:date>
    <item>
      <title>Insert Google sheet data AND Collect data from blocks to an extern sheet document.</title>
      <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9891675#M39766</link>
      <description>&lt;P&gt;Dear forum members.&lt;BR /&gt;I have the following problems that I would like to present to you:&lt;BR /&gt;1) I want to import a data sheet from Google Sheet into my AutoCAD 2021 drawing. This is not possible because I do not have Microsoft EXCEL installed on the Mac.&lt;BR /&gt;Therefore I turn my Sheet data into a PDF file, add this file to my AutoCAD drawing and it is just there.&lt;BR /&gt;No problem you would say.&lt;BR /&gt;Only if I plot the drawing now it prints everything except the inserted PDF file.&lt;BR /&gt;Of course I will first check whether the PDF file is on the wrong layer and therefore cannot be plotted.&lt;BR /&gt;This is not the case !&lt;BR /&gt;Let's try it in a different way:&lt;/P&gt;&lt;P&gt;If I insert the sheet data by selecting it in Google sheet and pasting it as text in AutoCAD, AutoCAD pastes all data from the columns together and you get 1 full text of data.&lt;BR /&gt;If you do this again per column of about 30 rows, the text in AutoCAD is not long enough and the lines no longer run evenly in the drawing.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;2) I would like to make a (Dynamic) block of, for example, a sewer pipe and this data (about the entire drawing) should be placed in a Google sheet.&lt;BR /&gt;So if I draw 4 tubes of 6 meters with a certain diameter, they have to come back in the sheet. However, if I stretch a block to only 4 meters, this must also be indicated and adjusted in the sheet file.&lt;/P&gt;&lt;P&gt;Who can give me a guide on how I can handle this?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance for your cooperation.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;John&lt;/P&gt;</description>
      <pubDate>Tue, 24 Nov 2020 11:18:06 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9891675#M39766</guid>
      <dc:creator>jvgerwen-PlantLab</dc:creator>
      <dc:date>2020-11-24T11:18:06Z</dc:date>
    </item>
    <item>
      <title>Re: Insert Google sheet data AND Collect data from blocks to an extern sheet document.</title>
      <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9892112#M39767</link>
      <description>What AutoCAD variant and year-version are you using on your MacOS computer?</description>
      <pubDate>Tue, 24 Nov 2020 14:28:42 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9892112#M39767</guid>
      <dc:creator>pendean</dc:creator>
      <dc:date>2020-11-24T14:28:42Z</dc:date>
    </item>
    <item>
      <title>Re: Insert Google sheet data AND Collect data from blocks to an extern sheet document.</title>
      <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9892689#M39769</link>
      <description>Welcome to Autodesk Forums!&lt;BR /&gt;&lt;BR /&gt;Hi &lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/9334222"&gt;@jvgerwen-PlantLab&lt;/a&gt;,&lt;BR /&gt;&lt;BR /&gt;If you are using AutoCAD for Mac, then you should be able to insert Excel table to your drawing (DATALINK) even if you don't have Excel on your Mac.&lt;BR /&gt;&lt;BR /&gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;Only if I plot the drawing now it prints everything except the inserted PDF file.&lt;BR /&gt;Verify that PDF underlay inserted on printable Layer.&lt;BR /&gt;&lt;BR /&gt;About 2-nd question - if you are using AutoCAD for Mac, I'm afraid it is not possible.</description>
      <pubDate>Tue, 24 Nov 2020 18:09:51 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9892689#M39769</guid>
      <dc:creator>maxim_k</dc:creator>
      <dc:date>2020-11-24T18:09:51Z</dc:date>
    </item>
    <item>
      <title>Re: Insert Google sheet data AND Collect data from blocks to an extern sheet document.</title>
      <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9896692#M39780</link>
      <description>&lt;P&gt;&lt;SPAN&gt;Hello Maxim Kanaev,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks for your quick response, i'm happy with it &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@59C40FF4A66238AB63B8D5D30F650901/emoticons/1f609.png" alt=":cara_guiñando_un_ojo:" title=":cara_guiñando_un_ojo:" /&gt;.&lt;/P&gt;&lt;DIV class="tlid-input input"&gt;&lt;DIV class="source-wrap"&gt;&lt;DIV class="input-full-height-wrapper tlid-input-full-height-wrapper"&gt;&lt;DIV class="source-input"&gt;&lt;DIV class="source-footer-wrap source-or-target-footer"&gt;&lt;DIV class="character-count tlid-character-count"&gt;&lt;DIV class="cc-ctr normal"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;DIV class="tlid-results-container results-container"&gt;&lt;DIV class="tlid-result result-dict-wrapper"&gt;&lt;DIV class="result tlid-copy-target"&gt;&lt;DIV class="text-wrap tlid-copy-target"&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;I tried your proposal:&lt;BR /&gt;1) I make an Excel file from my Sheet data.&lt;BR /&gt;I can insert this Data sheet via &lt;STRONG&gt;DATALINK&lt;/STRONG&gt; into AutoCAD 2021 for MAC. So that works without AutoCAD nagging you to install Microsoft Excel.&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Foto 26-11-2020 om 08.58.jpeg" style="width: 999px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/848905i07DB29211ADE02AA/image-size/large?v=v2&amp;amp;px=999" role="button" title="Foto 26-11-2020 om 08.58.jpeg" alt="Foto 26-11-2020 om 08.58.jpeg" /&gt;&lt;/span&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;I save the drawing and open it again with AutoCAD WINDOWS.&lt;BR /&gt;(If you want to remove the datalink within AutoCAD WINDOWS, that will not work!)&lt;BR /&gt;Also not working with the option:&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;A) rename or remove the linked .dxe files&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;B) copy / paste this:&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;[color = # ff0000] (dictremove (namedobjdict) "ACAD_DATALINK") [/ color]&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;in the commandline, ENTER&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;C) save and close the drawing, reload drawing&lt;BR /&gt;This has to go through the AutoCAD MAC version because you can simply remove it there.&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;BR /&gt;In any AutoCAD version, you will get an error on this Data link after you save it!&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Foto 26-11-2020 om 09.44.jpeg" style="width: 999px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/848909i759B2A30968AB34D/image-size/large?v=v2&amp;amp;px=999" role="button" title="Foto 26-11-2020 om 09.44.jpeg" alt="Foto 26-11-2020 om 09.44.jpeg" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Foto 26-11-2020 om 09.21.jpeg" style="width: 999px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/848906iC14BFAD697C404D0/image-size/large?v=v2&amp;amp;px=999" role="button" title="Foto 26-11-2020 om 09.21.jpeg" alt="Foto 26-11-2020 om 09.21.jpeg" /&gt;&lt;/span&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Foto 26-11-2020 om 09.45.jpeg" style="width: 999px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/848912iA0E07607B379CA83/image-size/large?v=v2&amp;amp;px=999" role="button" title="Foto 26-11-2020 om 09.45.jpeg" alt="Foto 26-11-2020 om 09.45.jpeg" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;Then I am faced with the fact that the data in the sheet is displayed too small.&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Foto 26-11-2020 om 09.35.jpeg" style="width: 999px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/848908i21B130B3D2E465C8/image-size/large?v=v2&amp;amp;px=999" role="button" title="Foto 26-11-2020 om 09.35.jpeg" alt="Foto 26-11-2020 om 09.35.jpeg" /&gt;&lt;/span&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;If you select the sheet table, you cannot edit any text, if you select a cell in this table, you may edit the text in size, but this is not immediately possible for all data in it.&lt;BR /&gt;Anyone have a solution for this?&lt;BR /&gt;&lt;BR /&gt;2) I can use both AutoCAD 2021 versions, both the WINDOWS and MAC version.&lt;BR /&gt;So if you have a solution how to&lt;/SPAN&gt;&lt;SPAN style="font-family: inherit;"&gt;&amp;nbsp;make a (Dynamic) block of, for example, a sewer pipe and this data (about the entire drawing) should be placed in a Google sheet I like to hear it.&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;P&gt;So if I draw 4 tubes of 6 meters with a certain diameter, they have to come back in the sheet. However, if I stretch a block to only 4 meters, this must also be indicated and adjusted in the sheet file.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;SPAN class="tlid-translation translation"&gt;Thanks in advance.&lt;/SPAN&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;</description>
      <pubDate>Thu, 26 Nov 2020 09:13:58 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9896692#M39780</guid>
      <dc:creator>jvgerwen-PlantLab</dc:creator>
      <dc:date>2020-11-26T09:13:58Z</dc:date>
    </item>
    <item>
      <title>Re: Insert Google sheet data AND Collect data from blocks to an extern sheet document.</title>
      <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9896697#M39781</link>
      <description>&lt;P&gt;Hello Pendean,&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;I'm Using AutoCAD Windows AND Mac 2012&lt;/P&gt;</description>
      <pubDate>Thu, 26 Nov 2020 09:15:31 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9896697#M39781</guid>
      <dc:creator>jvgerwen-PlantLab</dc:creator>
      <dc:date>2020-11-26T09:15:31Z</dc:date>
    </item>
    <item>
      <title>Re: Insert Google sheet data AND Collect data from blocks to an extern sheet document.</title>
      <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9896751#M39782</link>
      <description>&lt;P&gt;Answer to my own question:&lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@4B149DEBE9444851F5B3B7CD5A021A7E/emoticons/1f60a.png" alt=":cara_que_sonríe_con_ojos_sonrientes:" title=":cara_que_sonríe_con_ojos_sonrientes:" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;DIV class="tlid-input input"&gt;&lt;DIV class="source-wrap"&gt;&lt;DIV class="input-full-height-wrapper tlid-input-full-height-wrapper"&gt;&lt;DIV class="source-input"&gt;&lt;DIV class="source-footer-wrap source-or-target-footer"&gt;&lt;DIV class="character-count tlid-character-count"&gt;&lt;DIV class="cc-ctr normal"&gt;&lt;U&gt;&lt;STRONG&gt;&lt;SPAN style="font-family: inherit;"&gt;Fix for the text height in the cells of the table:&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/U&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;DIV class="tlid-results-container results-container"&gt;&lt;DIV class="tlid-result result-dict-wrapper"&gt;&lt;DIV class="result tlid-copy-target"&gt;&lt;DIV class="text-wrap tlid-copy-target"&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;SPAN&gt;Select the cell in the table at the bottom left of your screen.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Foto 26-11-2020 om 10.32.jpeg" style="width: 650px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/848923i83CF90810BEE90CB/image-size/large?v=v2&amp;amp;px=999" role="button" title="Foto 26-11-2020 om 10.32.jpeg" alt="Foto 26-11-2020 om 10.32.jpeg" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;SPAN&gt;Hold down the SHIFT button and then select the diagonally opposite cell within the table.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Foto 26-11-2020 om 10.39.jpeg" style="width: 323px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/848925i9E16DCDF5D4FABAC/image-size/large?v=v2&amp;amp;px=999" role="button" title="Foto 26-11-2020 om 10.39.jpeg" alt="Foto 26-11-2020 om 10.39.jpeg" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;SPAN&gt;You can now change the text height by properties.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="result-shield-container tlid-copy-target"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;SPAN class="tlid-translation translation"&gt;&lt;SPAN&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Foto 26-11-2020 om 10.43.jpeg" style="width: 342px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/848929iAAB46DC4707B4A08/image-size/large?v=v2&amp;amp;px=999" role="button" title="Foto 26-11-2020 om 10.43.jpeg" alt="Foto 26-11-2020 om 10.43.jpeg" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;</description>
      <pubDate>Thu, 26 Nov 2020 09:44:16 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9896751#M39782</guid>
      <dc:creator>jvgerwen-PlantLab</dc:creator>
      <dc:date>2020-11-26T09:44:16Z</dc:date>
    </item>
    <item>
      <title>Re: Insert Google sheet data AND Collect data from blocks to an extern sheet document.</title>
      <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9899190#M39784</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/9334222"&gt;@jvgerwen-PlantLab&lt;/a&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;1/&lt;/P&gt;
&lt;P&gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;&lt;SPAN&gt;In any AutoCAD version, you will get an error on this Data link after you save it!&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;That is because you used incorrect AutoLISP statement to remove Data Link.&lt;/P&gt;
&lt;P&gt;It should be:&lt;/P&gt;
&lt;LI-CODE lang="general"&gt;(dictremove (namedobjdict) "ACAD_DATALINK")&lt;/LI-CODE&gt;
&lt;P&gt;but not "&lt;SPAN&gt;&amp;nbsp;[color = # ff0000] (dictremove (namedobjdict) "ACAD_DATALINK") [/ color]"&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;2/&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;&lt;SPAN class="tlid-translation translation"&gt;So if you have a solution how to&lt;/SPAN&gt;&amp;nbsp;make a (Dynamic) block of, for example, a sewer pipe and this data (about the entire drawing) should be placed in a Google sheet I like to hear it.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;At first I have to mention that in order to be able to update Excel document from AutoCAD, you need to have Excel installed on your Windows machine, because&amp;nbsp;you need to use Data Link feature.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;At the same time it&amp;nbsp;is possible to create new table in AutoCAD each time you change Dynamic blocks&amp;nbsp;parameters (tube&amp;nbsp;&lt;/SPAN&gt;length) and then export this AutoCAD table to spreadsheet.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Look at these articles:&lt;/P&gt;
&lt;P&gt;- the first one uses Data link feature:&lt;/P&gt;
&lt;P&gt;&lt;A href="https://thecadgeek.com/blog/linking-excel-and-autocad-with-data-links/" target="_blank"&gt;https://thecadgeek.com/blog/linking-excel-and-autocad-with-data-links/&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;- the second one uses Data extraction feature:&lt;/P&gt;
&lt;P&gt;&lt;A href="https://autodesk.blogs.com/between_the_lines/2010/03/autocad-tip---reference-a-block-count-in-a-field.html" target="_blank"&gt;https://autodesk.blogs.com/between_the_lines/2010/03/autocad-tip---reference-a-block-count-in-a-field.html&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;You may also ask your question about linking Dynamic blocks information with external spreadsheet on &lt;A href="https://forums.autodesk.com/t5/autocad-forum/bd-p/706" target="_blank" rel="noopener"&gt;AutoCAD Forum.&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 27 Nov 2020 11:43:12 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9899190#M39784</guid>
      <dc:creator>maxim_k</dc:creator>
      <dc:date>2020-11-27T11:43:12Z</dc:date>
    </item>
    <item>
      <title>Re: Insert Google sheet data AND Collect data from blocks to an extern sheet document.</title>
      <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9899510#M39786</link>
      <description>&lt;P&gt;Hi Maxim_K,&lt;/P&gt;&lt;P&gt;Thank you very much for your answer.&lt;/P&gt;&lt;P&gt;You know more about it than I do&amp;nbsp;&lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@42FD1585940E1C7D5DE9D6FAAFF7955F/emoticons/1f601.png" alt=":cara_que_ríe_con_la_boca_abierta_y_los_ojos_sonrientes:" title=":cara_que_ríe_con_la_boca_abierta_y_los_ojos_sonrientes:" /&gt;&lt;BR /&gt;1) But I don't get an error message, in my opinion, because the link has been deleted but because AutoCAD just doesn't understand the link, the data is normaly listed as a table in my drawing!&lt;BR /&gt;2) I'll take a look at the articles/links you write:&lt;/P&gt;&lt;P&gt;A:&amp;nbsp; - the first one uses Data link feature:&lt;/P&gt;&lt;P&gt;&lt;A href="https://thecadgeek.com/blog/linking-excel-and-autocad-with-data-links/" target="_blank" rel="nofollow noopener noreferrer"&gt;https://thecadgeek.com/blog/linking-excel-and-autocad-with-data-links/&lt;/A&gt;&lt;/P&gt;&lt;P&gt;I can't use it because I don't have Microsoft Excel, only Google Sheets.&lt;BR /&gt;B:&amp;nbsp;- the second one uses Data extraction feature:&lt;/P&gt;&lt;P&gt;&lt;A href="https://autodesk.blogs.com/between_the_lines/2010/03/autocad-tip---reference-a-block-count-in-a-field.html" target="_blank" rel="nofollow noopener noreferrer"&gt;https://autodesk.blogs.com/between_the_lines/2010/03/autocad-tip---reference-a-block-count-in-a-fiel...&lt;/A&gt;&lt;/P&gt;&lt;P&gt;I&amp;nbsp;come back to this item if its works&amp;nbsp;&lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@4B149DEBE9444851F5B3B7CD5A021A7E/emoticons/1f60a.png" alt=":cara_que_sonríe_con_ojos_sonrientes:" title=":cara_que_sonríe_con_ojos_sonrientes:" /&gt;&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;Have a nice weekend.&lt;BR /&gt;John&lt;/P&gt;</description>
      <pubDate>Fri, 27 Nov 2020 14:37:06 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/9899510#M39786</guid>
      <dc:creator>jvgerwen-PlantLab</dc:creator>
      <dc:date>2020-11-27T14:37:06Z</dc:date>
    </item>
    <item>
      <title>Re: Insert Google sheet data AND Collect data from blocks to an extern sheet document.</title>
      <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/10661926#M42136</link>
      <description>&lt;P&gt;Being a Data Analyst and &lt;A href="https://thedataxp.com" target="_blank" rel="noopener"&gt;Excel Spreadsheet Consultant&lt;/A&gt; my suggestion is you can use block attribute data extraction, it allows you the ability to extract attribute information from blocks or objects into a table object or CSV file for use in another application like google docs. The data extraction wizard is the most efficient way to extract attribute information. It can also be used to extract property values that are associated with the other types of geometry defined in a drawing along with general information about a drawing file. That's what is currently offered in AutoCAD, let me know if this seems like what you were looking for or you were just making a suggestion.&lt;/P&gt;</description>
      <pubDate>Sat, 02 Oct 2021 07:38:27 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/10661926#M42136</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2021-10-02T07:38:27Z</dc:date>
    </item>
    <item>
      <title>Re: Insert Google sheet data AND Collect data from blocks to an extern sheet document.</title>
      <link>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/12975743#M48681</link>
      <description>Is this intended to navigate any features of Civil 3D? This would be much clearer if it called out specific functions that can be made in the Civil 3D application. Thank you.</description>
      <pubDate>Thu, 22 Aug 2024 19:42:18 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-for-mac-forum/insert-google-sheet-data-and-collect-data-from-blocks-to-an/m-p/12975743#M48681</guid>
      <dc:creator>cesaralfredo019</dc:creator>
      <dc:date>2024-08-22T19:42:18Z</dc:date>
    </item>
  </channel>
</rss>

