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?
I'm able to print pasted excel table with default colors ( ie: cell with text and fill with color background in autocad. By using Autocad 2013, with I can see the default colors when preview, but once I printed out to hard copy or PDF format, its only printed text but without any color background, I have try to print the pdf file by using DWG To PDF.pc3, Adobe PDF & CutePDF Writer, HP Design Jet T1120 plotter, all have the same result.
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?
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´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:
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?
The product is AutoCAD 2013 Architecture. It installed fine. Typically, as part of the install routine, I go in to the Plot dialog and set the plot style table to monochrome.ctb.
However, on this particular install... something is different. When I open the screen, typcially the plot style table is set to 'none' and I then set it to monochrome.ctb. That is not the case on this one. It is defaulting to AEC Standard.stb and monochrome is not in the list.
1.jpg
I read elsewhere to run CONVERTPSTYLES at the command line. I tried that and it did work..however it does not hold the setting. If I close and restart CAD, I am right back to the AEC Standard.stb default again.
This seems to just be a problem with new drawings? If I open one from the network, it does have the monochrome.ctb setting already set.
I assumed it must have been a problem with the default in options, but I believe I have it set correctly? See below.
2.JPG
If I interpret the above correctly, the plot style table drop down box should be defaulting to 'none' ? but it does not... it defaults to AEC Standard.stb.
I have already tried a complete uninstall/Reinstall of CAD and still have the same issue.
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 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?
I use an embedded excel file I a lot of my drawings. 90% of the time a double click opens excel for editing with no problem. But every so often I get a stubborn one that just will not open. It will select and the quick properties box will appear and then the properties box, but nor firing up of Excel. Usually if I am persistent I can get it to work, but I have one right now that is more stubborn than I am.
I inserted a table from excel to autocad with copy-edit/paste special/paste link / Microsoft excel worksheet(code) and everything seems to work nice until I closed the excel. After that no automatic updates to cad files.
PS: I checked the properties of the excel table and it is linked.
I have a table in Excel (well several tables actually) that I want to copy the contents from and insert into an AutoCad table. I don't want it as an OLE object (as I need to be able to edit it in AutoCad later if needed) and I don't want it as a datalink either, so what is the best way to do this?
I was trying to just copy the cells although kept getting all cells ending up in each row/column. I believe it is possible somehow as I am sure I have done it multiple times before although can't work out how to do it now.
Is there a correlation between the font size I use in an Excel spread sheet & the font size on the imported table on the drawing? My spread sheet font size is 8 point. I seem to recall that a point is 1/72" so my 8 point text should be 0.111" high on the drawing. When I import the table I get text that is 0.0556" high - looks like half the height of my spread sheet text. I tried doubling the spread sheet text to 16 point hoping it would end up half size on my drawing (0.111") but this time it is 0.125" high. The scaling of imported table text is inconsistent. I know I can change the properties of the drawing table to get what I want but it would be easier if there was a fixed relationship between Excel & AutoCAD table text height.
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 want to make a map with 16 different plots (A1 to D4) in AutoCAD. Every plot in this map is connected to an excel file, where is some information listed (area, height, year, type) per plot. This map need to be dynamic, so by chosing what to see (for instance: area), the color of the parcels needs to change according to the value per plot (for instance: 12 m2 = yellow, 24 m2 = orange, 48 m2 = red). The two files I am using are send with it.
how to program this in VBA in AutoCAD. The shape of the plots I want to draw on my own (hatching each plot is also no problem), and somehow I need to name each plot (hatch). But how can I name the plots (hatches) and change the colour per plot (hatch) in VBA? The files I am using have 1600 different plots.
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.
I am trying to insert an excel table using a datalink. If I insert the entire sheet, it includes too many cells. If I set a print area and choose that area, it will not insert the table. The first time it acts like it is going to work, but then never lets me place the table. The second attempt it just will not let me select that data link. If I actually name a group of cells, I get the same behavior as the print area. Have issues with importing excel tables? Am I missing a step?
My work flow is
Create an excel sheet & format the table.
Select desired sells, set print area.
Save & Close excel
go to annotate tab in civil 3d
select table icon
choose from data link
launch data link manager
create data link and choose range of cells as print area.
Press OK
it never let me choose insert point.
I have also tried to simply make the datalink and then run the table command with the same results.
Civil 3D 2013 HP Z400 Workstation 6GB of RAM 296GB HDD ATI FirePro V5700(FireGL) Win 7 Home Professional
I have linked a table from excel into autocad 2012. I have selected "Start with excel formatting, do not update" in the datalink options. My problem is when I break the table the first table will keep my formatting changes - text height and alignment, but the following table breaks do not stay the same once I close and reopen the drawing
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.
How to insert a linked excel table into my drawing, however I have not figured out how to add rows to the table, the option is greyed out. I can insert rows above and below the (inserted) table but not anywhere in the middle.
I've tried everything I can think of, even removing all the formatting in the .xls spreadsheet to no avail. The cells are unlocked, I can manipulate the data, but not being able to insert rows is really hindering the efficiency of using a data linked table.
This seems like it should be the most stupidly easy thing...but AutoCAD doesn't seem to have a way to do this. I made a point table from a point group. Quick and sweet.
But now I want to change it a little bit, and it's not something I can just do from the table style. So I want to copy it into Excel...and when I try to, hitting paste in Excel ends up just giving me this block image version of the table in Excel. I tried doing TABLE EXPORT but that's only for regular tables.
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.
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
I need to draw a table with point number, easting, northing, elevation for a lot of points and need a lisp to read the xl spreadsheet and draw the table.
