Performing multiple operations on multiple columns of data in Excel files

1 Ansicht (letzte 30 Tage)
Vijal Gala
Vijal Gala am 11 Aug. 2017
Bearbeitet: Vijal Gala am 11 Aug. 2017
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.

Antworten (0)

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!

Translated by