MATLAB: Is there any way to change the appearance of the output excel file as shown in the picture(only some is visible of heading as in Capture2.jpg wanted as Capture1.jpg)?? and can the heading be highlighted by any means in excel sheet ?

excelxlswrite

n=1;
ch={'Borehole No';'Water table Depth'};
col_header={'Depth','UnCorrected N value','Saturated Density','Relative Density','Fine Content','VS(m/s)'};
filename='i.xlsx';
for j=1:n
    sheet=j
    xlswrite('i.xlsx',ch,sheet);
      range='B1'; 
      xlswrite('i.xlsx',n,sheet,range);
range='A3:F3'; 
xlswrite('i.xlsx',col_header,sheet,range);
end

Best Answer

This is a problem of the display in Excel, not a Matlab problem.
What about: Ctrl-A and double click on one of the line margins between the columns in the heading line? Alternatively: Ctrl-A, Alt-H, O, I (in my German Excel 2010 it is Alt-R instead of Alt-H).
See e.g. https://www.ablebits.com/office-addins-blog/2017/03/16/autofit-excel-columns-rows/
Related Question