excelwrite too slow problem
4 views (last 30 days)
Show older comments
hi: in my code, I need to:
1. read huge amount of data.
2. find the data I need.
3. export to the excel.
so I write a loop:
for: time step
read data.
find data I need.
export to excel.
end for
however I found that the excel exporting time is too slow. so I refine the code like this:
for: time step
read data.
find data I need.
export to excel.
system('tskill excel')
end for
after add the command: system('tskill excel'), the exporting become much faster, and below is the bench mark:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/161091/image.jpeg)
however I could not open any excel file while running the code.
so my question is:
1. why this could happen? I think the xlswrite will close the excel everytime the writting is end.
2. is there any way to solve this problem?
thanks! Li
0 Comments
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!