EXcl files

Hello

1 Assuming that I work with Excel spreadsheet with several sheets. Can I read and write them once and avoid using xlsread and xlswrite several times?

2. If I use these functions and I wish to read information in one file and write it in another in which the sheets have similar names. What is the optimal way to do so e.g. I have file A file B

there are 6 sheets in A with the names mm,nn,010,pp33,qq,rr and similarly file B has 6 sheets with the same names, I can do loop using the indices of xlsfinfo but is there afaster way?

Thank

Natan Katz

Answer 1

[Oleg Komarov]

One way would be to work directly with with ActiveX, an example http://www.mathworks.com/support/solutions/en/data/1-17PWC/?solution=1-17PWC.

You will avoid the opening closing of the excel server at each call of xlsread/xlswrite.

Another would be to use some FEX submissions (modifications of the original functions) that don't open/close the connection themselves, making the task faster: xlsread.m for faster data transfer