MATLAB: Word automation – adding / editing tables from matlab

beer

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

Best Answer

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

Related Solutions

MATLAB: Table: Overwrite column value with condition

This might work:

myTable.a(myTable.a < 3) = 0;

MATLAB: Reading tables from .doc word file

Here's some starter code for you. Be aware that this code assumes that, if there are multiple tables, they are all the same size.

%% open the doc
word = actxserver('Word.Application');
% Open/Select Word file
[filename_in, pathname] = uigetfile({'*.doc;*.docx;*.docm','Word Files (*.doc,*.docx,*.docm)'; ...
    '*.*', 'All Files (*.*)'}, 'Select a file');
document = word.documents.Open(fullfile(pathname,filename_in));
r=0;
tbl_cnt = document.Tables.Count;
% Loop through each table in the document
for tbl = 1 : tbl_cnt
    row_cnt = document.Tables.Item(tbl).Rows.Count;
    col_cnt = document.Tables.Item(tbl).Columns.Count;
    
    for row = 1 : row_cnt
        r = r+1;
        for col = 1 : col_cnt
        % Pull the values from the table
        cell_txt = strtrim(document.Tables.Item(tbl).Cell(row, col).Range.Text);
        % Add each value to its own cell        
        tblVals{r,col} = cell_txt;
        end
    end
end
% Close the document.
document.Close;
% Close Word.
word.Quit;
% delete server object
delete(word);
clear word document

Best Answer

Related Solutions

MATLAB: Table: Overwrite column value with condition

MATLAB: Reading tables from .doc word file

Related Question