Copy Sheet from one excel file to another excel file

Version 1.0.1 (2.13 KB) by Pruthvi G
A script intended to copy sheet from one excel file and paste to another and renaming the sheet required.
650 Downloads
Updated 30 Sep 2019

View License

%%*********************************************************************************************************************
% Name : copy_sheet_ExcelX
% Author : Pruthvi Raj G :: www.prudhvy.com
%
% Version : Version 1.0
% Description : A script intended to copy sheet from one excel file to another and renaming the sheet required.
%
% Input : 1. Input_file & Input_SheetName
% 2. Output_file & Output_SheetName
%
% Date : 30-Sep-2019.
%
%
% Examples : copy_sheet_ExcelX('D:\Pruthvi\Test_file.xls','D:\Pruthvi\Test_file_output.xls','Input','Output')
%
% % Output sheet name will be same as Input sheet name.
% copy_sheet_ExcelX('D:\Pruthvi\Test_file.xls','D:\Pruthvi\Test_file_output.xls','Input')
%
% % Takes 'Sheet1' as Default Input Sheet
% copy_sheet_ExcelX('D:\Pruthvi\Test_file.xls','D:\Pruthvi\Test_file_output.xls')
%**********************************************************************************************************************

Answer to below Questions :
Moving excel sheets within excel file
Copy and Paste Excel Sheet into New WorkBook
Copy XLS Sheet
How do I copy and paste excel spreadsheets from one excel file to another?

Cite As

Pruthvi G (2026). Copy Sheet from one excel file to another excel file (https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2016b
Compatible with R2011b and later releases
Platform Compatibility
Windows macOS Linux
Version Published Release Notes
1.0.1

Updated http://www.prudhvy.com

1.0.0