Undefined operator '/' (PROBLEM SOLVED YEY)
    3 views (last 30 days)
  
       Show older comments
    
  Basically my excel file was the problem my numbers were somehow reserved as text thats why the operator didnnt work THAK YOU EVERYONE 
i got thise code but when i try to run it i get this error: ((Undefined operator '/' for input arguments of type 'cell'.))
this is the code :
input_file = 'plan.xlsx';
% Read data from the specified sheet
data = readtable(input_file, 'Sheet', 'sheet1');
% Extract specific columns as arrays
L = data{:, 1}; % Assuming first column contains L values
D = data{:, 3}; % Assuming second column contains D values
k = data{:, 2}; % Assuming third column contains k values
% Initialize constants and result array
h = 50; 
eta = zeros(size(L)); 
% Loop through each element to calculate eta
for i = 1:numel(L)
    Li = L(i)/100; % Convert to meters
    Di = D(i)/100; % Convert to meters
    ki = k(i); 
    m = sqrt((4 * h)/(ki * Di));
    eta(i) = tanh(m * Li)/(m * Li);
end
% Add eta as a new column in the table
data.eta = eta;
% Write the updated table back to the Excel file
writetable(data, input_file, 'Sheet', 'sheet1');
5 Comments
  Stephen23
      
      
 on 4 Dec 2024
				The cause is most likely that some of your spreadsheet data are non-numeric.
Please upload a sample data file by clicking the paperclip button.
Answers (0)
See Also
Categories
				Find more on Spreadsheets in Help Center and File Exchange
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!

