MATLAB: How to read the table from MS word to xls sheet

read data

hi,

i want to read the content of table from the MS word file(.rtf) format, then write the content to xls sheet.

Thanks in advance

by Suresh.S

Best Answer

The question is not clear. You can open an RTF file in word, but it is not trivial to address a specific table in a large text. If it is one table on a single page, it should be easier to use ActiveX, when you are working under Windows and have Word installed.

Actually moving a table from Word to Excel should be much easier using copy&paste than with Matlab. So what is the actual problem?

Related Solutions

MATLAB: How to add a Header or a Footer to an EXCEL worksheet using MATLAB 7.7 (R2008b)

The ability to programmatically add the Header and Footer to an Excel worksheet can be implemented in MATLAB using the COM interface.

The ACTXSERVER command can be used to create a COM server running Microsoft Excel. You can then add the Header and Footer using the different methods for the workbook and then call XLSWRITE to write the data to the Excel worksheet as follows:

a = actxserver('Excel.Application');
a.Visible =1;
a.Workbooks.Add;
a.activeWorkbook.activesheet.PageSetup.LeftFooter = 'MyFooter';
a.activeWorkbook.activesheet.PageSetup.LeftHeader = 'MyHeader';
a.activeWorkbook.SaveAs('test.xlsx');
a.activeWorkbook.Close;
xlswrite('test.xlsx',[1 2 3]);

The following options can also be modified in a similar way:

a.activeWorkbook.activeWorksheet.PageSetup.CenterHeader 
a.activeWorkbook.activeWorksheet.PageSetup.RightHeader 
a.activeWorkbook.activeWorksheet.PageSetup.CenterFooter 
a.activeWorkbook.activeWorksheet.PageSetup.RightFooter

MATLAB: Copy XLS Sheet

Yes, I'm sure it can be done with ActiveX. Look at my ExcelDemo: http://www.mathworks.com/matlabcentral/answers/18306-how-to-import-data-to-excel-through-matlab It shows you how to use ActiveX. I'm not exactly sure how to copy a sheet, but with my example of other Excel commands, and you looking up the proper method on the Microsoft Office Developer's web site (which you can do just as well as I can), you can do it. The Excel 2007 developer's web site is http://msdn.microsoft.com/en-us/library/bb242656%28office.12%29.aspx Look through that and eventually you'll find either the command to duplicate a sheet, or else you can just select a range (which my demo shows you how to do), and copy the data, then add new worksheet (again, in my demo), paste, and save the workbook (again, in my demo). Good luck.

Best Answer

Related Solutions

MATLAB: How to add a Header or a Footer to an EXCEL worksheet using MATLAB 7.7 (R2008b)

MATLAB: Copy XLS Sheet

Related Question