- 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 visualización (últimos 30 días)
Mostrar comentarios más antiguos
RAMESH MUNIRATHINAM
el 20 de Nov. de 2014
Comentada: RAMESH MUNIRATHINAM
el 20 de Nov. de 2014
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 comentarios
Respuestas (0)
Ver también
Categorías
Más información sobre Use COM Objects in MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!