write data to excel sheet column
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Lalit Patil
el 3 de Oct. de 2012
Comentada: Miguel Monserrat Diaz
el 29 de Mayo de 2023
Hi, I have certain data. I want to write this data into excel sheet columns into incremental order.. like first data will be written in 'A' column, second data to 'B' column.. third data to 'C' column.. and so on.. so how can i do this... please suggest code or method..
0 comentarios
Respuesta aceptada
Azzi Abdelmalek
el 3 de Oct. de 2012
Editada: Azzi Abdelmalek
el 3 de Oct. de 2012
A = {1,2,3,4}; B = {1,3,4}; C = {2,5,3,7,6}
n=max([length(A),length(B),length(C)])
R=cell(3,5)
R(1,1:length(A))=A
R(2,1:length(B))=B
R(3,1:length(C))=C
xlswrite('filename.xls',R')
3 comentarios
Azzi Abdelmalek
el 3 de Oct. de 2012
Editada: Azzi Abdelmalek
el 3 de Oct. de 2012
I think there is a way, just ask your question. If it's not me who can answer, someone else can do.
Walter Roberson
el 4 de Oct. de 2012
Whether you can create a loop to make the code short depends on the representation of the data you want to store.
Más respuestas (1)
Yufei Cao
el 18 de Ag. de 2020
After 8 years, is there a way to do this if the column number is bigger than z?
2 comentarios
Eric Dauenhauer
el 25 de Nov. de 2021
I'm not sure if anyone still needs a solution to this, but I recently had to address the same issue. I'm sure there's a more eleganent way to do this, but this is where I ended up.
The cycle_number is the column number in which you want to "target" (i.e. 1, 2, 3,...26, 27, 28,...52, 53,...), and the target_column is the string output that corresponds to that column number ('A', 'B', 'C',...'Z', 'AA', 'AB', 'AC',...'AZ', 'BA',...), respectively.
function [target_column] = increment_column(cycle_number)
alphabet = [ 'A' 'B' 'C' 'D' 'E' 'F' 'G' 'H' 'I' 'J' 'K' 'L' 'M' 'N' 'O' 'P' 'Q' 'R' 'S' 'T' 'U' 'V' 'W' 'X' 'Y' 'Z'];
if cycle_number <= 26
target_column = strcat(alphabet(cycle_number));
else
m = fix(cycle_number/26);
n = (cycle_number - m*26);
if n == 0
m = m - 1;
n = 26;
end
target_column = strcat(alphabet(m), alphabet(n));
end
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!