Question: You are to write three separate functions to modularise the process of reading any data from an excel spreadsheet into a nested structure array. The
You are to write three separate functions to modularise the process of reading any data from an excel
spreadsheet into a nested structure array. The main function MUST call GetFileName and GetData in its
execution. The functions, inputs and outputs are defined as follows.
Subfunction : GetFileName
This function retrieves the file names of a single excel file that contains the KeyWord, from your current
working directory. For example the KeyWord may be Drone
FileName GetFileName KeyWord
The function uses as input:
KeyWord, which is the file name prefix that will be used to distinguish the relevant file that you
should use from the other files in your working directory.
The function must produce as output:
FileName, a times cell array containing the full file name of the file that contains your desired
prefix and extension.
Please note, the KeyWord may change. Hardcoding will be penalised.
You may use the prefix xlsx to indicate that all data files that are Microsoft Excel Open XML Spreadsheets.
The data files follow rigid file type, file name and variable labelling conventions. The file structure and
labelling conventions are as follows:
The excel file contains only one worksheet, the worksheet, SheetName will always have a unique name where:
aSheetName is a worksheet that contains the multiple columns of data. Note: The number of
columns occupied with data may vary.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
