Rank: 804 based on 155 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 25 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 101 25
  • 4.84615
4.8 | 15 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 29 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
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)

26 Feb 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 Bert

17 Feb 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 Leendert

Did a little tic - toc to see how much faster this script is. Using xlsread the average time to open all the sheets I needed was ~140s. with xlsread1 it takes 20s.!!!! Great submission

15 Feb 2014 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 h_acar

I tried this file to estimate the vapor fraction of a reactor feed. I have 64 days inlet data, most of the days the result is consistent with Aspen HYSYS flash calculation but for some days(nearly 10 days) the fmincon function gives negative results and vapor fraction becomes negative, which is impossible. How can I fix the prolem?

Contact us