In this video I will tell you about importing and exporting people from Arctic air to miss Exel.
So here we have this table which we have made in the previous lesson and we will simply export it as
an Excel file.
So for exporting it as Select the table and then right click and select this export option from the
contextual menu.
Now specify the location where you want to save it in this case LCB it on the desktop and you can see
the file type we just see as we hear now give it a name and name it as table what the default name and
click on Save and the table has been saved on the desktop.
So let's go to the desktop.
And here we have this table.
Let's open it.
And here we have it.
So now you can see that we have the table.
Obviously the formatting has not been retained but all information which is contained in the table can
be seen here as well.
So you can again add the formatting to this table.
So let's now close it and move it back to our article drawing.
So in this case we have exported this table but you can also import any table from Excel to Autocad.
So we'll do that as well so I'll move it here and now import a new table to imported.
I'll select this table stripe down and I'll select the stable option.
Now here we have an option off from our data.
So I select this from where datalink option.
And you notice that all the remaining options will become deactivated.
Now click on this box and select Create a new Exel Datalink.
Now give this table name so I limit as our best table and then click on OK now browse for files or click
on this box and browse of file so I'll go to the next stop.
And here we have a test table.
So I created this test table already in EMIs Exel.
I'll select it.
Click on Open and now you'll be able to see the preview here.
So click on OK.
And in this window also click on OK and once again click on OK and now click anywhere in the drawing
area to place the table.
And here we have it the table has been added.
Now this table is linked with the original table which we have on the desktop.
So if any of the information on the original table is changed the table here will update itself.
So let's have a look at this table in this case we can see that this last cell has four five six.
So let's change this value in the original table.
So I'll go to this table there stable on the top.
And now you can see that here we have this four five six.
So let's change this value and let's change it to 500.
OK.
And now let's save it and I'll close it.
Now I'll go back to our two card and here we have a new bubble which indicates that the information
in our linked table has been changed so I'll click on this link to a information and closely look at
this.
Here we have four five six.
Let's click here.
And here we have it the new information has been added.
So in this way The table has been updated directly from the datalink which is present on the text top
here.
In this test table.
So in this way you can import as well as export a table from Autocad to excel file.