Table won't export as .csv into correct folder

I am trying to export a big table (62413451x16) as a .csv file into a specific folder. This seems like it should be simple but it's not showing up for some reason. I am trying to run this code below:

save_table = 'G:\My Drive\directory';
table_path = fullfile(save_table, 'file.csv');
writetable(data, table_path)

[Taylor Azizeh]

Nope!

[Voss]

What is the evidence that the file is not showing up? Does it not appear in the folder in Windows File Explorer? You may have to refresh the view (ctrl+r in File Explorer).

Can you read the file within MATLAB? E.g.:

writetable(data, table_path) % write the file

T = readtable(table_path)    % check the result

[Walter Roberson]

try again with 'useexcel' false

[Taylor Azizeh]

Where would I put that into the code?

[Walter Roberson]

writetable(data, table_path, 'UseExcel', false)

Answer 1

[Taylor Azizeh]

I got this to work by using this weird work-around code.

% Now, export the data.
cd 'C:\folderoutput';
save_directory = 'C:\folderinput';

% Make SURE to change the file name to the same as the input
table_path = fullfile(save_directory, 'data.csv');
writetable(data_50, table_path);
beep

Answer 2

[Pratyush]

Hi Taylor,

I understand that you are not able to export your CSV file to the desired folder.

The code you provided seems correct for exporting a table as a .csv file in MATLAB. However, there are a few things you can check to troubleshoot the issue:

1. Make sure the "data" variable contains the table you want to export. You can verify this by displaying the table or checking its dimensions.
2. Ensure that the directory "G:\My Drive\directory" exists and is accessible. Verify that you have write permissions for the specified directory.
3. If there are no error messages try accessing the file from MATLAB or command prompt.
4. If you have a numeric or cell array that you want to export as a CSV file, you can use the "writematrix" function. This function is generally faster than "writetable" for large arrays.

[Taylor Azizeh]

The file is exported now, but as a text file. Do you know why it would export as a .txt file compared to a .csv?

[Stephen23]

"The file is exported now, but as a text file."

CSV files are text files: "Comma-separated values (CSV) is a text file format..."

source: https://en.wikipedia.org/wiki/Comma-separated_values

There is nothing stopping your from changing the file extension, if that is the problem.