Rank: 633 based on 127 downloads (last 30 days) and 1 file submitted
photo

Matt Swartz

E-mail

Personal Profile:
Professional Interests:

 

Watch this Author's files

 

Files Posted by Matt
Updated   File Tags Downloads
(last 30 days)
Comments Rating
21 Mar 2006 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz xlswrite increased sp..., data export, data import 127 38
  • 4.83871
4.8 | 31 ratings
Comments and Ratings on Matt's Files View all
Updated File Comment by Comments Rating
17 Apr 2013 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz Leo

Thank you

22 Mar 2013 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz Richa

Including the entire path in the file name fixed my error.

22 Mar 2013 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz Richa

I am still getting the error:

Error using
Interface.000208DB_0000_0000_C000_000000000046/Open
Invoke Error, Dispatch Exception:
Source: Microsoft Office Excel
Description: 'Desktop\filename.xlsx'
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: C:\Program Files (x86)\Microsoft
Office\Office12\1033\XLMAIN11.CHM
Help Context ID: 0

I changed line 2 from 'base' to 'caller' but it did not help. Has anyone found a solution to this?

21 Jul 2012 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz s.pillai, sumith

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.

19 Jun 2012 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz Sam

ERROR:

I have run the file with the following exaclty as descripted by the author, but it does not work (Excel 2007, Matlab 7.4.0):
--------------------------

Excel = actxserver ('Excel.Application');
File='junk.xlsx';
if ~exist(File,'file')
ExcelWorkbook = Excel.workbooks.Add;
ExcelWorkbook.SaveAs(File,1);
ExcelWorkbook.Close(false);
end
invoke(Excel.Workbooks,'Open',File);

xlswrite1(File,[1 2 3])

invoke(Excel.ActiveWorkbook,'Save');
Excel.Quit
Excel.delete
clear Excel

---

error:

??? Invoke Error, Dispatch Exception:
Source: Microsoft Office Excel
Description: Excel cannot open the file 'junk.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
Help File: C:\Program Files\Microsoft Office\Office12\1033\XLMAIN11.CHM
Help Context ID: 0

Error in ==> test_xlswrite1 at 8
invoke(Excel.Workbooks,'Open',File);
invoke(Excel.ActiveWorkbook,'Save');
Excel.Quit
Excel.delete
clear Excel

Top Tags Applied by Matt
data export, data import, xlswrite increased speed
Files Tagged by Matt
Updated   File Tags Downloads
(last 30 days)
Comments Rating
21 Mar 2006 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz xlswrite increased sp..., data export, data import 127 38
  • 4.83871
4.8 | 31 ratings

Contact us