xlswrite
Publicado por Felipe (13 intervenciones) el 21/11/2016 13:52:54
Hola buenos dias, quisiera hacer la siguiente consulta
con el código que adjunto a continuación,en la parte final lanzo un xlswrite y crea el archivo pero sin embargo no se crea el .xls y me sale un error llamado "vercat"(error de concatenación vertical)
con el código que adjunto a continuación,en la parte final lanzo un xlswrite y crea el archivo pero sin embargo no se crea el .xls y me sale un error llamado "vercat"(error de concatenación vertical)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
t=str2num(get(handles.edit1,'string'));
C=str2num(get(handles.edit2,'string'));
C2=str2num(get(handles.edit3,'string'));
C3=str2num(get(handles.edit12,'string'));
%para los experimemntos con A
v1=(C(1,2)-C(1,1))/(t(1,2)-t(1,1));
v2=(C(1,3)-C(1,2))/(t(1,3)-t(1,2));
v3=(C(1,4)-C(1,3))/(t(1,4)-t(1,3));
v4=(C(1,5)-C(1,4))/(t(1,5)-t(1,4));
v5=(C(1,6)-C(1,5))/(t(1,6)-t(1,5));
v6=(C(1,7)-C(1,6))/(t(1,7)-t(1,6));
v7=(C(1,8)-C(1,7))/(t(1,8)-t(1,7));
v8=(C(1,9)-C(1,8))/(t(1,9)-t(1,8));
v9=(C(1,10)-C(1,9))/(t(1,10)-t(1,9));
v10=(C(1,11)-C(1,10))/(t(1,11)-t(1,10));
%velocidad de B--%%
vb1=(C2(1,2)-C2(1,1))/(t(1,2)-t(1,1));
vb2=(C2(1,3)-C2(1,2))/(t(1,3)-t(1,2));
vb3=(C2(1,4)-C2(1,3))/(t(1,4)-t(1,3));
vb4=(C2(1,5)-C2(1,4))/(t(1,5)-t(1,4));
vb5=(C2(1,6)-C2(1,5))/(t(1,6)-t(1,5));
vb6=(C2(1,7)-C2(1,6))/(t(1,7)-t(1,6));
vb7=(C2(1,8)-C2(1,7))/(t(1,8)-t(1,7));
vb8=(C2(1,9)-C2(1,8))/(t(1,9)-t(1,8));
vb9=(C2(1,10)-C2(1,9))/(t(1,10)-t(1,9));
vb10=(C2(1,11)-C2(1,10))/(t(1,11)-t(1,10));
%--- velocidad de C--%
vc1=(C3(1,2)-C3(1,1))/(t(1,2)-t(1,1));
vc2=(C3(1,3)-C3(1,2))/(t(1,3)-t(1,2));
vc3=(C3(1,4)-C3(1,3))/(t(1,4)-t(1,3));
vc4=(C3(1,5)-C3(1,4))/(t(1,5)-t(1,4));
vc5=(C3(1,6)-C3(1,5))/(t(1,6)-t(1,5));
vc6=(C3(1,7)-C3(1,6))/(t(1,7)-t(1,6));
vc7=(C3(1,8)-C3(1,7))/(t(1,8)-t(1,7));
vc8=(C3(1,9)-C3(1,8))/(t(1,9)-t(1,8));
vc9=(C3(1,10)-C3(1,9))/(t(1,10)-t(1,9));
vc10=(C3(1,11)-C3(1,10))/(t(1,11)-t(1,10));
%complilamos los datos de velocidad en una sola variable.
vela=[v1,v2,v3,v4,v5,v6,v7,v8,v9,v10];
velb=[vb1,vb2,vb3,vb4,vb5,vb6,vb7,vb8,vb9,vb10];
velc=[vc1,vc2,vc3,vc4,vc5,vc6,vc7,vc8,vc9,vc10];
CA=[C(1,1),C(1,2),C(1,3),C(1,4),C(1,5),C(1,6),C(1,7),C(1,8),C(1,9),C(1,10)]
CB=[C2(1,1),C2(1,2),C2(1,3),C2(1,4),C2(1,5),C2(1,6),C2(1,7),C2(1,8),C2(1,9),C2(1,10)]
CC=[C3(1,1),C3(1,2),C3(1,3),C3(1,4),C3(1,5),C3(1,6),C3(1,7),C3(1,8),C3(1,9),C3(1,10)]
ta=[t(1,1),t(1,2),t(1,3),t(1,4),t(1,5),t(1,6),t(1,7),t(1,8),t(1,9),t(1,10)]
tb=[t(1,1),t(1,2),t(1,3),t(1,4),t(1,5),t(1,6),t(1,7),t(1,8),t(1,9),t(1,10)]
tc=[t(1,1),t(1,2),t(1,3),t(1,4),t(1,5),t(1,6),t(1,7),t(1,8),t(1,9),t(1,10)]
%calculo de los logaritmos naturales para cada componente
LnVa=log(-1*vela)
LnCA=log(CA)
LnVb=log(-1*velb)
LnCB=log(CB)
LnVc=log(-1*velc)
LnCC=log(CC)
filename = 'please.xlsx';
A = {'Concentración(C)','Tiempo(s)','velocidad (ml/s)','Logaritmos Naturales de la vélocidad''Logaritmo Natural de Concentración';CA,CB,CC;ta,tb,tc;vela,velb,velc;,LnVa,LnVb,LnVc;LnCA,LnCB,LnCC};
sheet = 1;xlRange = 'A1 ';
xlswrite(filename,A,sheet,xlRange)
Valora esta pregunta
0
