I habe 2 csv files. For example bellq 1 file: a b C

2 file;

1 2 3

Final output: It has to come in one excel but in different worksheet using linux command Excel Sheet1. Sheet2 a. 1 b. 2 C. 3

Can i know which command to get this. I tried with linux command 'paste -d ',' file1,file2>>excel.this command is coming in single sheet of excel instead of separate worksheet

  • 1
    Excel doesn't run on Linux, so I'm not sure how you would go about doing this. In addition, csv files don't support multiple sheets. – Herb Wolfe Feb 17 '17 at 1:58
  • Ok. Is there anyway in excel whenever a contents copy into sheet1, automaticallly it has to go sheet2.Through vba can we achieve that? – saieem ali Feb 17 '17 at 3:20
  • that would be a different question. I suspect something like that could be done, but I don't know vba that well. – Herb Wolfe Feb 17 '17 at 3:26

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.