Performing multiple operations on multiple columns of data in Excel files
1 view (last 30 days)
Show older comments
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 Comments
Answers (0)
See Also
Categories
Find more on MATLAB Functions in Microsoft Excel 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!