File Exchange

image thumbnail

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.

13 Downloads

Updated 30 Sep 2019

View Version History

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 (2020). Copy Sheet from one excel file to another excel file (https://www.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file), MATLAB Central File Exchange. Retrieved .

Comments and Ratings (2)

Keqin Xu

It works!

manjula agarwal

Thank You for the explanation on this sheet I was searching <a href="https://newshunt360.com/textsheet-alternatives/">textsheet alternatives</a> but here I find the solution of how to copy from sheets.

MATLAB Release Compatibility
Created with R2016b
Compatible with R2011b and later releases
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!