I am trying to figure out how to use writetable instead of xlswrite, but the feature is converting my numbers to text. Headers are text.
Original Code that works fine
Excel_Sheet = [Excel_head; Excel_out];
xlswrite(‘C:D_LocalMATLABAAAAPhaseII_CA_out.xlsx’,Excel_sheet);
Where Excel_head is a text array and Excel_out is a numberical matrix of values.
New Code that converts the numbers to text
Excel_sheet = table([Excel_head; Excel_out]);
writetable(Excel_sheet,’C:D_LocalMATLABAAAPhaseII_CA_out.xlsx’);
why does it convert? There must be a way of making the table with numbers?
Best regards,
FarleyOriginal Code that works fine
Excel_Sheet = [Excel_head; Excel_out];
xlswrite(‘C:D_LocalMATLABAAAAPhaseII_CA_out.xlsx’,Excel_sheet);
Where Excel_head is a text array and Excel_out is a numberical matrix of values.
New Code that converts the numbers to text
Excel_sheet = table([Excel_head; Excel_out]);
writetable(Excel_sheet,’C:D_LocalMATLABAAAPhaseII_CA_out.xlsx’);
why does it convert? There must be a way of making the table with numbers?
Best regards,
Farley Original Code that works fine
Excel_Sheet = [Excel_head; Excel_out];
xlswrite(‘C:D_LocalMATLABAAAAPhaseII_CA_out.xlsx’,Excel_sheet);
Where Excel_head is a text array and Excel_out is a numberical matrix of values.
New Code that converts the numbers to text
Excel_sheet = table([Excel_head; Excel_out]);
writetable(Excel_sheet,’C:D_LocalMATLABAAAPhaseII_CA_out.xlsx’);
why does it convert? There must be a way of making the table with numbers?
Best regards,
Farley excel, spreadsheet, xlswrite, writetable, converts to text MATLAB Answers — New Questions
