How can I delete the elements of array on MATLAB?

1 visualizzazione (ultimi 30 giorni)
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

Risposta accettata

Stephan
Stephan il 31 Mag 2019
To delete an array use:
array1 = [];
  2 Commenti
horizon
horizon il 31 Mag 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

Accedi per commentare.

Più risposte (1)

KSSV
KSSV il 31 Mag 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 Commenti
horizon
horizon il 31 Mag 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 il 31 Mag 2019
Yes...that's true....you will get that error...try Stephan's solution..

Accedi per commentare.

Tag

Prodotti


Release

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by