I am designing an app which read and/or update an excel file.
When I use the function readtable to import an Excel file, I can not control the format of the variables inside the table.
Indeed, my code to import the table is:
T = readtable("example.xls", "TextType","string")
Also, I use the function writematrix to update the same excel file:
writematrix(var, "example.xls", "Range","C6")
var is string or double types, however, the table shows sometimes string or double type, whereas there should be only string type
I also use actxserver to insert new lines in the excel file, and then fill the new lines with writematrix
e = actxserver('Excel.Application');
rg = ws.Range(ILine);
I suspect actxserver or writematrix to be the cause of changing the format of the variables via readtable but I am not sure despite my investigations.
Thanks for your help