how to open a excel workbook make changes in its first sheet while keeping all the other sheets along with the format as it is and write the workbook in other excel sheets?

Hello MATLAB Experts,

i have an excel workbook which has 4 sheets. so,in the first sheet i want to change the values of different cells for Ex- E35,E58,F67 etc. with the row values of 20x9 double.here we have 20 rows and 9 columns.so,i want to change value of 9 cells of excel with the row values of this double.after completing each row.,i want to write this first sheet along with other 3 sheets in other excel file without changing the format and formulae of the original file. So, as here we have 20 rows so,i want to create 20 such excel sheets and store these excel sheets in a folder name 'output'.

As, i have not handled task of this type in the past.Please Help me with the MATLAB code for this task.

Thank You in advance

[dpb]

Use readcell and writecell and the optional parameters available with them.

[Rohit P]

ok..will try it..thank you..