Read the last row of excel spreadsheet using actxserver

5 ビュー (過去 30 日間)
Ilias Minas
Ilias Minas 2022 年 9 月 22 日
回答済み: Fangjun Jiang 2022 年 9 月 22 日
Hi all,
I have the following issue.
I use actxserver in order to link an Excel spreadsheet with Matlab and create graphs automatically. Below is the script that i am using
%% Link to Excel spreadsheet
% Start Excel and open Workbook
excel = actxserver('Excel.Application');
wb = excel.Workbooks.Open('C:\Users\ilimin\Desktop\test2.xlsx'); % Copy in the '' the location of the spreadsheet
% Makes the created sheet visible
excel.Visible = true;
%% Speed Graph
% Creates a blank chart in another Sheet
chart1 = wb.Charts.Add;
% Set the range of the data and the source ('Name of the Sheet')
chart1.SetSourceData(wb.Worksheets.Item('Sheet1').Range('$A$2:$A$112, $O$2:$O$112298'));
So far it works great but I would like to ask if there is any way of detecting the last row of the Excel spreadsheet without do it manually, and after this use it in the last command (char1.SetSourceData).
Thank you very much
Ilias
  1 件のコメント
dpb
dpb 2022 年 9 月 22 日
<FindLastRow> is a tutorial on about all ways -- the MS VBA doc link is <MS Excel VBA Doc>

サインインしてコメントする。

回答 (1 件)

Fangjun Jiang
Fangjun Jiang 2022 年 9 月 22 日
I hope this debug message gives you a clue.
K>> Workbook.Sheets.Item(1).UsedRange.Address
ans =
'$A$1:$AY$83'

カテゴリ

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