File Exchange

image thumbnail

Copy Sheet from one excel file to another excel file

version 1.0.1 (2.13 KB) by Pruthvi Raj Gampalwar
A script intended to copy sheet from one excel file and paste to another and renaming the sheet required.

16 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 Raj Gampalwar (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 (0)

Updates

1.0.1

Updated http://www.prudhvy.com

MATLAB Release Compatibility
Created with R2016b
Compatible with R2011b to any release
Platform Compatibility
Windows macOS Linux