# Converting MATLAB code to AutoCAD

15 views (last 30 days)
Josianne on 15 May 2024
Answered: Amish on 27 May 2024 at 6:45
I am new to MATLAB. I have been trying to convert the code to excel, so I can convert that into autocad, but nothing seems to be working. This is my code:
t = linspace(0,2*pi,201);
r = sqrt(abs(70*sin(5*t)));
[x y]=pol2cart(t,r);
z = 3 * (x.^2 + y.^2);
figure(1)
fill3(x,y,z,'c')
grid on;
##### 3 CommentsShow 1 older commentHide 1 older comment
Josianne on 15 May 2024
apologies I copied one of my trials. this is my code that i need to convert
Walter Roberson on 15 May 2024
Sorry, I do not know how to code a filled 3D surface in Excel.

Amish on 27 May 2024 at 6:45
Hi Josianne,
Your code generates a 3D shape using polar coordinates converted to Cartesian coordinates, and then calculates a z value based on x and y. In order to generate an Excel file that can be used in AutoCAD, you can just simply export these x, y, and z coordinates to an Excel file.
Here is how you can modify your code:
% Your original code for generating the shape
t = linspace(0, 2*pi, 201);
r = sqrt(abs(70*sin(5*t)));
[x, y] = pol2cart(t, r);
z = 3 * (x.^2 + y.^2);
% Visualize the shape
figure(1)
fill3(x, y, z, 'c')
grid on;
% Prepare the data for export
dataForExcel = [x', y', z']; % Combine x, y, and z into a single matrix
% Export the data to an Excel file
filename = 'shapeData.xlsx';
writematrix(dataForExcel, filename);
This will create an Excel file named shapeData.xlsx in your current MATLAB working directory.
Finally, you may use AutoCAD's DATAEXTRACTION command to bring the Excel data into your drawing.
The documentation for the writematrix function can be found at: https://www.mathworks.com/help/matlab/ref/writematrix.html.
Hope this helps!