Matlab export to excel borders format

7 ビュー (過去 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 Center および File ExchangeSpreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by