From: Robert Circle on
On some machines xlsread reads in the spreadsheet correctly. And on some machines. The commands are:
[numericalarray, g_pathMatrix] = xlsread('info\DefaultFilePaths.xls');
for i=1:rowsgMat
s = cell2mat(g_pathMatrix(i,1)); % check variables to see if its a comment
if ~isempty(strfind(s,'//')) || isempty(s) continue; end; % continue with the for if its a comment
s = cell2mat(g_pathMatrix(i,2));
end
On cell number B57 it will read in about 1/4 of the line and add < to end
The line above is this
'C:\CFAS\User_Files\Output_Files\TPReport_Files'
The line 57 is
'C:\CFAS\Use<'
But the spreadsheet is:
C:\CFAS\User_Files\Output_Files\TPInput_Files
From: dpb on
Robert Circle wrote:
> On some machines xlsread reads in the spreadsheet correctly. And on some
> machines. The commands are:
> [numericalarray, g_pathMatrix] = xlsread('info\DefaultFilePaths.xls');
> for i=1:rowsgMat
> s = cell2mat(g_pathMatrix(i,1)); % check variables to see if its a
> comment
> if ~isempty(strfind(s,'//')) || isempty(s) continue; end; % continue
> with the for if its a comment
> s = cell2mat(g_pathMatrix(i,2));
> end
> On cell number B57 it will read in about 1/4 of the line and add < to end
> The line above is this
> 'C:\CFAS\User_Files\Output_Files\TPReport_Files'
> The line 57 is
> 'C:\CFAS\Use<'
> But the spreadsheet is:
> C:\CFAS\User_Files\Output_Files\TPInput_Files

Excel version difference, maybe???

--