xlscell
版本 1.0.0.0 (2.7 KB) 作者:
Fahad Al Mahmood
Assigns a value or Excel formula to a specified cell in excel sheet.
xlscell(xcell,value)
xlscell(xcell,value,filename)
xlscell(xcell,value,filename,sheetname)
xcell: cell name (range) (ex. C3 or A2:F19)
value: value(s) to assign to specified cell.
filename: Name of excel file.
sheetname: sheet name.
Examples:
filename = 'file.xls';
value = {'N1','N2','N3','N4'};
xlscell('C4',value);
xlscell('C4',value,filename);
xlscell('C5',rand(10,4),filename);
xlscell('C5',rand(10,4),filename,'Sheet1');
引用格式
Fahad Al Mahmood (2024). xlscell (https://www.mathworks.com/matlabcentral/fileexchange/4548-xlscell), MATLAB Central File Exchange. 检索时间: .
MATLAB 版本兼容性
创建方式
R13
兼容任何版本
平台兼容性
Windows macOS Linux类别
- MATLAB > Data Import and Analysis > Data Import and Export > Standard File Formats > Spreadsheets >
- MATLAB > External Language Interfaces > COM with MATLAB > Use COM Objects in MATLAB >
在 Help Center 和 MATLAB 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 | More debugging documentation added |