AutoCAD Inventor :: Getting Data Correctly From Excel Sheet

Oct 5, 2012

I´m having a couple of problems with getting data correctly from an Excel Sheet. I´m using the Excel Sheet to get Data for the Stock Number based on geometry.

First time the Excel File get´s opened it always cannot find the first sheet. I´m using a german Version and Sheet1 is Tabelle1 in german.

It always searches for sheet1 the first time the script runs on a new derived assembly. The second time (on second part) it correctly finds Tabelle1 and reads the correct value.Here is the code I´m using:

[code]

myXLS = "K:IdentNr.xls"
GoExcel.Open(myXLS)
i = GoExcel.FindRow(myXLS, "Tabelle1", "Stärke", "=", Stärke, "Material", "=", iProperties.Material)
IdentNr = GoExcel.CurrentRowValue("IdentNr")
iProperties.Value("Custom", "IdentNr") = IdentNr

[code]

And there is another issue which I have solved already but still gives me a bit of a headache. When the userdefined property IdentNr gets written into the part it always defaults to a numerical value, which means that I always get a comma at the end of the Stock Number.

Only when I define IdentNr like this:

Dim IdentNr As String

the format is correctly set to Text.I expected that when you read a value from an Excel Cell that the Format of the Cell gives the format of the user defined property. Is that not correct?

View 4 Replies


ADVERTISEMENT

CorelDRAW X6 :: Does Not Output Excel Data Correctly

Jun 16, 2013

Microsoft OLE doesn't seem to work flawlessly in CorelDRAW:

Create a new CorelDRAW file

Select menu item "Edit > Insert New Object ..."

Select "Microsoft Excel Worksheet" from the dialog box. This creates an Excel Worksheet within the CorelDRAW file.

Edit the Excel Worksheet to contain some text in the Worksheet's cells.

Alter the font for some of the cells.

Select menu item "File > Publish to PDF ..."

You will notice that in the PDF file the text is all rubbish:

I have added a CorelDRAW X6 file to this post. Unfortunately this forum doesn't allow for file attachments being bigger than 256k. So I had to upload the CorelDRAW file as an "image" by renaming its file extension. ... Please right-click on above image to download the CorelDRAW file and delete the ".png" file extension from the name in order to download the CorelDRAW file correctly. The correct file name should be "CorelExcelImport.cdr" on your hard disk.

CorelDRAW Graphic Suite X6.4  @  Windows 7/Windows 8 - 64 Bit, Windows Server 2008 R2, Windows Server 2012

View 8 Replies View Related

AutoCAD 2013 :: Data Link Excel Sheet

Dec 23, 2013

I have made a data link to an excel file. Then I bring it in as a table. I then adjust the text height and remove all formatting from the table. Unfortunately, after closing and re-opening the file, the table changes. I lose formating/cell alignment/text height. It isn't even consistent across the table. The lost formatting is only on the 2nd split of the table, the first side retains the corrected formatting. I have selected the option to not update excel formatting. I don't even get a notification the table is updating. There haven't been any changes to the excel sheet either....

View 6 Replies View Related

AutoCAD 2013 :: Locked Cells In Data Linked Excel Sheet

Aug 15, 2013

I have been using a lisp routine to strip formatting from a linked excel sheet. (stripmtextV5) .When I try and run it on a sheet today it says some cells are locked. I've changed the cell format in the excel file to unlocked. I have unlocked the cells in the linked table. Yet it still says that some cells are locked...I have even picked in each cell to verify each one is unlocked.

View 5 Replies View Related

AutoCAD Architecture :: Furnish Hyperlink Linking On Defined Data Sheet Within Excel File

Jan 15, 2013

Is there a possibility to furnish a hyperlink linking on a defined Excel-data sheet within an Excel file? Are there other possibilities to tie together to a drawing object external additional information, e.g., a product name, product data or product pictures?

View 1 Replies View Related

Maya :: Excel Spread Sheet Data As Input For Animation?

Aug 16, 2012

I have a spreadsheet in Excel that is split into columns. The first is the frame number, and the subsequent columns are the rotations about the X, Y and Z axis. There is also a column that has the location in the Z axis from the origin (0). These values are currently being input manually and keyed. The object being animated is a locator node which will form the parent of an object.

Is there a way to have these values read in automatically and for each frame to then be keyed to that value?

As I've never touched MEL or Python I wouldn't have a clue where to start trying to write some sort of script to do this.

View 1 Replies View Related

AutoCAD Inventor :: Metal Sheet - Final Face / Can't Be Mirrored Correctly

Dec 4, 2013

I need to create such part by using Metal Sheet features from Inventor (2014). The problem is the final face..which can't be mirrored correctly and sure can't go with "flat pattern.

View 3 Replies View Related

AutoCAD Inventor :: Create Sheet In Excel With ILogic

Jan 9, 2014

I am trying to create a new sheet in an existing excel file and can not figure out how to do it.

I am trying to export parts lists from multiple drawings to an exisitng excel spreadsheet and I'd like have each on their own sheet. I can do everything but create a sheet. How to do this in iLogic?

Inventor Pro 2013 (PDS Ultimate)
Vault Pro 2013
Windows 7 64
Xeon 2.4 Ghz 12GB

View 2 Replies View Related

AutoCAD Inventor :: Sheet Metal Rules Excel File?

Apr 18, 2012

A local search of my HD and a search on the subject here returned with zero results...

Where does one find the Inventor Sheet Metal Rules excel table for 2012 on a Windows 7 system?

All the documentation says it's located in the Documents and Settings directory, but Windows Vista eliminated that folder and thus it is not in Win7 either.

I can find the SheetMetalRules.xml file, but I need the excel table for modification.

View 3 Replies View Related

AutoCAD Inventor :: Title Block Info From Excel Sheet

Dec 21, 2005

I've created a custom title block. I'd like to use VB to fill in this title block using info obtained from an Excel Spreadsheet; Company Name, Location, Drawing Title, etc.

View 5 Replies View Related

AutoCAD Inventor :: Link Parameters To Vault Excel Sheet

Oct 7, 2013

I am making an assembly where I wanted to use an excel sheet to link common paramters between the parts. I know how to do it for just my single system, but I am wanting to have all the parts and the excel sheet stored in my vault server. Is there anyway to link the parameter list to the excel file stored in the vault or how can I go about having a common file that everybody can access.

What I am worried about is if the excel file is located on my computer and someone tries to open a part on another machine, it will not find the excel parameters and everything crash.

View 4 Replies View Related

AutoCAD Inventor :: 2013 Can't Delete Linked Excel Sheet

Aug 6, 2013

I have a excel sheet linked to my inventor file and I cant delete it. I really only need to change the starting cell, but I can't do that either. It works on some parts to right click on the folder in the parameters window and then select delete or change start cell, but on others it doesn't work.

View 5 Replies View Related

AutoCAD Inventor :: Linking Excel Sheet To Drawing File (idw)?

Jan 7, 2014

I am trying to link excel file to drawing file (idw), but couldn't succeed.

View 2 Replies View Related

AutoCAD Inventor :: New Dimension Through Fx Parameters (using Link Excel Sheet)

Apr 3, 2013

I tried to match the dimensions of the already existing product with new dimension through fx parameters(using link excel sheet), while conversion all the dimensions are changed except taper value (By default it comes with inch instead of degrees) It can be changed by adding user parameter but i want it to consider from excel sheet data itself. Is it possible? For reference i have attached the snap shots

View 1 Replies View Related

AutoCAD Inventor :: Embedding Excel Into Sheet Metal Template

Sep 7, 2012

How do you embed (not link) an excel spread sheet into my sheet metal template.

The excel file is simple, 2 rows listing the A1=gauge and B1= decimal equivalent.

What I want to do with this is to get the gauge to show up in the iProperties description along with length and width of part.  The thing is I need column A to show up in the iProperties (12GA) but column B to be used for the sheet metal default thickness.

I keep getting this error when I run my code.

Error in rule: Gauge, in document: Part1

GoExcel: 3rd Party worksheet not found: "3rd Party:Embedding 1", Sheet: "Sheet1"

Code so far..

i = GoExcel.FindRow("3rd Party:Embedding 1", "Sheet1", "Gauge", "<=", iProperties.Value("Custom", "Gauge"))MultiValue.List("Thickness") = GoExcel.CellValues("3rd Party:Embedding 1", "Sheet1", "B2", "B35") 

View 9 Replies View Related

AutoCAD Inventor :: How To Make Forms Share Excel Data

Oct 13, 2011

I set up a Form in Inventor using parameters that are driven from Excel. I cannot edit the form.

View 6 Replies View Related

AutoCAD Inventor :: Imported Excel Sheet Display Half Of Parameters

Jul 18, 2012

I'm trying to link an Excel sheet to a new assembly but it is only listing half of the sheet parameters. I have done this before with no issues. I've also imported another sheet and it works fine. I copied and renamed a sheet I know that works deleting the data from it and coping the data I want and I get the same results. This lead me to believe there is something wrong with the sheet. See attached file.

Excel 2010
Windows 7
Inventor 2012 64 bit

View 3 Replies View Related

AutoCAD Inventor :: Export Center Of Gravity Coordinates (X Y Z) From Assembly To Excel Sheet

May 8, 2012

I'm trying to build a VBA code in inventor 2010 to export the Center of gravity coordinates (X,Y,Z) from an inventor assembly to an excel sheet.

But I'm not able to get the iproperties for the COG from my assembly.

View 1 Replies View Related

AutoCAD Inventor :: Linking 2007 Excel Spread Sheet To 2009 Part

Jul 16, 2013

I am trying to link a Excel spread sheet to an Inventor 2009 part.  It worked great on Friday now it is not working.  The only thing that changed was that there was a windos update.  When it does work I am unable to update any of the parametes that are linked to Excel file as the update button has disappear.  

View 2 Replies View Related

AutoCAD Inventor :: Update K Factor / Sheet Metal Type From Excel Parameter Spreadsheet

Apr 9, 2012

I have a set of sheet metal parts modeled in inventor that are produced in a wide range of sizes and several different sheet metal types.

The dimensions (length, width, flange size, etc) are driven from a spreadsheet. I would like to be able to have the user update the K Factor from the same spreadsheet by selecting a sheet metal type.

The sheet metal type and K factor are not listed in the parameters list with the other model dimensional data, so I'm not sure how to proceed.

View 1 Replies View Related

AutoCAD Inventor :: Connect Parts List Data From One Sheet To Detail View In Another?

Mar 9, 2012

Background:  Our company has decided to switch from drafting in AutoCAD to Inventor (which we already use to model) and we have started looking at making our templates intuitive using iProperties, parameters, and functions to reduce manual entry of part information in turn to reduce human error.  None of us have any experience coding besides a bit of LISP.

Problem: Perhaps it is a pipe dream, but one thing I would really like resolved is we have no connection between the Parts list information (specifically item number and quantity) on the assembly sheet and the part detail on another sheet.  Our custom part detail title block pulls the material information and "Inventory Part Number" from custom iProperties we have set up at the part level, but we still need to reference the parts list in the other sheet and then manually enter the item number and quantity.  Is there a way to use the "Inventory Part Number" property (which shows up in the parts list on a different sheet) to populate our custom block?

View 1 Replies View Related

AutoCad :: Excel Table Not Printing Correctly

Jun 29, 2011

I would copy the excel table that I need, go to AutoCAD 2010 and use PASTESPEC , then choose AutoCAD entities. After I resize it and whatnot, I would then print it.

For some reason, the first row wouldn't print correctly. Sometimes the words get cut off or it doesn't show at all. If I were to move my drawing up to that portion of the paper, the drawing appears fine.

So that rules out a printer alignment issue, is it the excel table itself? Fonts and font color are standard across the table, so I'm baffled by this little problem.

Any better way to copy an excel table into a CAD file? The method I use will end up having the table appearing as a small, miniscule table, I always have to drag it up to resize and change the font size etc. etc.I'm guessing I have to set a default annotation scale for it?

View 9 Replies View Related

AutoCad :: Updating Between Excel Sheet And DWG

Feb 14, 2012

I am trying, to make a data extraction with Link External data with linking to a excel sheet. Everything works fine, with the data extraction.

Then I try using upload to source/download to source update, but end up with this msg. every time:

1 object(s) found.
1 data link(s) do not allow their data to be written out.
0 data link(s) written out successfully.

I have tried when it said, successful all the way, but nothing have happen in the excel sheet at that time.

What I am trying to do, is make it automatic or manual update in the attributes in the drawing. If I change something in my excel sheet and ofc. the other way around to if possible.

View 9 Replies View Related

AutoCad :: Import Excel Sheet?

Oct 19, 2012

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 Related

AutoCad :: How To Get Excel Sheet Incorporated

Sep 17, 2012

Currently i am trying to get an Excel sheet incorporated into my AutoCAD layout. I get it in and it seems way to small. I re-scale the excel insert and get it right then update the sheet to get the new info and it shrinks back down. Now i thought at first it was the excel insert that was the problem, but now looking my layout seems to be extremely large and that's why the excel sheet is off. How can i take my existing layout and change it to fit 11x17. I really don't want to have to redraw the whole layout to make it fit 11x17.

View 9 Replies View Related

AutoCad :: How To Transfer Data From Excel

Nov 8, 2011

I saw a youtube video "Cross Section in AutoCAD".But i could not understand how to transfer the data from excel to AutoCAD.There is a file TMaker.exe to make template of excel data.I could not find that elsewhere on net. Making earthwork x-sections with AutoCAD.

View 9 Replies View Related

AutoCad :: How To Import Excel Xyz Data

May 29, 2007

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.

View 9 Replies View Related

AutoCad :: Importing Excel Data

Apr 6, 2010

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.

View 9 Replies View Related

AutoCAD 2010 :: Insert Excel Sheet

Jan 26, 2013

What is the best way to Insert an Excel sheet into autocad?

View 4 Replies View Related

AutoCad :: Get Numbers From Drawing To Excel-sheet

Apr 18, 2012

I've made a big calculation in a Pipe Stress Analysis program and the program has auto created 10 autocad drawings that is used to find points in the system.The problem is that the program has random numbered (with no intelligence) and now I have a big report which for example points at a number some where in the 10 drawings, which is hopeless to find.

Can I somehow:

1. Find all numbers in this drawing.
2. Put them into Excel.
3. Sort them after size.
4. Add an extra column which tells which drawing I can find the number.
5. Last put all the numbers from all the drawing into one Excel sheet and sort them after size, now I have a number index, so I can find which number is in which drawing.

Can Autocad find all numbers in a drawing and let me copy them to Excel for editing?

View 4 Replies View Related

AutoCad :: Link Excel Sheet With A Drawing

Oct 28, 2010

I want to link an excel sheet with a drawing, so changing the excel changes the drawing.

I used this awesome site to learn about going to Edit->Paste Special->Paste Link->AutoCAD Entities...but I don't have that choice. Just the one that makes the OLE image. While that will work, that is less than ideal. It appears in just normal paste, but not under paste link.

AutoCAD 2007, A.54; Excel 2003 SP3; Windows XP SP3.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved