Occasional errors when linked to excel

2 visualizaciones (últimos 30 días)
Carl
Carl el 19 de Jun. de 2015
I have just got a new computer and I am getting errors with various excel commands from Matlab. Running the line from the command window after the crash then produces no errors. The errors are inconsistent for example my code is supposed to loop through about 15 times, the first time I tried running it I got error 1 on the 2nd loop, the second time it did not produce an error at this point but caused error 2 on the 6th loop. Any idea what could be causing this it ran fine on my old computer, my old computer has excel 2003 and 2007 (Matlab was linking to 2007) where my new computer has excel 2010 could that be the problem? If so how do I make my script compatible with excel 2010. 1.
Error using Interface.000208DA_0000_0000_C000_000000000046/SaveAs
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: SaveAs method of Workbook class failed
Help File: xlmain11.chm
Help Context ID: 0
Error in GetPlexosOutput_OCGT (line 3571)
ExcelWorkbook.SaveAs (mystackmodel);
2.
Error using xlsread (line 247)
Error registering event(s), Advise failed
Error in GetPlexosOutput_OCGT (line 66)
[~,year] = xlsread(myname);

Respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by