Performing multiple operations on multiple columns of data in Excel files
조회 수: 2 (최근 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에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!