how to write into excel columnwise

Question

Rohit P 2021-3-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/777767-how-to-write-into-excel-columnwise

编辑： Image Analyst 2021-3-24

function writefiles(dest_folder)
addpath(genpath(dest_folder));           %add folder to the path
filesandf=dir(dest_folder);               %display contents of folder
filesinfolder= filesandf(~([filesandf.isdir]));          %show only files of folder
fnames= {filesinfolder.name};                %show names of all  in a cell
numoffiles=length(fnames);              %number of files
k=1;
while(k<numoffiles)
    filename=filesinfolder(k).name;
    fid=fopen(filename);  %open the file
    tline = fgetl(fid);    %read file line by line
    while ischar(tline)    %iterate through every line of file 
        if contains(lower(tline),'import from')         %check for "import from" keyword
            tests_after_import_from=regexp(tline,'\w*.art\w*', 'match');       %if present,check for any string containing .art in the same line 
            ind=ismember(tests_after_import_from, fnames);       %check if the string containing .art is present in the dest_folder
            if ind~=1
                %  here i want to write the filename and
                %  tests_after_import_from into columns of excel file 'A'
                %   and 'B' respectively
                
            end
        end
    tline = fgetl(fid);    %read next line
    end
    
    
    fclose(fid);          %close the file
    k=k+1;                %next iteration
end
end

Hello all,

in this code i am getting two outputs one is tests_after_import_from and filename .now i want to write all outputs which these two variables are giving to excel file . where filename wil come in 'A' column and tests_after_import_from wil go in 'B' column after the if ind~=1 is satisfied.how can i do that..

please help...

2 个评论
显示无隐藏无

Stephen23 2021-3-21

Why do you need to a data folder to the MATLAB path?

In general it is more efficient to keep folders of data files off the MATLAB search path.

Image Analyst 2021-3-21

在 MATLAB Online 中打开

Stephen is correct. Do not use addpath() or savepath() in your code.

Just use fullfile() to construct the full file name from the base file name and the folder:

    baseFileName = filesinfolder(k).name;
    fullFileName = fullfile(dest_folder, baseFileName)
    fid = fopen(fullFileName, 'rt');  % Open the file as text.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

ANKUR KUMAR 2021-3-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/777767-how-to-write-into-excel-columnwise#answer_652752

编辑：ANKUR KUMAR 2021-3-21

在 MATLAB Online 中打开

for k=1:numoffiles
    filename=filesinfolder(kkk).name;
    fid=fopen(filename);  %open the file
    tline = fgetl(fid);    %read file line by line
    while ischar(tline)    %iterate through every line of file
        if contains(lower(tline),'import from')         %check for "import from" keyword
            tests_after_import_from=regexp(tline,'\w*.art\w*', 'match');       %if present,check for any string containing .art in the same line
            ind=ismember(tests_after_import_from, fnames);       %check if the string containing .art is present in the dest_folder
            if ind~=1
                output_table{kk,1}=filename;
                output_table{kk,2}=tests_after_import_from;
            end
        end
        tline = fgetl(fid);    %read next line
    end
    fclose(fid);          %close the file
end
xlswrite('output_file',[{'host','imported'};output_table])