Performing multiple operations on multiple columns of data in Excel files

1 回表示 (過去 30 日間)
Vijal Gala
Vijal Gala 2017 年 8 月 11 日
編集済み: Vijal Gala 2017 年 8 月 11 日
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 件)

カテゴリ

Help Center および File ExchangeMATLAB Functions in Microsoft Excel についてさらに検索

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by