excelwrite too slow problem

조회 수: 2 (최근 30일)
Yu Li
Yu Li 2017년 2월 26일
편집: Yu Li 2017년 2월 26일
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개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by