Performing multiple operations on multiple columns of data in Excel files
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Hello everyone,
I have 750 excel files. I have combined sets of 50 excel workbooks into one excel file. Now I have 150 excel files. I want to do the following. 1. Delete first 2 rows of each worksheet. 2. Perform operations on columns of each worksheet to get new columnns. Operations are simple like multiplication, division, finding slope, average. 3. Now I want to combine 50 worksheets in each file on which i performed the above operations into one worksheet to make graphs. I am familiar with basic Matlab as I have already written functions to make 3d surface graphs, also calculations with ARAMIS. I would really appriciate if I could get some tips that would help me a lot.
Thank You.
0 Kommentare
Antworten (0)
Siehe auch
Kategorien
Mehr zu MATLAB Functions in Microsoft Excel finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!