EXcl files

1 次查看（过去 30 天）
Natan Katz
Natan Katz 2011-8-1
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

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

回答（1 个）

Oleg Komarov
Oleg Komarov 2011-8-1
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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by