how to copy sheet from one excel to another sheet of excel.

1 次查看（过去 30 天）

Santosh Biradar 2022-8-4

关闭： dpb 2022-8-4

此个问题已被 dpb 标记

Hello

I tried below code

excelFile1 = fname; --> It is having Excel file format data with .xlsx extension

excelName1 = fullfile(newPath,excelFile1);

excel = actxserver('Excel.Application');

Workbooks = excel.Workbooks;

wbsource = Workbooks.Open(excelName);

wbdest = Workbooks.Open(excelName1);

ws = wbsource.Worksheets.Item(newidx); ---> here newidx will be having sheet name from OLD excel.

ws.Copy(wbdest.Worksheets.Item(1)); ----> error at this line

wbdest.Save %save destination workbook

excel.Quit

Error:

Dot indexing is not supported for variables of this type.

Error in IncDecAnalysis (line 58)

ws.Copy(wbdest.Worksheets.Item(1));

I have seen few of documents but could not find solution.

Thank you

此问题已关闭。

此问题已关闭。

R2019b

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

Translated by