xlwrite : Export Data to Excel from Matlab on Mac/Win

버전 1.2.0.0 (665 KB) 작성자: Marin Deresco
xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win)
다운로드 수: 8.7K
업데이트 날짜: 2012/8/3

라이선스 보기

The function xlwrite has similar syntax and inputs as MatLAB's xlswrite.
It also can write 3-d arrays (xlswrite can't), of cell and double type. To simplify the idea : we forward Matlab data to be exported to a Java function which in turn writes the data to excel.

Note that data to be exported is converted to cell then to java String array.

This workaround is a real working solution, it may need further refinements :
- manage Java heap space, as Java heap memory saturates for large arrays exported many times.
- format dates and strings, as all numbers appear as text in Excel.

Matlab's decimal separator is '.' : in order to be able to work with exported data, users of this solution will have to change Mac preferences regarding the decimal separator (should be ".").
To do so you need to go to System Preferences > International > Formats and click on Customize button in number zone, then type '.' in the field required.
This solution works under Windows.

Test_xlwrite.m contains an example.

인용 양식

Marin Deresco (2025). xlwrite : Export Data to Excel from Matlab on Mac/Win (https://kr.mathworks.com/matlabcentral/fileexchange/37560-xlwrite-export-data-to-excel-from-matlab-on-mac-win), MATLAB Central File Exchange. 검색 날짜: .

MATLAB 릴리스 호환 정보
개발 환경: R2010a
모든 릴리스와 호환
플랫폼 호환성
Windows macOS Linux
카테고리
Help CenterMATLAB Answers에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!
버전 게시됨 릴리스 정보
1.2.0.0

According to a user remark, I've updated the description of xlwrite : I've replaced 'same syntax' into 'similar syntax'.

1.1.0.0

updated the summary

1.0.0.0