Effacer les filtres
Effacer les filtres

How can I delete the elements of array on MATLAB?

1 vue (au cours des 30 derniers jours)
horizon
horizon le 31 Mai 2019
Commenté : Stephan le 31 Mai 2019
The following code is executed but I have no idea to delete the elements of array on MATLAB.
And therefore, Array1 and Array2 are written out with the former data.
Every time when i is increased, I would like to reset Array1 and Array2.
How can I change the following code?
global Array1
global Array2
filename = 'data.xlsx';
for i = 1:3
sheet = i
for j = (1:2)-1
one = [1];
two = [2];
Array1 = [Array1; one]
Array2 = [Array2; two]
end
xlswrite(filename, Array1, sheet, 'A1');
xlswrite(filename, Array2, sheet, 'B1');
%here I would like to delete the elements of Array1 and Array2
end

Réponse acceptée

Stephan
Stephan le 31 Mai 2019
To delete an array use:
array1 = [];
  2 commentaires
horizon
horizon le 31 Mai 2019
Thank you for you answer.
Following your suggestion, is the below code right?
global Array1
global Array2
filename = 'data.xlsx';
for i = 1:3
sheet = i
for j = (1:2)-1
one = [1];
two = [2];
Array1 = [Array1; one]
Array2 = [Array2; two]
end
xlswrite(filename, Array1, sheet, 'A1');
xlswrite(filename, Array2, sheet, 'B1');
%here I would like to delete the elements of Array1 and Array2global
Array1 = [];
Array2 = [];
end
Stephan
Stephan le 31 Mai 2019
That should work

Connectez-vous pour commenter.

Plus de réponses (1)

KSSV
KSSV le 31 Mai 2019
global Array1
global Array2
filename = 'data.xlsx';
for i = 1:3
sheet = i
for j = (1:2)-1
one = [1];
two = [2];
Array1 = [Array1; one]
Array2 = [Array2; two]
end
xlswrite(filename, Array1, sheet, 'A1');
xlswrite(filename, Array2, sheet, 'B1');
clearvars Array1 Array2
end
  2 commentaires
horizon
horizon le 31 Mai 2019
Thank you for your answer.
When I executed your code, I've got the following error.
>> sample
sheet =
1
Array1 =
1
1
1
Array2 =
2
2
2
Array1 =
1
1
1
1
Array2 =
2
2
2
2
sheet =
2
Undefined function or variable 'Array1'.
Error in untitled (line 10)
Array1 = [Array1; one]
KSSV
KSSV le 31 Mai 2019
Yes...that's true....you will get that error...try Stephan's solution..

Connectez-vous pour commenter.

Catégories

En savoir plus sur Loops and Conditional Statements dans Help Center et File Exchange

Tags

Produits


Version

R2017b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by