%% Modify Existing Cell Formatting
% Write a table to a spreadsheet file without preserving the cell formatting of the original file.
% The spreadsheet file student_grades.xlsx contains formatted cells. All the cells have borders and are color-filled, and the header cells have bold font.
%
% Create a table with text and numeric data.

Student = {'Mary';'John'};
Grade = [95;87];
t = table(Student,Grade)

% Update the existing spreadsheet file with the input data. Specify 'PreserverFormat' as false to ignore the existing formatting of the spreadsheet file. When you do this, student_grades.xlsx will be modified in the following way.
% writetable(t,'student_grades.xlsx',"PreserveFormat",false);
%
% If you specify 'PreserveFormat' as true instead of false when you write the data to the spreadsheet file, writetable will preserve the existing formatting of the spreadsheet.
% writetable(t,'student_grades.xlsx',"PreserveFormat",true);
%
% Copyright 2020 The MathWorks, Inc.
%