Rank: 324164 based on 0 downloads (last 30 days) and 0 file submitted
photo

sumith s.pillai

E-mail
Company/University
cusat

Personal Profile:

student


 

Watch this Author's files

 

Comments and Ratings by sumith s.pillai
Updated File Comments Rating
21 Jul 2012 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz

Hi

I am a beginner in Matlab. I am using xlswrite function. But it takes lots of time. I saw your solution. I downloaded xlswrite1. I changed my program as you said. But it showing an error,
I run the following code
Excel = actxserver ('Excel. Application');
File=Site_File;
if ~exist(File,'file')
ExcelWorkbook = Excel.workbooks.Add;
ExcelWorkbook.SaveAs(File,1);
ExcelWorkbook.Close(false);
end
invoke(Excel.Workbooks,'Open',File);
status=xlswrite1(Site_File, Output, Range);
nvoke(Excel.ActiveWorkbook,'Save');
Excel.Quit
Excel.delete
clear Excel

%where site_file is the output file.

??? Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: 'CEll.xls' could not be found. Check the spelling of the file
name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files, make
sure that the file has not been renamed, moved, or deleted.
Help File: xlmain11.chm
Help Context ID: 0

Error in ==> KL_Database_Process_Shared_RTT_Operator>CopyData at 675
invoke(Excel.Workbooks,'Open',File);

Error in ==> KL_Database_Process_Shared_RTT_Operator>Generate_Report_7 at 489
CopyData(Site_File,'F51:H79',Operator1,'1',n);

Error in ==> KL_Database_Process_Shared_RTT_Operator at 125
[b,Site_File]=Generate_Report_7(n,Set_Date);

I followed your steps and don’t know how to solve this problem.

Please help me.

Contact us