Check if XLS file is open and close it

版本 1.1.0.0 (2.2 KB) 作者: Guilherme Coco Beltramini
Determine if Excel file is open. If it is open in MS Excel, it can be closed.
4.3
(12)
1.9K 次下载
更新时间 2013/6/3

查看许可证

Determine if Excel file is open. If it is open in MS Excel, it can be closed.

USAGE
isopen = xls_check_if_open(xlsfile)
isopen = xls_check_if_open(xlsfile,action)

INPUT
- XLSFILE: name of the Excel file
- ACTION: 'close' (closes file if it is open) or '' (do nothing). Option 'close' only works with MS Excel.

OUTPUT
- ISOPEN:
1 if XLSFILE is open
0 if XLSFILE is not open
10 if XLSFILE was closed
11 if XLSFILE is open and could not be closed
-1 if an error occurred

引用格式

Guilherme Coco Beltramini (2024). Check if XLS file is open and close it (https://www.mathworks.com/matlabcentral/fileexchange/41878-check-if-xls-file-is-open-and-close-it), MATLAB Central File Exchange. 检索时间: .

MATLAB 版本兼容性
创建方式 R2010a
兼容任何版本
平台兼容性
Windows macOS Linux
类别
在 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.1.0.0

Changed input and output, and screenshot
1.0.0.0