Using readtable with Word document and special formatting (superscripts)

Question

0 个投票

When reading a table from a Word document, readtable seems to treat superscript content in the same way as other content.

For example, if a row in a table contains

, readtable returns Lunar21, which is a problem. Superscripts are often used to point to footnotes. Is there an option for readtable to ignore superscript and other such characters, or any other workaround?

6 个评论
显示 4更早的评论隐藏 4更早的评论

AR 2024-3-7

在 MATLAB Online 中打开

If there isn't a way to do this with readtable, perhaps I can preprocess the table using actxserver? I am thinking copy-paste into Excel and invoke Excel with actxserver. There may be a way to identify formatting elements and remove them in the Excel file before using readtable.

My familiarity with actxserver properties & methods is minimal and I am having trouble doing this too. Something like this...

Excel = actxserver('Excel.Application');
w = Excel.Workbooks.Open(filename);
ExlSht = w.Sheets.Item('Sheet1');
RangeContainsTable = ExlSht.UsedRange;
r = RangeContainsTable.Rows.Count;
c = RangeContainsTable.Columns.Count;
for i = 1:r
    for j = 1:c
        % Something here to identify cells that have special
        % formatting/superscript & delete them?
        % Range.Value methods don't work as value already collapses special
        % formatting to normal text
        % I am not sure how to invoke (row,col) indexing into the above
        % range
        t = RangeContainsTable(i,j).Characters.Font.Superscript;
        % Above line doesn't work as RangeContainsTable is just a 1x1
        % object
    end
end

AR 2024-3-7

Temp_tableAttempt.zip

Thanks for the tip on attaching. Here's an example, although there are many more tables that are much larger and harder to work with.

AR 2024-3-8

Nevermind my original request. Although I still don't know how to directly remove special formatting while importing using readtable (if it's possible at all), I did manage to get the actxserver method working. Thanks.

请先登录，再进行评论。

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

Follow Question

Answer 1

Shlok 2024-10-16

在 MATLAB Online 中打开

0 个投票

Hi AR,

I understand that you are encountering issues while reading text with superscript characters using the “readtable” function. To address this issue, I would suggest utilizing an ActiveX session with Microsoft Word. This approach will allow you to remove any superscript characters before attempting to read the table. Refer the following steps to do so:

Using MATLAB, start an ActiveX session with Word and load the document.

wordApp = actxserver('Word.Application'); 
wordApp.Visible = true; % You can keep the Microsoft Word visible to debug in case of any errors 
doc = wordApp.Documents.Open('path_to_Temp_tableAttempt.docx'); 

Now loop through the tables and, within each cell, iterate through each character to check for superscripts. If a superscript character is encountered, delete it:

for i = 1:doc.Tables.Count  
    table = doc.Tables.Item(i);  
    for row = 1:table.Rows.Count  
        for col = 1:table.Columns.Count  
            try  
                cell = table.Cell(row, col);  
                cellRange = cell.Range;  
                % Loop through each character in the cell  
                for charIndex = cellRange.Characters.Count:-1:1  
                    char = cellRange.Characters.Item(charIndex);  
                    % Check if the character is superscript  
                    if char.Font.Superscript  
                        % Remove the superscript character  
                        char.Delete();  
                    end  
                end  
            % To handle merged columns  
            catch ME  
                disp(['Error processing cell at row ' num2str(row) ', column ' num2str(col) ': ' ME.message]);  
            end  
        end  
    end  
end  

Then save this updated file and close the ActiveX session.

doc.SaveAs2('path_to_updated_Temp_tableAttempt.docx '); 
doc.Close(); 
wordApp.Quit(); 

By following these steps, you will be able to create an updated document free of superscript characters, making it easier to read the table using the “readtable” function.

To know more about “actxserver” function you can refer to the following MATLAB documentation link:

https://www.mathworks.com/help/releases/R2023b/matlab/ref/actxserver.html

Hope this helps.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2024-10-18

Possibly calling methods might help.

AR 2024-10-18

Thank you. I will try this out.

请先登录，再进行评论。

Using readtable with Word document and special formatting (superscripts)

6 个评论
显示 4更早的评论隐藏 4更早的评论

采纳的回答

3 个评论
显示 1更早的评论隐藏 1更早的评论

更多回答（0 个）

类别

产品

版本

标签

Community Treasure Hunt

Using readtable with Word document and special formatting (superscripts)

6 个评论 显示 4更早的评论 隐藏 4更早的评论

采纳的回答

3 个评论 显示 1更早的评论 隐藏 1更早的评论

更多回答（0 个）

类别

产品

版本

标签

另请参阅

Community Treasure Hunt

6 个评论
显示 4更早的评论隐藏 4更早的评论

3 个评论
显示 1更早的评论隐藏 1更早的评论