Simple Excel sheet editing program

Simple Excel sheet editing program
988 Downloads
Updated 28 Dec 2009

View License

With this program you can edit simple things in an Excel sheet like:
Bold, Fontsize, border, font

Write in command prompt
>> params.Bold = 1;params.FontName = 'Arial';params.FontSize = 10;params.ColorIndex = 56;params.NumberFormat = 4;params.Int_ColorIndex = 0;params.Border = 1;params.BorderWeight = 1;xlcontrol('A1:D1',params,'c:\temp\test.xls','November')

Or paste the code into a script, tryout what happens when you change the params fields. See 'help xlcontrol' for options

The excelfile must exist or be created beforehand

Cite As

Peter Lindberg (2024). Simple Excel sheet editing program (https://www.mathworks.com/matlabcentral/fileexchange/26209-simple-excel-sheet-editing-program), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2008b
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!
Version Published Release Notes
1.0.0.0