MATLAB Answers


In Excel divide the single column into three columns

nada seddeeq さんによって質問されました 2017 年 12 月 23 日
最新アクティビティ nada seddeeq さんによって コメントされました 2017 年 12 月 26 日
Hi...In an Excel table, I want to divide the single column into three columns containing data from the first column,Select from A3 the three columns Tide Amplitude Phase
buffer=fileread('RasTanura 1980 AllYear._AnalysisLog.txt');
data= textscan(buffer, '%s %*f %f %f %f %f %f %f','delimiter','#');
data= [data{1},num2cell([data{2:end}])];
xlswrite('RasTanura 1980 AllYear.xlsx',data);

  2 件のコメント

Attach a short section of the original input file -- looks like should be able to just read it directly if you skip the three header lines. If you want to keep the three data values shown above, I don't understand why you would have written the format string you did???
Converted file txt to xls by code >>now i want Divide the column into three columns containing the (Tide, Amplitude, Phase) and divide columns into four at the row A34 containing (JDay(LST),Observed, Predicted, Residual) datas.
Please help me .. to find a solution

サインイン to comment.


1 件の回答

Walter Roberson
Answer by Walter Roberson
on 24 Dec 2017
 Accepted Answer

[~, txt] = xlsread('file1.xls');
TAP_cell = regexp(txt(4:29), '(?<Tide>\S+)\s+(?<Amplitude>\S+)\s+(?<Phase>\S+)', 'names', 'once');
TAP = vertcat(TAP_cell{:});
Tides = {TAP.Tide};
Amplitudes = str2double({TAP.Amplitude});
Phases = str2double({TAP.Phase});
JOPR_cells = regexp(txt(35:end), '\s+', 'split');
JOPR_cell = vertcat(JOPR_cells{:});
JOPR = str2double(JOPR_cell);
JDay_LSTs = JOPR(:,1);
Observeds = JOPR(:,2);
Predicteds = JOPR(:,3);
Residuals = JOPR(:,4);

  6 件のコメント

how i can write T1=[Tides,Amplitudes,Phases]; and sort one table content T1+T2.. withe write Text=char(d,d2)
Remove the
Tides=(cellfun(@str2double, Tides)) ;
and use
T1 = cell2table( [Tides(:), num2cell(Amplitudes(:)), num2cell(Phases(:))], 'VariableNames', {'Tide', 'Amplitude', 'Phase'});
The problem is in trying to convert the Tide to numeric, since it is text.
  • | | | | Thank you again||||*

サインイン to comment.

Translated by