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".
spec: window 7 64bit with inventor 2012
I am looking to import an excel file to creat points within LT 2012. Can this be done?
View 4 Replies View RelatedHow to import survey points from excel sheet into AutoCAD 2013?
View 2 Replies View RelatedI 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
View 1 Replies View RelatedI 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.
View 9 Replies View RelatedIs 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?
View 2 Replies View RelatedWhen 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
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?
Im struggeling with creating a code that opens a certain Excel spreadsheet and retrieves / inserts info.
the spreadsheet is a list containing part numbers for purchased components, therefore the list must be filled with information from iproperty. But it has to be where the next available number is. i had this working in iLogic, but have to move it to VBA for better use. the code that worked in iLogic is this one.:
[URL]
If possible it would be nice if the code at the same time retrieves the new partnumber and saves the active part as this part numeber...
We are trying to switch to a new parts list format, and the goal is to have all of our parts list imported from excel spreadsheets. The problem we are having is that we cannot import from excel and maintain the format from excel. The problem seems to be with merged cells. I have tried it both by: 1) Annotate > General > Table and 2) Manage > Insert > Insert Object with no success. I have a non-ideal work-around for this by inserting the "QTY PER ASSY" separately as a sketch symbol.
Attached is a sample of what we would like our parts list to look like. The red rectangle outline is what would be imported from excel.
I need one ilogic or macro for import the iproperties into excel sheet in a particular folder files.
for example
1.Author
2.Company
3.Part number
4.Description
5.Revision Number
6.Project
7.Designer
8.Creation Date
9.some of the custom iproporties
I'm looking for a way to export all iproperties, (from a selection or a directory), from windows browser, and CSV import into excel.
What I'm looking to do is, be able to select hundreds of files from the windows browser, either select the directory, (and it's sub-directories), or a selection of files, and extract their iproperties, and place the contents into excel similar to exporting contacts from outlook and importing them into excel.
i have made a iLogic Module who, whit an external rules, import the iProperties value from an external exel file.The exel file is connected from SQL with the our managerial software.This in the external rule:
i = GoExcel.FindRow("Z:DISEGNI_INVENTORDescrizioni.xls", "Descrizioni", "Cod.Art.", "=", iProperties.Value ("Project", "Part Number"))iProperties.Value ("Project", "Description") = GoExcel.CurrentRowValue("Descr. Articolo Princ.")'iProperties.Value("Project", "Project")
[Code] .....
It's work fine but i have same question. There is some string to refresh an iLogic Module? When i push the ruel button the rule add the custom value in iProperties, but there are disabled, i have close the module an reopen it for correct display the value of the iProperties.
this module work with single parts. Can I do an rule who do the same thing of my string but in one assembly, do this for every parts of assembly automaticly??
What are some techniques to import a list of points in x, y, and z? Many they be separate features or a grouped? (Manual Entry Vs. Batch Entry) (Single Entry Vs. Multple Entry)
View 4 Replies View RelatedI'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.
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.
View 2 Replies View RelatedI am very new to autocad and i am using 2013 student..
1) I have drawn a curved line for a Directional Drill Shot and need to create a points on it every 2 metres to give a Cord position,
2)I need to be able to transfer these points into a excel spread sheet.
When I link in an excel document to my model all parameters in that excel gets the unit (mm).
How can I change this? For instance I want some of the parameters to be an angle.
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.
View 6 Replies View RelatedSo 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?
View 2 Replies View Relatedi attached a lsp with and excel
the lsp does creat circles with diameter of 5 related to imported points from excel
i realsed that it is able to get the first column but can get the coordinate from the second one
(setq posX (atof (substr line 1 nPos))) (this is ok)
(setq posY (atof (substr line (1+ nPos)))) (not this one)
I have an excel file containing xyz co-ordinates that i wish to import to AutoCAD (2005).
I realise you can probably do this using the lisp function, but i don't know how they work, and wanted to know if there is an easier way.
I've to put some data as like table beside the figure. I've these data in a excel sheet. Can i import that sheet in CAD? or I need use table and re-type all data?
View 4 Replies View RelatedI am looking for a quick way to take x,y coord. from excel and import them into autocad. I have read something on the MULTIPLE POINT command but every time I go and put the space in between the words it enters in multiple then point. I only have 10 data points but a lot of sets of points.
View 4 Replies View RelatedI work as an engineer for a solar company. We preform all of our calculations on an excel file, then transfer these values to Autocad to show our calculations for the plan checkers. I use the DWGPROPS command in Autocad to auto populate all the pages in my plans. I tend to do a lot of copy and pasting and to do all this.
Is there a way to isolate the excel values I need and import them into my Autocad DWGPROPS?
I need to know if I can import an excel formula for a Von Karmen rocket nosecone and then model it. I do not know how to do 3D modeling only 2D. Is this possible? I would like to do the model isometric if possible. I also have some questions about doing an isometric drawing, but i'll try to figure that out on my own this week at home.
View 7 Replies View RelatedOn my Mac OS X (2010), running Excel 2011 and Adobe CS6, I'm having major issues with the points in a scatter plot not rendering as vectors once moved to an Adobe program. The entire plot will transfer as a vector, except the data points themselves! Oddly, even the shapes in the legend are vectors! When I save a plot from a powerpoint presentation as a pdf, the data points look pixelated in the pdf. When I copy paste the plot into illustrator, same thing. It is totally infuriating.
View 5 Replies View RelatedI have an excel file with a column containing polygon vertices like follows:
Row 1 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
Row 2 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
Row 3 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
I am looking for a .Net code that can read each row cell and draw the polygons automatically in AutoCAD window. I am having a bout 100 rows (polygons) and hence I prefer that the code will display all polygons at once in AutoCAD window and not draw them one by one.
I am already having Autolisp code to draw them one by one but I wish to have a .Net code to allow batch polygons drawing instead.
If it's possible to import Excel spreadsheets into my drawing, instead of using the tables? (Using AutoCAD LT 2014)
I guess technically it would be easiest if I could import LibreOffice Calc spreadsheets, but I can get access to Excel easily enough if it's the only option.
How to import data from excel (from particular cell) to AutoCAD Drawing. I have already Created a template for both Excel and AutoCAD. I want to do Whenever i am changing the datas in excel sheet corresponding changes to be done in AutoCAd drawing.
I am using AutoCAD 2010 and Microsoft excel 2007.
I want to send the contents of A1 to an Illustrator document at 135, 172 and B1 to 135,190, same with A2/B2 will be at different coordinates as will A3/B3 and so on... I want to do this 6 times and save the document as a PDF. Then, it should clear and do it again. The columns will ALWAYS be A and B.
View 5 Replies View Related