While in my AutoCad drawing, I need to be able to select cells in an Excel database and use them as variables to create a drawing. I've looked on the Internet and have found some bits and pieces of code for particular uses, but what I'm looking for is the methodology, or some training/examples on working with Excel and AutoCad using VB.net.
View 3 RepliesI had a bit of a search around the net and what I found mostly said it can't be done natively in AutoCad although I thought I might as well ask anyway.
I want to link individual mtext objects in AutoCad to cell contents in an Excel file (like a datalink for a table, but I can't use a table in this instance). Any thoughts?
If it is not possible it is not a huge deal although hopefully the design doesn't change in the future as it will be a pain to update all these manually
I simply want to paste a series of cells from excel into an existing autocad table. About 8 rows, 1 column thick. I want the values to acquire the destination formatting too if possible. I do not want to create an OLE object or anything fancy. I have seen instructions to use "Paste Special" on forums, but I do not have this choice when I right-click. I'm sure this is possible.
View 8 Replies View RelatedI want to copy a value/text in cells from excel and paste it in specific mtxt that has been made in existing .DWG file.
I have done it by copy and paste, but it doesn't work effectively since there's too many cells to be pasted.
One of my cells entry which should be copy is in D5 and the coordinate of mtxt in autocad is (17,46 15,03 0,000) both of those file is located in same folder
We are a MEP firm, using AutoCAD 2011 and Excel 2007, and our project is a building with 1000+ rooms. Each room has specified supply and return airflows that need to show up in text in each of the rooms. All the airflow values are calculated in a spreadsheet.
My thought is to use fields in the text that shows up in each room, then link each field to a specific cell in Excel, because these values will be evolving over the next year.
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 RelatedIs this something that is possible? Basically I have an excel file with sample data that comes coded (red background for fail, Green for pass) Then we transfer that into halos on a DWG. got a routine to count the halos in a DWG. Now I was thinking it would be nice if it compared the number to the excel file to make sure no mistakes were made when placing the halos.
So as I mentioned I've seen rountines to read data in cells but none to count cells based on colour.
Regarding the conversion of an excel sheet into Illustrator variables... I am able to import an excel sheet into Illustrator datasets. I am curious if it is possible to link the excel file to the Illustrator data sets, so that when I alter something within the excel sheet, the data sets automatically change. Is this possible? Or must I always freshly convert/import the excel file?
View 2 Replies View RelatedI have an issue with copying cells containing text from Microsoft Excel 2011 for Mac and pasting them into Illustrator CS5. I select the whole cell(s) from Excel, open a blank Ai document and, without anything selected so the format is preserved, I paste the cells.
The issue comes with the resulting copy of the cells in Ai. The type which was bold in Excel is bold in Ai... but not really. Ai pastes the bolded text as not bold, but then makes a copy of that same text, puts a stroke on it, then places that over the regular text, so it looks bold. But now I have two copies of the same word, one regular and one with a stroke on it right on top of one another.
This normally wouldn't be an issue but I have to edit this info in Ai later - and there's a second problem. When I paste the bold text from Excel in Ai, the resulting word is broken up into individual text blocks for each letter. Instead of preserving the whole word as one editable text block, I now have to click on each letter to change it.
There is a catch 22 to these problems: These cells that I am copying from include bolded and regular text, and the regular text pasted into Ai without any problems (even the text blocks are preserved). So it's the bold text that is causing the problems
I have a feeling this has to do with how the individual cells are formated in Excel, but I have to copy data from many different cells made by many different people, so I am at a loss of what to do.
I have include a screen shot of what's going on with cells after I paste them in Ai. I have moved the oulined "5" up so you can see the regular "5" below it.
1. Is it possible to read excel files through script files.
2. Can I declare variables in script files.
When storing data in ResultBuffer, I found, that there are DxfCodes, that seem to have the same meaning.
DxfCode.ExtendedDataAsciiString Vs. DxfCode.Text
DxfCode.ExtendedDataInteger16 Vs. DxfCode.Int16
What are 3 types of paths that can be used for storing an xref? when inserting an xref, how does the Overlay option differ from the Attach option? can xref drawings be scaled, rotated, or positioned at any desired location?
View 3 Replies View RelatedI need to create and maintain a library of hole features of varying shapes and sizes (there will only be around 10 variations). The goal is to be able to programmatically retrieve a feature and then place it in the current part. Ideally I would like to be able to assign each an ID to each feature that I can use to programmatically retrieve it.
My first thought on how to achieve this is to have one master part file that contains all of the features. When I need one I can open that file and somehow copy the appropriate feature and then place it in the target file.
Or maybe it would be better to save each feature in its own part file? I'm not so much looking for code as much as general guidance on whether either of these approaches sound reasonable. Maybe there is a better way to programmatically store and retrieve features from a library?
Where the proper location to store custom images for new custom materials? We do not use vault and I currently store everything locally. I found where Inventor stores all of the material library images in C:Program Files (x86)Common FilesAutodesk SharedMaterialsTextures. In that "Textures" folder there are Inventor material images stored in folders named "1","2 "and "3". Should I paste my custom image in all three folders, or a completely different location? I need Inventor to find this material and image for every new project so I save it to my library but I do not know where to store the image.
View 2 Replies View RelatedI am looking for some way to store variables. For example in loop I want to
Enter a number
1
Enter hatch pattern
Ansi31
Enter a number
3
Enter hatch pattern
Ansi32
Enter a number
1
Enter hatch pattern <Ansi31>
Enter
Enter a number.... etc.
Does CS6 fix the extremely annoying (<-yeah I did, I used the B I U trifeccta) habit of AE storing .TMP files wherever in the hell it sees fit (usually, but no always, the drive with the most space).
View 1 Replies View RelatedWell this is not strictly an InDesign issue, but I'm counting on the aggregated knowledge and experience of all you typesetters here.So, what would be the best way of storing manuscripts? Text files, perhaps? What about formatting; markup language? How publishers archive them?
View 3 Replies View RelatedI am having a problem with a delay in selecting an object and selecting a command.
When I select an object the pointer has at least a 3 second delay before it starts moving around normally again. It is the same with selecting a command. This has started to get tedious. It has worked fine in the past so I don't think it is a RAM/graphics card problem.
I want save a psd file and send it to someone via the internet. If I do this, will they receive it as just a psd image or will it be a psd image WITH all the work I've done, showing in the 'Layers' box. (All the blending options, etc. so that the receipient can tweek it)? I need them to be able to see it.
View 5 Replies View RelatedWhen 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 RelatedI am trying to merge two cells in one but i cannot find proper method to do that.
Example:
I am creating a table with dynamic number of rows and columns:
for (int i = 3; i < tbRight.NumRows; i++)
{
for (int j = 0; j < tbRight.NumColumns; j++)
{
if (num2 == numCircles - 1)
{
Cell c = new Cell(tbRight, i, j);
c.TextHeight = 450;
tbRight.SetTextString(i, j, (num2 +
[Code]...
First row of the table is the header and i have two free rows with two columns each. I want to merge all of them to look like one row.
On the other hand, is it possible to align the text in the table in the middle and also the vertical align to be in the middle.
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
I'm on XP and want a simple program for cleaning up and storing old photos.
View 4 Replies View RelatedI just bought a new laptop in July. Got Elements soon after. I have been taking digital photos since 2006. I have over 7,500 photos. I have used all of my online storage.
1. How do I get Photoshop to look at my hard drive for photos?
a. How do I use the online storage as a backup of, say, photo albums?
2. How do I get Elements to stop loading ALL 7500 photos every time I open it?
I'm using DSL, so you can imagine how incredibly SLOW EVERYTHING is in Elements.
I'm still trying to figure out how to organize everything. I stopped using it for a few months becuase I got so frustrated. But now I've scanned in more photos (75) and I have to finish my mom's scrapbook. I've read parts of Elements for Dummies, but I still don't get it.
I've created the attached table (used as legend in drawing, to point out revisions).
Cells in second column from the left are set as data dd/MM/yyyy, so when I change revision I write current data and it give correct format.
The problem is that every time I change layout and come back (or every time I open the drawing), data in empty cells were set to 01/01/1970...but I want them empty.
If I clean them, I clean also the data format.
OK, today, or actually just this afternoon I've noticed it has become much harder to select items with the mouse.
Points, nodes, etc...anything where you'd typically hover the mouse over the item and it highlights for you to select it.
For example, lets say you want to project a point from another sketch, or select the center node of a line, etc.
Never really had an issue until this afternoon where now it seems I have to be right on top of the item and I cannot budge one bit or it won't select it. It is now taking me numerous attempts to select things like points (zooming in does not work, points scale accordingly).
Is there a setting somewhere? I can't seem to find such under Tools>Application Options and the like.
What I'm trying to do is to use set cell background color to change the color based on whether or not there is text in the particular cell.
I want LtCol to be 161 and HvyCol to be 211, and I'm not sure how to set this up...all it does at the moment is change the color to black.
My code so far:
Dim TableObj As AcadTable
Dim EntObj As AcadEntity
Dim i, j As Long
Dim LtCol As AcadAcCmColor
Dim HvyCol As AcadAcCmColor
[code]......
I'm trying to make a BOM using a Table. I want to be able to export. I cannot seem to keep the formatting in the length column. I would like it to read feet & inches (example 5'-4 1/2"). These lengths will change often during the design process. The problem I'm having is when I clear the cell contents or delete the information the formatting does not stick. I've tried locking the cell format but that doesn't seem to work. I've attached a file with the table.
View 8 Replies View RelatedI can't find the way to unmerge previously merged cells in curtain walls.
View 2 Replies View RelatedI have a drainage structure table for a leaching system. I used some expressions to calculate some of the leaching pool values for the Top Of Rings etc. When the expression is false I get a zero. The expression work as expected, and I anticipated manually wiping out the false value, but when I wipeout or solid mask the values in MS they don't line up in the view port. How to effectively wipeout structure table cells?
Civil 3D 2012 & 2013
HP Z210 Workstation
Intel Xeon CPU E31240 @ 3.30 Hz
12 GB Ram
64 Bit Win7 OS