Check if XLS file is open and close it

Version 1.1.0.0 (2.22 KB) by 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 Downloads
Updated 3 Jun 2013

View License

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

Cite As

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. Retrieved .

MATLAB Release Compatibility
Created with R2010a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags

Community Treasure Hunt

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

Start Hunting!

Version Published Release Notes
1.1.0.0

Changed input and output, and screenshot
1.0.0.0