I cannot use xls2read command in MATLAB using COBRA toolbox

[narendransekar5]

Hello,

I used xls file format into COBRA Toolbox using the command 'xls2model' while doing simulation for genome scale metabolic models. However, now it is showing the following error message:

Error using xlsread (line 251) Worksheet 'Reaction List' not found.

Error in xls2model (line 75) [~, Strings, rxnInfo] = xlsread(fileName,'Reaction List');

Can you help me out?

Your help will be greatly appreciated and thanks in advance, Narendran

[Averinix]

Hi Narendran,

It might depend on your operating system. The excel connection doesn't work very well on Linux. Do you have a Linux OS? I managed to by-pass it by 1. removing all formatting from the excel, 2. reading table with Matlab "readtable" function. However, the latter doesn't work in the newest Matlab for xlsx, so I converted them to .csv. Maybe one of these options will work for you.

Best, Averina

[narendransekar5]

Hi Averina, I am working on windows platform. I tried converting the .xls to .csv. It didn't work either.

[rmtfleming]

Is Worksheet 'Reaction List' missing?

On 28 July 2016 at 00:10, narendransekar5 notifications@github.com wrote:

Hi Averina, I am working on windows platform. I tried converting the .xls to .csv. It didn't work either.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/opencobra/cobratoolbox/issues/146#issuecomment-235737276, or mute the thread https://github.com/notifications/unsubscribe-auth/ACDCOlWJBuQmK9rKrKeBxZKK-dyBCdKFks5qZ9dPgaJpZM4JWniU .

Mr. Ronan MT Fleming B.V.M.S. Dip. Math. Ph.D.

Senior research associate (EN) == Chercheur (FR), Principal investigator, Systems Biochemistry Group, wwwen.uni.lu/lcsb/research/systems_biochemistry Luxembourg Centre for Systems Biomedicine, University of Luxembourg, Campus Belval, 6, avenue du Swing, L-4367 Belvaux. & National Centre of Excellence in Research on Parkinson’s disease www.parkinson.lu & Adjunct Assistant Professor, Division of Analytical Biosciences, Leiden Academic Centre for Drug Research, Faculty of Science, University of Leiden.

http://analyticalbiosciences.leidenuniv.nl

Mobile: +352 621 175 112 Office: +352 466 644 5528

Skype: ronan.fleming

(This message is confidential and may contain privileged information. It is intended for the named recipient only. If you receive it in error please notify me and permanently delete the original message and any copies.)

[laurentheirendt]

@narendransekar5 , may we close this issue?

[laurentheirendt]

Thanks @tpfau for fixing this.