Borrar filtros
Borrar filtros

How can I delete the elements of array on MATLAB?

1 visualización (últimos 30 días)
horizon
horizon el 31 de Mayo de 2019
Comentada: Stephan el 31 de Mayo de 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

Respuesta aceptada

Stephan
Stephan el 31 de Mayo de 2019
To delete an array use:
array1 = [];
  2 comentarios
horizon
horizon el 31 de Mayo de 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 el 31 de Mayo de 2019
That should work

Iniciar sesión para comentar.

Más respuestas (1)

KSSV
KSSV el 31 de Mayo de 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 comentarios
horizon
horizon el 31 de Mayo de 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 el 31 de Mayo de 2019
Yes...that's true....you will get that error...try Stephan's solution..

Iniciar sesión para comentar.

Categorías

Más información sobre Loops and Conditional Statements en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by