How to read number of excel books one at a time??

I have 150 numbers of excel workbooks with each book contains accelerations obtain from 6 sensors of a building. (8192 x 6). I want to do Fast Fourier Transformation for columns 5 and 6 for each file and write the outcome data to a separate excel data sheet(all outcomes into a one sheet in different columns). How can I perform this repetition? I know how to do the FFT for one file at a time but don't know how to use for loop for this kind of repetition as I am very new to MATLAB. Please help me..!!!

Thank You

Answer 1

[Image Analyst]

You should use ActiveX (demo attached), and the FAQ.

[Image Analyst]

Tharindu's "Answer" moved here:

Hi Many thanks for your prompt answer. I will give it a try. Thanks again.........!!!

[Tharindu]

Hi many thanks for the help. I sorted out the problem. Your guidance helped a lot.

Thanks again

Answer 2

[William]

You’d like to compare two Excel worksheets and need to open and see them side by side. However simple it may seem, each time they appear in the same window. That’s frustrating! So we will show you how to view two Excel files (.xls or .xlsx) side by side in this step by step tip. You may want to choose one of the following options:

Open and view two workbooks/worksheets side by side in the same window: see two different workbooks at the same time view two different spreadsheets of the same Excel book at once Or you may want to see two or more workbooks in several windows.