Simple Excel sheet editing program

Version 1.0.0.0 (2.12 KB) by Peter Lindberg
Simple Excel sheet editing program
0.0
(0)
989 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 (2026). 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
Tags Add Tags
Open in new tab
Version Published Release Notes
1.0.0.0