Copying from Excel to Excel column by column

I have a 20 by 78 matrix in an Excel file and wish to copy this column by column to another Excel file (into separate sheet. I have tried using xlsread and xlswrite, and found that the first and second columns copies correctly into Sheet 1 & 2 but the last column is copied into Sheets 3 to 78. Can anyone help me out

1 Comment

Post the code you're using: http://www.mathworks.com/matlabcentral/answers/6200-tutorial-how-to-ask-a-question-on-answers-and-get-a-fast-answer
To format the code: http://www.mathworks.com/matlabcentral/answers/13205-tutorial-how-to-format-your-question-with-markup#answer_18099

Sign in to comment.

Answers (0)

Asked:

on 10 Aug 2011

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!