write data to excel sheet column

12 次查看（过去 30 天）
Lalit Patil
Lalit Patil 2012-10-3
评论： Miguel Monserrat Diaz 2023-5-29
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
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 个评论
显示 1更早的评论
Azzi Abdelmalek
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
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
Yufei Cao 2020-8-18
After 8 years, is there a way to do this if the column number is bigger than z?
  2 个评论
Eric Dauenhauer
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
Miguel Monserrat Diaz 2023-5-29
Thank you very much. This is usefull.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by