AutoCAD 2010 :: Excel Spreadsheets Show Up With Gridlines?
Dec 12, 2012
I have been having an issue when printing to PDF from AutoCAD my Excel spreadsheets show up with gridlines that are not there in there Excel or CAD. I have tried a number of things to eliminate that lines (see list below) but nothing has worked so far. I am running AutoCAD 2012 and Excel 2003. I have inserted the spreadsheet using "Paste Special" so that I can continue to work on the spreadsheet in excel and it will update in CAD.
- I have changes the Plot Quality. In Monochrome the lines print. Low quality the spreadsheet does not show up. High quality again nothing shows up
- In Excel I have turned off the "Gridlines" and re-copied into AutoCAD. The lines still show up when printing to PDF
- If I paste as an AutoCAD Entity I can not update in Excel
View 4 Replies
ADVERTISEMENT
Mar 13, 2012
We had a client who could not open our drawings that had linked Excel spreadsheets in them even though we supplied the spreadsheets. The drawings would crash AutoCAD when they tried to open them.
My solution was to open the drawings, pick on the Linked Spreadsheet OLE in the drawing, Ctrl+C (Edit > Copy) then I Edit > Paste Special > As Image. I would paste it in at the lower left corner of the existing spreadsheet.
I set the properties of the new OLE so the Lock Aspect Ratio was Off or No and drag the upper right corner of my newly inserted image to the upper right corner of the existing linked spreadsheet so it would be a perfect match.
I then erased the existing linked spreadsheet.
Now they can open the files and we don't need to include the spreadsheet when we send the files.
[URL]....
View 2 Replies
View Related
Apr 19, 2012
I have a new issue that I am unsure what to do about.
This has never occurred with previous version of ACAD and this is the first time I created data links with Autocad 2012, and I am using the same procedure that I have successfully used in the past.
I have data tables linked to excel spreadsheets. I used the "TABLE" button on the ANNOTATE ribbon to place the table, and the layout of the cells assumes the layout of the excel spreadsheet, which is what I want.
As long as I don't Scale the table, I can Update the data table links just fine.
However when I scale the table and then update table links, the table layout changes drastically, and is undesirable.
I have tried locking the cells' but that will not fix the problem.
I want to keep the layout of the table that is assumed when I place the table originally. Is there any way to lock it as such?
View 0 Replies
View Related
May 31, 2013
I would like to link an Excel table to a SHP file via a column in commun. My SHP file and Excel Spreadsheet share one same column filled with numbers. So it's neither simply import Excel table, nor import with points.
But I don't know if I should use "Data Link" or "Add ODBC connection" or "FDO import", or some other fonctions...
View 9 Replies
View Related
Mar 2, 2007
how to extract pile coordinates to excel or spreadsheets, or anything that works and is quicker than just individual pile coordinates. i have about 446 piles.
View 9 Replies
View Related
Jun 5, 2013
What I would like to do is find a way to use a dynamic block, which has already been created, and once I put in the proper length, speed, type of conveyor, etc., it will automatically update an excel spreadsheet, for example a power estimate, or cost estimate sheet. Is this possible, if so, what is the quickest, and easiest way to do this?
Also, what formula would I use in excel to link back to the DWG?
View 9 Replies
View Related
Mar 6, 2012
Ok what I'm tring to do is have a spreadsheet that has a list of prices in it that we could modify if needed for all these parts i'm making. Best way is to have the spreadsheet obviously external of the file.Though now I do not know how to do this in iLogic.And example of what I'm trying to do is, with 3 parameters.
A, B, and P
Value "A" and Value "B", these are just read items which when combined will give Value "P" to be imported into the Part file. So need A & B to be read and give the row number for P to be imported.
View 3 Replies
View Related
Jul 25, 2013
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 Related
Sep 14, 2013
I am trying to copy a picture with gridlines to word, I want to keep and show the gridlines... How do I do this?
View 1 Replies
View Related
Oct 12, 2011
When I add parameters to Excel, the new parameters do not show up in the linked parts. Even when starting
a new part and linking to the same excel file, the original parameters are all that are shown; not the new ones.
View 3 Replies
View Related
Nov 11, 2013
I'm trying to start Excel and show the results of some BOM items I have written to a file like item number, part number and description.The task is to find components in an assembly that have a part number longer then 39 characters, due to ERP limitations.
What I´m doing is cycling through all BOM (structured) items on first level and check if the part number is longer then 39 characters.
I write these item number, part number, description to an Excel file (temp.xlsx), so the user sees which Components he has to check for the Part Number (make it shorter). I figured it would be best to do that with an excel file, so the user can save the results to a new file or just check it.
Values will be erased from the temporary excel file afterwards.Here I can't figure out how to start the excel application and open the file in an actual application window if possible.
how to list the results with plain iLogic that would do it too or some other solution to list a snapshot from the BOM.I guess there is no way to add your custom BOMViews ?
View 6 Replies
View Related
Mar 24, 2012
Can export the repair details from dwg drawing prepared by asd in to excel by the use of auto cad?
View 3 Replies
View Related
Apr 3, 2012
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?
View 5 Replies
View Related
Sep 17, 2010
I created an assembly, so far with one part in it. I created an Excel spreadsheet with several dimensions in it that would be used in the assembly parts. I went to Manage>Parameters and linked the spreadsheet. The Excel file appeared in the Parameter Dialog Box with the parameters included in it. However, when I create a part in the assembly and attempt to dimension a sketch in it, the parameters option in the dimension box is not present.
I have done this in the past in IV2009, has anything changed that I cannot do so in 2010?
View 9 Replies
View Related
Jan 18, 2012
I am trying to add an excel document to a cad drawing using ole. I wish to make it transparent so that only the cells themselves are visible and not the white background and empty cells. (I hope that makes sense).
View 3 Replies
View Related
Nov 29, 2012
We have this problem at the moment with an Microsoft excel file that appears to have become stuck in the External references list, Ref C1-01-06. We would like to remove it if possible as it is now superseded (we can't change the file name unfortunately. What do we do if we can't reload, detach or bind? Its not referenced into anything else that is attached to the file, it is a direct attachment of the file that we are in.
View 3 Replies
View Related
Jan 26, 2013
What is the best way to Insert an Excel sheet into autocad?
View 4 Replies
View Related
Oct 13, 2012
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.
View 2 Replies
View Related
Sep 21, 2011
Seems like i export the data of thickness, diameter, lenght and mass to excel via dataextraction, but if i change something in the drawing, its not updated in the excel file..
I also wanted to export the data to an already existing part list template, but this seems impossible...
View 2 Replies
View Related
Jan 14, 2011
I have an Embedded spreadsheet in a .ipt file. I want to access the data in it using iLogic, but i keep getting this error...
GoExcel: 3rd Party worksheet not found: "3rd Party:Embedding 1", Sheet: "Sheet1"
Do I need to declare the spreadsheet somehow, or is there something else I missing? This is the only code I have in the rule...
i = GoExcel.FindRow("3rd Party:Embedding 1", "Sheet1", "ID", "=", 1
View 9 Replies
View Related
Aug 17, 2012
I am using Excel 2010 & LT 2012. I need to import spreadsheets into my drawings as OLE objects. For a while, the process worked fine - I could just copy to clipboard and paste the worksheet in as an image. For some reason, this is no longer working properly and the information will only insert as editable text, not the image of the formatted spreadsheet. Unfortunately I DO NOT want the information to be in an editable format. If I insert the worksheet as an OLE, only the first page will insert. The only solution I could come up with was to PDF each sheet of the worksheet and then PDFATTACH to the file.
I also do not have the AutoCAD Entities option of Paste Special. My only Paste Special options are Unicode Text, Text or OEM Text. I assume this is an LT difference.
Is there a setting or command that would allow me in insert the information as an image rather than Text...like I said, it worked properly for a while so I am thinking it might be a simple setting change...
Another issue is that when plotting spreadsheet information in CAD, it only registers 50% - the remaining information is not visible.
View 1 Replies
View Related
Jul 12, 2012
I was wondering how I can set my Elevation Text and Profile Major Gridlines at different intervals? It seems like there stuck to one another.
For example, I want my Major Gridlines at every 1.0m but show elevation at every 5.0m.
I tried 'splitting' the profile view with a hacked up style but it seems to be messing up my pipes. Is there a way I can make a vertical band of some sort?
Civil 3D 2011
Win 7
Intel Xeon 3.20GHz
15Gb Ram
Quadro 600
View 4 Replies
View Related
Feb 14, 2012
I'm trying to link excel to autocad for a time now.
and until now it didn't work for me.
Everytime it says "1 data link(s) do not allow their data to be written out."
thats when i try to write it to the excel file.
View 5 Replies
View Related
Jan 27, 2012
Using AutoCAD 2010, and I'm having problems printing with one dwg, that I've had to copy an Excel Spreadsheet into. The spreadsheet was created with Excel 2007, and has quite a bit of text in it, and I'm trying to print it on an E size sheet, to an HP Designjet 4000. AutoCAD hangs up each time I try to print this, and my computer gets a message indicating that I'm low on disk space, even tho I do have plenty of space. It's like Autocad is taking more resources than it normally should. How I can insert this spreadsheet into AutoCAD and be able to print it? I've inserted the spreadsheet in model space, and the titleblock/border is in paperspace. I've tried printing to pdf and exporting to other formats to see if that will work, but AutoCAD keeps hanging up. Any other AutoCAD dwg works fine to print to the printer. It's just this one file with a spreadsheet inserted into it.
View 5 Replies
View Related
Aug 20, 2010
I just installed Autocad 2011. I have Excel tables in one of my drawings that was in Autocad 2004.
However, with new 2011, I can not bring the OLE to Excel where I want to edit.
I got "OLE Failed to launch server app" error message.
I search around. It seems that I need to try the command "OLELINKS". But my OLELINKS under EDIT is DISABLED!
View 8 Replies
View Related
Dec 4, 2012
Everytime I open up a new drawing an error pops up that there is (2) Xref that cant load. It seems to be the same (2) Excel files I have to go to the Datalink Manager and delete them. Is there any way to get in the Datalink Manager without opening a drawing to unlink these?
View 3 Replies
View Related
Feb 8, 2012
I'm the only one out of a bunch of guys using 2012. Others in my office are using either 2010 or 2009. They can set up Excel tables with links and have no troubles but, the minute I try to edit one the link gets broken. I also have an issue where if I highlight the border of the OLE, right click, and try to open the OLE... I get a small error box saying that the server application has failed.
View 3 Replies
View Related
Oct 31, 2011
Any method to export text to excel such that the text is editable within excel?
I have a column of text (each text line is an individual mtext entity) and I would like them to appear in a column format in excel where each mtext entity has it's own cell.
View 6 Replies
View Related
Sep 24, 2012
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
View 1 Replies
View Related
Mar 30, 2012
I have a set of part descriptions that need to be changed. Each part description corresponds to a part number. See the example below of what it would look like in AutoCAD.
123 screw
265 bolt
847 washer
But this list can get really long. Each part number and each description is a seperate text string or mtext string. I plan on having an excel spreadsheet that has a list of all part numbers that my company uses with their corresponding descriptions.
I would like to use the part number to find the appropriate description and then change the description. Hopefully this can be done automatically for a list of part numbers and their descriptions.
View 1 Replies
View Related
Jan 28, 2010
I am making an excel spreadsheet that has a list of all the drawings we have on file, an inventory list per say. I have all of the drawings hyperlinked.
View 3 Replies
View Related
