Excel file reading and writing in MATLAB - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ Predict Output

intermediate

What is the output of this MATLAB code reading an Excel file?

Consider the following MATLAB code that reads data from an Excel file named 'data.xlsx'. What will be the value of variable data after running this code?

MATLAB

data = readtable('data.xlsx');
disp(data(1, :));

A Displays the first row of the Excel file as a table with column headers

B Throws an error because 'readtable' cannot read Excel files

C Displays the entire Excel file content as a numeric matrix

D Displays only the first cell value of the Excel file

💡 Hint

The function readtable reads Excel files into a table with headers.

The readtable function reads the Excel file into a table preserving headers. Displaying data(1, :) shows the first row with all columns as a table.

❓ Predict Output

intermediate

What does this MATLAB code write to an Excel file?

Given the MATLAB code below, what will be the content of the Excel file 'output.xlsx' after execution?

MATLAB

T = table([1;2;3], {'A';'B';'C'}, 'VariableNames', {'Numbers', 'Letters'});
writecell({'Header1', 'Header2'; 10, 20}, 'output.xlsx');
writetable(T, 'output.xlsx', 'Sheet', 1, 'WriteMode', 'append');

A The Excel file will have one sheet with the cell array overwritten by the table

B The Excel file will have one sheet with the cell array in the first two rows and the table appended below

C The code will cause an error because 'WriteMode' is not a valid option

D The Excel file will have two sheets: first with the cell array and second with the table

💡 Hint

The 'WriteMode' option 'append' adds data below existing content in the same sheet.

First, writecell writes a 2x2 cell array to 'output.xlsx'. Then writetable appends the table below the existing data in the same sheet because of 'WriteMode', so both appear in one sheet.

🔧 Debug

advanced

Why does this MATLAB code fail to read the Excel file?

This MATLAB code attempts to read an Excel file but throws an error. What is the cause?

MATLAB

data = xlsread('missingfile.xlsx');

A The file 'missingfile.xlsx' does not exist in the current folder or path

B The file is open in another program, causing a permission error

C The code is missing a sheet name argument

D The function 'xlsread' is deprecated and cannot read Excel files

💡 Hint

Check if the file exists in the folder where MATLAB is running.

The error occurs because the file 'missingfile.xlsx' is not found in the current folder or MATLAB path. The function xlsread requires the file to exist and be accessible.

📝 Syntax

advanced

Which option correctly writes a MATLAB table to an Excel file with a custom sheet name?

Select the MATLAB code snippet that correctly writes the table T to an Excel file named 'results.xlsx' on a sheet called 'Summary'.

MATLAB

T = table([10;20], {'X';'Y'}, 'VariableNames', {'Value', 'Category'});

A writetable('results.xlsx', T, 'Sheet', 'Summary');

B writetable(T, 'results.xlsx', 'SheetName', 'Summary');

C writetable(T, 'results.xlsx', 'Sheet', 'Summary');

D writetable(T, 'results.xlsx', 'Sheet', 1, 'SheetName', 'Summary');

💡 Hint

The correct option uses the 'Sheet' name-value pair to specify the sheet.

The writetable function uses the 'Sheet' parameter to specify the sheet name. Option C correctly uses 'Sheet', 'Summary'. Option C uses a non-existent parameter 'SheetName'. Option C has wrong argument order. Option C mixes numeric and name parameters incorrectly.

🚀 Application

expert

How many rows will the variable data contain after this code runs?

This MATLAB code reads data from an Excel file 'sales.xlsx' that has 100 rows and 5 columns. The code filters rows where the 'Amount' column is greater than 500. How many rows will data contain?

MATLAB

T = readtable('sales.xlsx');
data = T(T.Amount > 500, :);

A 5 rows, equal to the number of columns in the file

B 0 rows, because the condition is invalid

C 100 rows, same as the original file

D The number of rows in <code>data</code> equals the count of rows in 'sales.xlsx' where 'Amount' > 500

💡 Hint

The code filters rows based on the 'Amount' column values.

The code reads the entire table, then selects only rows where the 'Amount' column value is greater than 500. The number of rows in data depends on how many rows satisfy this condition in the Excel file.