Performing multiple operations on multiple columns of data in Excel files
1 回表示 (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で MATLAB Functions in Microsoft Excel についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!