How to export the decimal and negative data to excel

clc

clear

hold all

% Plot cylinder

[X,Y,Z] = cylinder(5,100);

[TRI,v]= surf2patch(X,Y,Z); 

patch('Vertices',v,'Faces',TRI,'facecolor',[1 1 0.5],'facealpha',0.5);
view(3);axis square; grid on; title('Enclosed Cylinder')

format long

xlswrite('myfile4.xlsx', X, ['A1:A' 
num2str(length(X))]);

xlswrite('myfile4.xlsx', Y, ['B1:B' num2str(length(Y))]);

xlswrite('myfile4.xlsx', Z, ['C1:C' num2str(length(Z))]);

hold off

I get #N/A after third column .

Answer 1

[Walter Roberson]

I suggest you use

xlswrite('myfile4.xlsx', [X(:), Y(:), Z(:)]);

[Rohan Maharjajn]

@Walter Roberson. Thank you.. That worked for me.. Now I having problem creating a loft from the points in CatiaV5. How to export those points to Catia and create a CAD drawing of those coordinates

[Walter Roberson]

Communication with Catia is discussed in http://www.mathworks.com/matlabcentral/answers/15228-link-catia-to-matlab and a few other posts.