xlswritespec

Allows you to format your output when you export to Excel.
5.1K 次下载
更新时间 2005/8/23

无许可证

The script performs the same function as xlswrite with the added functionality of formatting the data at the particular location written into, so for example if you want to write headers in blue and numbers in gold, you can do this. The example below illustrates how you can write 400 random numbers into a file using the modified script and the original script from MATLAB 7.0, I hope the formatted one looks cleaner to you

Data = rand(20,20)
params.Bold = 'false';
params.FontSize = 10;
params.FontName = 'Verdana';
params.ColorIndex = 14;
params.NumberFormat = '0.000';
xlswritespec('Exemplar.xls',Data,'Example',['B2'],params)
xlswrite('Exemplar.xls',Data,'Example',['B26'])

Hope the script is useful, I am not responsible for any hair loss, money, gray hair or other good / bad things which happen. The script is extremely useful for me and I thought I should try to share it. Oh I would like to acknowledge xlswrite for the basic structure, I just hacked in a few more lines, I cannot be bothered looking up the file ID.

引用格式

Chandramouli Chandrasekaran (2024). xlswritespec (https://www.mathworks.com/matlabcentral/fileexchange/8345-xlswritespec), MATLAB Central File Exchange. 检索来源 .

MATLAB 版本兼容性
创建方式 R14SP1
兼容任何版本
平台兼容性
Windows macOS Linux
类别
Help CenterMATLAB Answers 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
版本 已发布 发行说明
1.0.0.0