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.
Sub-function 1: 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:
1. 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:
1. FileName, a 1\times 1 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:
a.SheetName 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!