In SW 2013, we use to copy/paste from Excel to SW. Now in 2016, the copy/paste only show limited columns. It seems to have a fixed width but I cannot find where is this setting. Double click on the table within SW and scaling-dragging don't show more column, only show them bigger.
If I go thru Insert/Object from file, everything is fine... but my people prefer Ctrl-C / Ctrl-V
Any suggestions?
Still you can not get all the columns and rows in there.
Hi.
I also have this problem all the time.
Has there been any resolution?
Works fine for me on SW2016. What happens hen you double click on the paste table? Are you able to extend it out?
So I select a group of cells in Excel.
Then Ctrl+C
Then on my SW drawing sheet, I press Ctrl+V.
Fine, it pastes the selected cells.
However, some of the columns towards the end are cut out.
So I extend out the pasted table. But all this does is causes the scale of the table to enlarge. i.e. all the text becomes bigger.
But it does not include the end columns which are cut out. Even if I try to resize the columns to be smaller.
Reduce font size in excel and shrink the working area as much as you can.
That is how I am fixing my drawing, if anyone has better idea please advise.
Thank you
Could you record a video and share what is happening on your machine.
I tried to upload vide but I was not able to.
this is my original selection from excel, up to row # 117 and 12 columns.
when I copy and paste my selection in sw drawing it looks as follows.
Only up to row #58 and 10 columns
the way I am fixing this is by reducing font size in excel.
I hope this will help you to understand the issue.
Thank you
I found another walk-around that can be intersting to others:
If I drag the file directly from an explorer window (within Windows) and drop the icon on the drawing, I get the right result.
Work with Windows 7 + Excel 2013 + Solidworks 2016