Matlab export to excel borders format

조회 수: 16 (최근 30일)
hock yam ooi
hock yam ooi 2020년 5월 8일
답변: BhaTTa 2024년 11월 29일
Hi,
I try to export some data matlab to excel.
Needed some borders on specific range but fail with the coding below.
Here's my code:
Please help!
AppObj = actxserver('Excel.Application');
AppObj.Visible = true;
WkbkObj = AppObj.Workbooks.Open('Excel File.xlsx');%Please input your file.
WkbkObj.Range('B2:B4').Borders.Item('xlEdgeLeft').LineStyle = 1;
WkbkObj.Range('B2:B4').Borders.Item('xlEdgeLeft').Weight = -4138;

답변 (1개)

BhaTTa
BhaTTa 2024년 11월 29일

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by