writetable - wrong number of arguments

Hello everyone, I'm trying to create a table and export it to Excel. I want to initialize a Result Path before to have a better overview. Is there a trick to insert that?

Result_Path = '..\Result';
 writetable(Table_Merged_Max, Result_Path,'Extraction_Mean_Time1.xlsx','Sheet','Maximum');
 
 Error using writetable - Wrong number of arguments.

Appreciate your advice and help!

Answer 1

[madhan ravi]

https://www.mathworks.com/help/matlab/ref/fullfile.html

[Malte Räuchle]

I did it with fullfile - but now this error occurs:

Unable to save the workbook to file

Check that write permissions are available, there is sufficient disk space, and the file can be written to or created.

[madhan ravi]

“Check that write permissions are available, there is sufficient disk space, and the file can be written to or created.“

Did you do that?

[Malte Räuchle]

I checked every point, permissions are available, there is enough disk space and you can write to the file..

[Malte Räuchle]

It worked with this approach:

writetable(Table_Merged_Max, '...\Resultat\MDF4_Extraktion_Mean_Time.xlsx','Sheet','Mean');

But my goal is to replace the whole path with "Result_Path".

[madhan ravi]

Ist alles klar oder nichts?

 Result_path = '...\Resultat';
filename = 'MDF4_Extraktion_Mean_Time.xlsx';
 F = fullfile(Result_path, filename);
 writetable(Table_Merged_Max,F,'Sheet','Mean');

[Malte Räuchle]

It displays still the same error..

[Malte Räuchle]

My Bad, mixed some of my code up. Thanks for your help and the great advice!

Answer 2

[Walter Roberson]

The following code will atempt to debug why your file cannot be written to. In its current form, it is specific to MS WIndows (just because of the drive name handling; the rest is shared.)

If you set create_missing to true then it will create any missing directory along the way instead of just reporting what is missing.

Note: does not handle UNC paths.

Code has not been tested in its present form (an older version of the code was tested.)

Result_Path = '..\Result';
filename = 'Extraction_Mean_Time1.xlsx';

create_missing = false;


dest_dir = Result_Path;
dest_file = filename;

failed = false;
try
    %pwd returns the previous directory
    curdir = pwd(dest_dir);
    dest_fullpath = pwd(curdir); %and go back, returning full name of where we were
catch
    fprint('Could not cd to destination directory "%s"\n', dest_dir);
    failed = true;
end

if ~failed
    if ~ismember(upper(dest_fullpath(1)), 'A':'Z') || dest_fullpath(2) ~= ':'
        fprintf('destination does not have a recognizable drive name');
        failed = true;
    end
end

if ~failed
    parts = [dest_fullpath(1:2), regexp(dest_fullpath(3:end), '[/\\]', 'split')];
    plen = cellfun(@length, parts);
    parts(plen == 0) = [];      %zap extra directory separators
    if ~exist(parts{1}, 'dir')
        fprintf('You do not have a "%s" drive. Giving up.\n', parts{1});
        failed = true;
    end
end

if ~failed
    for K = 2 : length(parts)
        thispath = fullfile(parts{1:K});
        if exist(thispath, 'dir')
            fprintf('Okay we already have directory "%s"\n', thispath);
        elseif create_missing
            try %#ok<UNRCH>
                mkdir(thispath);
                fprintf('Was able to create missing directory "%s"\n', thispath);
            catch
                fprintf('Failed trying to create missing directory "%s"', thispath);
                oldpath = fullfile(parts{1:K-1});
                [success, p] = fileattrib(oldpath);
                if success
                    fprintf('Attributes of parent directory "%s" are:\n', oldpath);
                    disp(p);
                else
                    fprintf('Could not fetch attributes of parent directory "%s"]\n', oldpath)
                    failed = true;
                    break
                end
            end
        else
            fprintf('Directory "%s" does not exist and you asked that missing directories not be created. Set the variable create_missing to true if you want the directory created\n', thispath);
            failed = true;
            break
        end
    end
    
    if failed
        fprintf('Some directory not created. Not ready to use\n');
    else
        fprintf('Okay, should be ready to use directory "%s"\n', fullfile(parts{:}) );
    end
end


fullpath = fullfile(parts{:}, dest_file);

if ~failed
    if ~exist(fullpath, 'file')
        [fid, msg] = fopen(fullpath, 'a');
        if fid < 0
            fprintf('File "%s" did not already exist and cannot be written to because: "%s"\n', fullpath, msg);
            failed = true;
        else
            fprintf('Destination file did not exist but is writable! File "%s"\n', fullpath);
            delete(fullpath);
        end
    else
        [success,attrs] = fileattrib(fullpath);
        if ~success
            fprintf('Somehow, file exists but we cannot ask about its attributes! File "%s"\n', fullpath)
            failed = true;
        else
            if attrs.UserWrite
                fprintf('Destination file exists and is writable! File: "%s"\n', fullpath)
            else
                fprintf('Destination file exists but cannot be written to! File: "%s"\n', fullpath)
                failed = true;
            end
        end
    end
end

if ~failed
    fprintf('Okay, should be ready to use file "%s"\n', fullpath);
end

[Malte Räuchle]

Thanks a lot, appreciate your help!!