9 Replies Latest reply on Nov 21, 2016 9:38 AM by Samir Panchal

Issues copy/paste Excel table

Pascal Provencher Mar 21, 2016 4:13 PM

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?

Re: Issues copy/paste Excel table

Pascal Provencher Mar 22, 2016 3:05 PM (in response to Pascal Provencher)

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
Like Show 0 Likes(0)

Actions
- Re: Issues copy/paste Excel table
  
  Samir Panchal Sep 27, 2016 10:18 AM (in response to Pascal Provencher)
  
  Still you can not get all the columns and rows in there.
  
  Like Show 0 Likes(0)
  
  Actions
Re: Issues copy/paste Excel table

Xavier Leisher Nov 16, 2016 8:01 AM (in response to Pascal Provencher)

Hi.
I also have this problem all the time.
Has there been any resolution?
Like Show 0 Likes(0)

Actions
Re: Issues copy/paste Excel table

Xavier Leisher Nov 16, 2016 8:01 AM (in response to Pascal Provencher)

Deepak Gupta
Hi Deepak, have you got any help on this topic?
Like Show 0 Likes(0)

Actions
- Re: Issues copy/paste Excel table
  
  Deepak Gupta Nov 16, 2016 8:28 AM (in response to Xavier Leisher)
  
  Works fine for me on SW2016. What happens hen you double click on the paste table? Are you able to extend it out?
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Issues copy/paste Excel table
    
    Xavier Leisher Nov 16, 2016 8:40 AM (in response to Deepak Gupta)
    
    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.
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Issues copy/paste Excel table
      
      Samir Panchal Nov 16, 2016 9:12 AM (in response to Xavier Leisher)
      
      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
      
      Like Show 0 Likes(0)
      
      Actions
    - Re: Issues copy/paste Excel table
      
      Deepak Gupta Nov 19, 2016 9:14 AM (in response to Xavier Leisher)
      
      Could you record a video and share what is happening on your machine.
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: Issues copy/paste Excel table
        
        Samir Panchal Nov 21, 2016 9:38 AM (in response to Deepak Gupta)
        
        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
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post