write data to excel sheet column
显示 更早的评论
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..
采纳的回答
Azzi Abdelmalek
2012-10-3
编辑：Azzi Abdelmalek
2012-10-3
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 个评论
Lalit Patil
2012-10-3
Azzi Abdelmalek
2012-10-3
编辑：Azzi Abdelmalek
2012-10-3
I think there is a way, just ask your question. If it's not me who can answer, someone else can do.
Walter Roberson
2012-10-4
Whether you can create a loop to make the code short depends on the representation of the data you want to store.
更多回答（1 个）
Yufei Cao
2020-8-18
0 个投票
After 8 years, is there a way to do this if the column number is bigger than z?
2 个评论
Eric Dauenhauer
2021-11-25
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
Miguel Monserrat Diaz
2023-5-29
Thank you very much. This is usefull.
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
