word automation - adding / editing tables from matlab

2 次查看(过去 30 天)
Hi, I'm adding word tables using
MATLAB CODE
newtable = tableRange.ConvertToTable();
After this if I type
MATLAB CODE
newtable.Columns.Count
I get the correct answer, 22. BUT if I try and seelct a column via, say,
MATLAB CODE
newtable.Columns(1).Select();
the whole table is selected (!). Then, if I do
MATLAB CODE
col = newtable.Columns(1)
col has a type "columns" as if the index does not work and
MATLAB CODE
col = newtable.Columns(1).Count
agian returns 22.
Interestingly
MATLAB CODE
newtable.Columns(2).Select
Returns "Index exceeds matrix dimensions.".
It's almost like the index (1) etc is being ignores.
Can anyone help me on this please - for the best performance I really need to be able to quickly select entire columns without using MoveDown etc.
Tom

采纳的回答

Eric
Eric 2012-3-8
I believe Columns is a Collection and that you need to do the following to access individual columns:
newtable.Columns.Item(1)
newtable.Columns.Item(2)
I believe Microsoft's COM interfaces do not support indexing into Collections directly with integers or strings the way VBA does.
Good luck, Eric

更多回答(1 个)

Sean de Wolski
Sean de Wolski 2012-3-8
How big is newtable.Columns?
newtable.Columns
  1 个评论
tombola
tombola 2012-3-8
newtable.Columns
ans =
Interface.Microsoft_Word_12.0_Object_Library.Columns
newtable.Columns.Count
ans =
22
newtable.Columns(1)
ans =
Interface.Microsoft_Word_12.0_Object_Library.Columns
newtable.Columns(1).Count
ans =
22

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Language Support 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by