I have problem in importing excel file containing variable.

clc;
clear all;
close all;

syms T h rho F1 F2
mem=2 %number of elements

%element k matrix
k=h\T*[1 -1;-1 1];
m=(rho*h/6)*[2 1;1 2]

% assembling global matrix
tightwire=importdata('TightWire.xlsx')
S=zeros(mem)
M=zeros(mem)
U=tightwire(mem,1:mem+1)

%elementnumbering
nod=[1:1:mem+1];
c=cell(mem,1);
for t=1:mem
    c{t}=[nod(t) nod(t)+1];
end

for k=1:mem
    l=c{k}
    for i=1:mem+1
        for j=1:mem+1
            for o=1:2
                for p=1:2
                    if i==l(o)
                        if j==l(p)
                            S(i,j)=S(i,j)+k(o,p);
                            M(i,j)=M(i,j)+m(o,p);
                        end
                    end
                end
            end
        end
    end
end

Answer 1

[Walter Roberson]

TightWire.xlsx does not exist in your current directory, and also does not exist anywhere along your MATLAB path.

[Prateek jain]

its in my this matlab file folder

[Prateek jain]

F1	F2	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000
F1	0.0000	F2	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000
F1	0.0000	0.0000	F2	0.0000	0.0000	0.0000	0.0000	0.0000
F1	0.0000	0.0000	0.0000	0.0000	F2	0.0000	0.0000	0.0000
F1	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	F2

my excel file is like this

[Walter Roberson]

The error message in the .mlx is showing that TightWire.xlsx cannot be found -- it is not in you current folder.

You should zip your .xlsx file and attach the zip for us to test.

[Prateek jain]

here is the file