Rank: 688 based on 173 downloads (last 30 days) and 3 files submitted
photo

Antonio

E-mail

Personal Profile:
Professional Interests:

 

Watch this Author's files

 

Files Posted by Antonio View all
Updated   File Tags Downloads
(last 30 days)
Comments Rating
18 Dec 2013 Mixture property calculations using PR, RK and SRK EoS. The file prsrk.m calculates major thermodynamic properties using any of PR, RK or SRK EoS. Author: Antonio thermodynamic calcula..., eos, distillation 26 5
28 Mar 2012 Function for faster data transfer Matlab <--> Excel This modified version makes the original xlsread.m faster and also allows add-ins to be loaded. Author: Antonio data export, data import, faster xlsread, active x, addin, excel 106 27
  • 4.86667
4.9 | 17 ratings
24 Apr 2009 Mixture property calculations using Peng-Robinson EoS Mixture property calculations using Peng-Robinson EoS. Author: Antonio thermodynamic propert..., peng robinson, equation of state, mixture 41 2
  • 5.0
5.0 | 2 ratings
Comments and Ratings by Antonio View all
Updated File Comments Rating
21 Oct 2013 Function for faster data transfer Matlab <--> Excel This modified version makes the original xlsread.m faster and also allows add-ins to be loaded. Author: Antonio

Hugh, I tried to reproduce the error your reported but got no RPC server unavailability. I'm using Excel 2007 and Matlab R2013a...

02 Sep 2013 Function for faster data transfer Matlab <--> Excel This modified version makes the original xlsread.m faster and also allows add-ins to be loaded. Author: Antonio

Fontys, maybe you could add the file to the Matlab path.

15 May 2013 Mixture property calculations using PR, RK and SRK EoS. The file prsrk.m calculates major thermodynamic properties using any of PR, RK or SRK EoS. Author: Antonio

hb, please give the specifics on the problem you're running into...

28 Mar 2012 Function for faster data transfer Matlab <--> Excel This modified version makes the original xlsread.m faster and also allows add-ins to be loaded. Author: Antonio

Norbert is right. One can open several .xls files at the same time, but to access information from each one of them the mentioned code must be run, excpet for the first line "Excel = actxserver('Excel.Application');" since the server is already active. Then, one can simply include the name of the file in the call to xlsread1 as in the example below:

Excel = actxserver('Excel.Application');

File1 = 'C:\Users\Brandao\Documents\MATLAB\xlsread1\ExcelInterface.xls';
if ~exist(File1,'file')
ExcelWorkbook = Excel.Workbooks.Add;
ExcelWorkbook.SaveAs(File1,1);
ExcelWorkbook.Close(false);
end
Excel.Workbooks.Open(File1);
from_xls1 = xlsread1(File1,'Sheet1','B2:F7');

File2 = 'C:\Users\Brandao\Documents\MATLAB\xlsread1\ExcelInterface1.xls';
if ~exist(File2,'file')
ExcelWorkbook = Excel.Workbooks.Add;
ExcelWorkbook.SaveAs(File2,1);
ExcelWorkbook.Close(false);
end
Excel.Workbooks.Open(File2);
from_xls2 = xlsread1(File2,'Sheet1','B2:F7');

Excel.ActiveWorkbook.Save;
Excel.Quit
Excel.delete
clear Excel

One can even drop the instance

if ~exist(File,'file')
ExcelWorkbook = Excel.Workbooks.Add;
ExcelWorkbook.SaveAs(File,1);
ExcelWorkbook.Close(false);
end

if one is sure the file already exists.

I think my line in this file description reading "Run the xlsread1.m as many times as needed." is misleading. What I wanted to say was that once a file is open one can use and abuse of xlsread1.xls. Sorry for that!

Hope this helps.

Comments and Ratings on Antonio's Files View all
Updated File Comment by Comments Rating
08 Aug 2014 Function for faster data transfer Matlab <--> Excel This modified version makes the original xlsread.m faster and also allows add-ins to be loaded. Author: Antonio KRUNAL

So Antonio as per your reply on 28 Mar 2012 to Norbert's post, people who are reading files in a loop that is more than just couple of them, they will have to go through the same execution time as the regular xlsread? I am asking because I have a code that reads one row of data from each of the 150 files and writes into a single file of size 150 x 1.

23 Jul 2014 Function for faster data transfer Matlab <--> Excel This modified version makes the original xlsread.m faster and also allows add-ins to be loaded. Author: Antonio Ballard, Michelle

Love the added speed, but I couldn't get it to run unless I inserted and switched Sebastian's suggestion. Worked perfect after that. Also, I couldn't get the Addins to work, but I didn't need it so I didn't troubleshoot that.

xlsread1 :

try
Excel = evalin('caller','Excel');
catch err
Excel = evalin('base','Excel');
end

13 Jul 2014 Function for faster data transfer Matlab <--> Excel This modified version makes the original xlsread.m faster and also allows add-ins to be loaded. Author: Antonio Claire

21 Mar 2014 Function for faster data transfer Matlab <--> Excel This modified version makes the original xlsread.m faster and also allows add-ins to be loaded. Author: Antonio Haibo

Dear Antonio,thank you for your xlsread1 program, which works fastly. However, it could not work with parallel computing. Could you help me running the xlsread1 code with parallel computing? Many thanks to you.

17 Mar 2014 Function for faster data transfer Matlab <--> Excel This modified version makes the original xlsread.m faster and also allows add-ins to be loaded. Author: Antonio Haibo

Thanks Antonio and Matt. These codes save more than 50 times faster (one of my calculations)

Contact us