Matlab export to excel borders format

2020 5 8
1 个回答
更新时间：2024 11 29
5 次查看（30 天）

0 个投票

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;

请先登录，再回答此问题。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

回答：

BhaTTa
BhaTTa
2024-11-29

Community Treasure Hunt

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

Start Hunting!

Translated by