Help with function reading a file

1 view (last 30 days)
Dylan Blosser
Dylan Blosser on 9 Dec 2019
Commented: Deepak Kumar on 3 Jan 2020
I want to query the user for what file they want to submit. Then I want the code to read the lines from AN18:AN11228 and K18:K11228 from the file that they enter then find the average of whatever numbers are within that criteria.
Here is what I have so far:
function [AGS,ALA]=BlosserD_Data20(File)
inputAGS=xlsread(File,'AN18:AN11228');
inputALA=xlsread(File,'K18:K11228');
AGS=mean(inputAGS);
ALA=mean(inputALA);
end
File=input('Enter file name: ')
[AGS,ALA] = BlosserD_Data20(File)

Answers (0)

Categories

Find more on Data Import and Analysis in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!