I have created a Excel spreadsheet to impoort into my Inventor model, but one of the valves that I have created need to be a unitless/type. How do I set up a Excel cell to acheive this
When I use the import excel points function in the 2D sketch menu of Inventor 2013, nothing happens when I open the excel file. No points are drawn in the sketch... I don't even get an error message... I have tried the same thing on another computer with the exact same spreadsheet and it works 100%.
I'm running Inventor 2013 service pack 2 on a Lenovo Y570 with an Nvidia GeForce GT555M GFX card
When i import points (csv) from my excel sheet into Civil 3D, i can't see the actual points on the display frame, but i can see that the points have been imported by looking at the prospector tab > Points.
I know that to design for example a 3d curve i have to import a XYZ data points from excel. What if i wanna link these points from excel to Inventors curve? Everytime i change the excel file i want my curve to be updated.
when I use the tool "import points from excel to inventor" in sketch mode, it looks fine. I pick the option "create lines". is there any way to create one line by one line? because inventor will give you "Z" shape when you create two different line in different "row".
Is there a way of inserting points from an excel spreadsheet that come into the part file already fixed, instead of manually selecting the points and selecting the fix constraint?
I am trying to create a 3d surface by importing points from an excel file. I have been using "import points" in the 3d sketch mode, and checked off the box that says "create 3d spline." But this just causes Inventor to freeze and crash. My excel file had about 2000 points, all of which lie on the surface I want to create in Inventor.
Should this method work in theory, and do I just have too many points?
I want to import my excel table to autocad. but when i try to do this, the table is not correctly import. im using paste special command and past to link. if i paste my file excel, image and other formats, i can not plot my draw. i attach my excel file.
note: i found a software that name is autotable. but its 150$. we dont want to buy an other software.
I'm importing custom iproperties from an excel document into inventor using the code I've written below. I've figured out how to bring up a dialog box to select the excel file I need, but I'm completely stumped when it comes to selecting the sheet within the file. As it is now, I'm specifying the sheet in the code itself (Str. C). My goal is after selecting the excel file from the dialog box, have ilogic list all the sheets within the excel file, then be able to select which sheet I need using a radio box, list box or some sort of prompted entry.
I've just finished up a ground level survey. I've jotted the coordinate and levels down in my notebook and typed them up on Excel. I'm having trouble getting the coordinates from excel into AutoCAD Civil 3D 2013 version.
I'm VERY new to this sort of stuff as a trainee site engineer the most I do is simply take coordinates from a drawing to set out on site. I'm importing the points from file using Civil 3D.
I've simply saved the coordinate on excel as, for example:
430245.454 434264.654 62.321
I get this error "No point file format match found" when I try and import them. I've had a look at some Youtube videos and I'm not sure what I'm doing wrong. Maybe it's the file type I'm saving it under.
I'm trying to import an excel table into autocad. I can copy paste using ole and that works fine. It prints well, but when I print it as a PDF the file is not legible.
I am having a problem with my table that I insert from excel into ACAD 2010. The Data in excel is on automatic color and arial text, once imported into ACAD as ACAD entities the data in my table does not want to change to being bylayer as the cell type is set to but instead stays on white. The only way I can change the color is by entering the cell and changing it manually to bylayer.
Recently I have been trying to build table driven products and ipart tables, but when I copy a member to create a new part number, upon exiting the iassembly author I get the following message "excel installation is required for this operation. failed to launch excel". I have a fully functional version of 2010 Excel installed which has been used so it should be recognized in the windows registry. I am running Windows 8 and Autodesk Inventor 2014.
is it possible to import a microsoft excel table to auto cad and have it be autocad lines and text? it is a rather large table and would save me alot of time if i didnt have to redraft it.
I am designing a RCC Dam and the shape of the dam is constant and will not change, but the dimensions of this shape are very likely to change depending upon hydraulic analysis.
I have written a program (irrelevant, but I am using MathCad 14) that performs a stability analysis of a RCC Dam (based on elevations from the hydraulic analysis) and then exports the dam dimensions and coordinates to Excel.
I am attempting to then take those coordinates (or dimensions) from Excel to create a 2-D dimensioned drawing of the Dam in AutoCAD.
I have successfully linked the Excel spreadsheet containing these coordinates and dimensions to AutoCad tables in my drawing, but I am having trouble getting AutoCAD to update my drawing as these tables update with different coordinates and dimensions.
I would like to have a drawing that is fully dimensioned (as the shape of the dam will not change), but that will update coordinates and dimensions as I pump out different dam dimensions from my stability analysis.
Can you import layers from a file other than the AutoCAD types, e.g. .dwg, .dwt etc? I have made a list of layers in Excel that I would like to import into AutoCAD without having to manually create each layer at a time (there are approx 150 layers).
I have an excel sheet containing alignment coordinates i.e
Station Number Northings Eastings and Tangential Direction
I wanted to export these into Civil 3d so that I can work with the info. What format would I save my excel document? is it 'text (tab delimited)' or 'csv (comma delimited) or formatted text (space delimited)?
I've tried all the above but I keep getting an error message from AutoCAD that point files not in right format
I want to import my excel table to autocad. but when i try to do this, the table is not correctly import. Im using paste special command and past to link. if i paste my file excel, image and other formats, i can not plot my draw. i attach my excel file.
Note: i found a software that name is auto table. but its 150$. we don't want to buy an other software.
So i have a simple block of basically a point. i also have alot of points to input. I know i can attribute the block with promts such as levels or dates etc.. but is there a way to make the block do this by itself when level is already entered? also is there a way to insert multiple block (like the points) using excel concatenate function? or can i input the points and have date and level shown in a text form?
When I try to attach a 2013 Excel file into a 2014 drawing I get a message 'You have selected an unsupported DGN File. Only V7 and V8 files are supported.' Cannot attache through the Import command either. I know in past versions you could insert the file and any changes made to the file appeared to the attachment in the drawing.
Is this no longer possible? Surely not, it is way to handy. What am I overlooking to make this happen?
Sitka 1/3 arc-second DEM is the page for the source of the .asc file.
I downloaded the rather large (190 mb) zipped file of a large ASCII file with a few extra things (readme, metadata, report)
I followed this how-to document.
And I get the error message "Cannot set the column 'Name'. The value violates the MaxLength limit of this column." And then nothing at all happens. No data imported.
Also, if I can't find the coordinates they assigned to the Ascii and I choose one I always use for this area, could that be the problem?
And I'l attach a photo of the 'preview' screen before I get before the error message.
I am trying to import a list of customers from column A in an Excel file into a list for a popup_list for my Drawing Properties DCL. I am having trouble finding information on how to do this.
Basically: Load the file, (workbook through active sheet: vlax-get-property)
I work for a company that makes sheet metal cabinets. Each cabinet we construct has 17 parts that all different different blank sizes and notching. I have a template for each part right now that I have to shrink or stretch to the appropriate size every time we get a custom size order.
What I've created so far is an excel spreadsheet that determines the sizes of all the parts based on the overall height width and depth of the custom cabinet that was ordered. Any way to define a parts properties with a dynamic block and get the width depth or height imported in from the excel spreadsheet to automatically adjust the size.
We have a points file to create a "bottom of peat level" surface. The only problem is, along with the X and Y, it only gives us the distance from OGL, not the actual Z Elevation at each point. How do we import these into C3D to create a surface? We have a topo survey for the whole site, so we have and EG surface.