excelwrite too slow problem

2 次查看（过去 30 天）

Yu Li 2017-2-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/326944-excelwrite-too-slow-problem

编辑： Yu Li 2017-2-26

hi: in my code, I need to:

read huge amount of data.
find the data I need.
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