Copy Sheet from one excel file to another excel file
%%*********************************************************************************************************************
% 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
Platform Compatibility
Windows macOS LinuxCategories
Tags
Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
| Version | Published | Release Notes | |
|---|---|---|---|
| 1.0.1 | Updated http://www.prudhvy.com |
||
| 1.0.0 |