excelwrite too slow problem
조회 수: 2 (최근 30일)
이전 댓글 표시
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:
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
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!