- How many workbooks do you have? (1 or 10 or some other number) A workbook is an Excel file that may have one or more "worksheets" inside it.
- How many worksheets are inside each workbook?
- What are the workbook name(s)?
- What are the worksheet name(s)?
- Do the data from the 10 documents go onto one worksheet each, one workbook each, or all 10 are on one worksheet in one workbook?
- Do you want to change the name of the workbook file , or of the worksheet(s) inside the workbook?
- What is "base coding" and why can't you change it? (If it's an m-file you should be able to change it to do what you want, right?)
renaming a single excel sheet using multiple names in the same directory
1 view (last 30 days)
Show older comments
1 processed 10 documents and created a excel file to store the values but, i get only the values of 10th document in the excel sheet, hence i moved the excel sheet of first document before writing the values of 2nd. now i have to rename the 1st excel file so that the 2nd excel which is generated during process should not overwrite the 1st one while moving it to the same folder.. can anyone help me in this.
the values of all the documents are required, i cannot change my base coding so need a coding to rename the excel files. the names should be changed from 1 to 10 dynamically
5 Comments
Answers (0)
See Also
Categories
Find more on Use COM Objects in MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!