I have a general table in my engineered print. It consists of basic columns with text. How can i have Inventor refresh the data if i change the Excel without having to delete and re insert a table ?
Autodesk Inventor Professional 2011
I've spent the last 4 hours searching for an answer to this question, but I simply can't find one.
As a start I think you have to know that I'm currently using AutoCAD 2012.
Here's the problem: I need to extract some info from an AutoCAD table to a reference file that can be opened in Microsoft Excel. Everything I find on the subject is actually an answer to the question "How does <DATAEXTRACTION> work?" or "How to do an extraction of DATA in AutoCAD?"....
In this particular case I have a set of production drawings (cut tickets) for manufacturing of stone. And in every single sheet I have this material schedule or a table, if you wish, that is made with an AutoCAD table. In this schedule I have the height, width and thickness of the stone plate and with a function it measures it's area and volume. What I want to do is to extract those values into a reference file that I can open with Microsoft Excel, as I already said.
How exactly?
For Creating my own templates i want to use iLogic and embedded Excel-Spreadsheets. The embedded Sheet has its own data, but i want to create a rule to refresh the data from an external Excelsheet.
For now i use the following rule:
For I = 65 To 90 '65=A 90=ZBuchstabe = Chr(I) GoExcel.CellValues("3rd Party:Embedding 1", "Platte", Buchstabe & "1", Buchstabe & "999") = GoExcel.CellValues("G:KonstruktionVorlagenMaterialgrunddaten.xlsx", "Platte", Buchstabe & "1", Buchstabe & "A999")Next I
it works well, but wont insert a new single-sheet or refresh formats, i have to add the same code for each sheet. And its REALLY slow.
Is there a possibility to refresh or replace the whole embedded file via a simple iLogic-rule?
We have a whole bunch of spreadsheets that we use for calculations and parts of those spreadsheets are linked to a ton of CAD Drawings via data links.
We would like to be able to deliver the CAD drawings to the client without having to send our calculation books (just the output tables). In other words, is it possible to embed the table data and remove the excel link for the final delivery?
I do bird photography and would like to create a smart collection that would capture for example all of the warbler / magnolia that I have captured. I'd like to have the capture date, file name, and keyword in a spreadsheet file.
View 2 Replies View RelatedI'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 RelatedI have a batch of 5000 pictures (jpg). I need to add the information that I have in an .xls file (Excel), from a column with the description of each picture. Each description is different from the others, so I would have to assign the code number of the file jpg (first colum of the excel) to the correspondance info that exists in the column of the description/caption into the IPTC field.
I have tried several ways, applications that I have found through Google, but I have no way to do it. It seems that the origin of the problem is the xls file or the txt file that I have had to created to try to do the importation. In any case messages of errors like "the file does not exists", etc etc. I don`t know what to do it. It's very important and urgent for my job.
* I work with MAC OX S 10.7.5, Adobe Photoshop CS5.1
* I have tried applications like: DIY Metadata, VRA Export-Import Metadata and another ones... which names I don't remember now.
I have an excel file with thousands of rows, each with a column for the x-coordinate, the y-coordiante, the height, and width of a rectangle. I need a script that will ask me to select the excel file, read the excel file, and create rectangles from each of the thousands of rows. I'm working in a windows environment and have Illustrator CS4. Any scripts out there that might give me a start?
View 7 Replies View RelatedI 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 have problem when insert too lenght table from Excel.
Inventor cut column...I used Manage -> Insert Objec
OK...so when I copy the desired cells form the excell worksheet and paste to paintnet, it works fine...the entire range of cells copied show up in the paste, but...if you first eliminate the gridlines in excell before copying the range of cells, the paste into Painnet only shows one section/quadrant of the excel range of cells which I copied. I don't want the gridlines showing in the final .png file...I know this must be possible...
View 3 Replies View RelatedI tried Curtis Waguespack's iLogic: Export Parts List with Options, and it works great on Part Lists. I'd like to do the same thing on a custom table, but I don't know what needs to be changed.
View 3 Replies View RelatedHow to fix a broken link to an excel table in an idw file general table?I changed the folder name and heirarchy of the project.i expected the idw tables to find their parent excel files in the same folder with a new name, but they didn't.
I could find nothing for fixing broken excel links.
In our company, we put Excel tables in our drawings. The reason we've chosen for Excel-tables is that we can adjust the layout of the table quite easily. These tables consist of grouped cells in a particular company-specific layout. We select the range of the desired cells, copy and paste them in our AutoCAD drawing. This drawing is sent to our customers. The disadvantage of this method is, that when our customers (who use CAD-software of other brands) open the dwg, they don't see the table, but some kind of picture of the table.
Is there a way to 'explode' the excel-table, but keep the specific layout of the table? For attributes in blocks there's the 'Explode Attributes'-command in the Express-tools, but is there something similar for Excel-tables?
Product Design Suite 2014
Inventor 2012 SP2, Vault 2014
HP Workstation Z220
Intel Xeon 3.4GHz
16GB RAM
Nvidia Quadro 4000
Windows 7 Professional (64bit)
I am using a link to an .xls worksheet to populate a General Table in my .idw (Inventor 2012). See attached. The blank space underneath the first lines of information will always be blank, no matter how many rows we get. Is there a way to have the drawing hide the blank/empty cells, make the borders invisible, etc?
I have tried using the Insert Object for an Excel file instead of using the Table feature, but it does not appear to be an updatable link. As in, if I change data in my .xls file, it won't update the inserted object to the same info.
How can I export a excel table to Autocad not as an OLE object but as a Audocad table?
View 7 Replies View Relateddifference between the "Refresh File" and "Revert to Latest" commands in the Vault browser within Inventor 2013? We just started using the Vault Collaboration 2013 flavor of Vault.
View 4 Replies View RelatedI have found a few things on here, but not exactly what I want. We have a excel spreadsheet with borehole references and coordinates. I need to be able to insert a block according to these coordinates and the borehole reference as the attribute.
View 5 Replies View RelatedI want to be able to make a alignment table with northing and easting coordinates for the following:
bop
pi's
eop
Is this possible? The closest I get is to make a curve table with the pi coordinates and no bop or eop coord'.
Civil 3D 2014
Win 7
I'm linking an excel file to an .ipt file with iLogic code determining if the Material type is a certian value it will find the correct material thickness. These file work great when working on them thru Vault but when I "Save As Template" and create this file where our other template files are located (not Vault) this fuction does not work. I have realized that I had to place the a copy of the excel file in the same file folder as the template ipt, but even this does not fix the issue.
I recieve this error:
Error in rule: Material, in document: Part6
'MWW Materials (Inventor).xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.
If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.
It seems completly countintutive that just saving the file as a template file would cause this not to work when all files that are required are located in the same file folder. Maybe I need a reference to the excel document within the iLogic code.
Ok, so I understand how to take my Inventor designs and make them into a .adsk file for use as BiM info. Without having revit how in the world am I supposed to check what I'm sending out to my clients? It goes against everything I've ever learned to just make a file and send it out blindly without checking it.
Is this really how Autodesk thinks this process should work?
why I can't export the "Distance 1" attribute out of thsi drawing using the ATTOUT command. I need to build a series of constrained drawings using Dynamic blocks so I can send info from an Excel spreadsheet back and forth bewteen a drawing. I think I'll have to buy a 3rd party utility for that but for now, how to simply get the info out of ACAD and into Excel thsat would be a great start.
View 2 Replies View Relatedi have deleted the excel file from the ipt file but when i open the part file it is still looking for the excel file. i am using inv 10 sp1 and excel 2000
View 7 Replies View RelatedI am trying to create a table that will incorporate info from structures and pipes. In C3d 2010 I want to make a CB chart which will show the pipe size, starting structure and invert. I would also like to include the CB rim elevation but that would be under the structure table. Is there any way I can combine the RIm elevation with the pipe table?
View 4 Replies View RelatedI'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.
View 4 Replies View RelatedI want to export a table to excel but i am failed.and is here any way that when i give coordinate it automatically exportes to excel.
View 2 Replies View RelatedI link an excel spreadsheet of text into my .idw files and I constantly have this issue where the text is crowded (see attached). I've tried changing the font, etc. but nothing seems to work. Every once in a while if I move the linked sheet within the .idw it corrects itself.
I'm using Inventor 2012.
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
I have used the command "insert object" to embed an excel sheet. I can see in the modelbar the new stage called "3rd Party", expanded I also see "Embedding 1". If I use edit I can see my excel sheet. So far good.
My next task is to create a Rule to recall cells in the sheet. I use the command CellValue (embedded) to pick my cell value. My problem is that then I close my rule-editor I got the error:
Error in rule: Rule0, in document: Box test.ipt
GoExcel: 3rd Party worksheet not found: "3rd Party:Embedding 1", Sheet: "Sheet1"
It seems like I´m not able to recall my cellvalues.Whats the difference between embedding a excelsheet as above or use the add link command i Parameters window?
When inserting object - xls file, i found trouble, max. number of column i see in dwg file is 22.
Creating table using table - general require long time for set up every column (different with)
I have a table imported into autocad from excel, however despite the table (excel) being formatted, border lines appropriately placed and hidden througout the sheet, all off the border lines of the cells appear when imported into autocad.
is there anything i can do to hide back some border lines for selected cells?
I have a number of tables which have all properties about the pipe network with the cooridnates and upstream/ downstream info. Can it import to C3D and automatically generate the pipe to 3D?
View 9 Replies View Related