답변 있음
why "writetable" replaces points with commas ???
@Walter Roberson, @Peter PerkinsYou're both right. Walter is more right. An XLSX file is a zip file containing XML data which ...

1년 이상 전 | 0

답변 있음
Importing 4D Excel data sets
You might try readcell. It will at least give you all the data. You will have to restructure it to get the format you'd like.

1년 이상 전 | 0

답변 있음
Program architecture for handling large .csv files
First, it would help to see an example file, and some sample code that demonstrates the problem. Here's the best I can say wit...

1년 이상 전 | 0

답변 있음
how to use setvartype on a table that is already existing
This will do what you're literally asking for. T = array2table(strings(200,0)) % 200 variables, 0 rows, all string type But I ...

1년 이상 전 | 0

| 수락됨

답변 있음
Problem with readtable MATLAB R2020a+
My best guess is that there's something installed on the path that conflicts with a function//variable that readtable is using i...

1년 이상 전 | 0

| 수락됨

답변 있음
Error csvread() numeric field -> *i
It it weren't for the "*" character this would work. Something like "1-2i" will be read as complex numbers. If you have contro...

1년 이상 전 | 0

답변 있음
For loop to replace n/a with NaN in a table
What does this do? data= readtable("Wetland_Water_Quality_data_1.csv","TreatAsMissing","n/a");

1년 이상 전 | 0

답변 있음
CSV file reading and applying loop to plot graphs
Without an example file, it's impossible to say why the code doesn't work as expected. I'm just working backwards from the error...

1년 이상 전 | 0

| 수락됨

답변 있음
CSV file reading and applying loop to plot graphs
You should look at what nhdr is when you see the error. It's likely an empty value which makes nhdr+2 empty, and [nhdr+2 inf] ju...

1년 이상 전 | 0

답변 있음
ReadTable Producing ExtraVar Headers
Main issue is that the sample code is a bad practice. Once created by detectImportOptions, the options don't get updated based o...

1년 이상 전 | 0

| 수락됨

답변 있음
Mixed character Tab delimited csv file read in
Ahhh, that's because the data is in quotes. readmatrix assumes quoted data is meant to be preserved, so the only way to get tha...

1년 이상 전 | 1

답변 있음
Mixed character Tab delimited csv file read in
Just a note: CSV means comma-separated-values, but if this is TAB separated, it's not really CSV. If the data in the sections a...

1년 이상 전 | 0

답변 있음
xlsread isn't storing all the cell values from a column
The issue is in the call to readcell which isn't using the correct syntax. See readcell documentation for details. It looks lik...

1년 이상 전 | 0

답변 있음
Quick question regarding CSV file reading.
I'd do this: opts = detectImportOptions('cycle1.csv','Delimiter',',','VariableNamingRule','preserve'); opts.SelectedVariableNa...

1년 이상 전 | 0

답변 있음
read csv file with dates and numerical in R2016b
Try this: opts = detectImportOptions(filename) T = readtable(filename,opts);

2년 이하 전 | 0

답변 있음
xlswrite substitute that writes to specific columns
This syntax is equivalent to writematrix(A,filename,'Range',xlRange)

2년 이하 전 | 1

| 수락됨

답변 있음
How to import several csv files (Nan,numeric,text) for operate with them after
I suggest readtable.

2년 이하 전 | 1

| 수락됨

답변 있음
Find and replace (overwriting) to the middle of an existing binary file
fopen(filename,'a') % append mode https://www.mathworks.com/help/matlab/ref/fopen.html#btrnibn-1-permission Then use fseek to ...

2년 이하 전 | 0

| 수락됨

답변 있음
export a cell array to excel spreadsheet
Try writecell.

2년 이하 전 | 0

| 수락됨

답변 있음
Import parts of large comma decimal txt file
You can try this after R2020a readtable(filename,'DecimalSeparator',',') or earlier opts = detectImportOptions(filename,'Deci...

2년 이하 전 | 1

| 수락됨

답변 있음
count number of rows in csv outside of matlab
Turns out this is not as easy of a question as you might think, especially if your CSV contains data that might be double-quoted...

2년 이하 전 | 0

| 수락됨

답변 있음
Merge datetime cells to create specific datetime format
If your data looks like: 2021,02,22,02,30,... then you might be better off calling readmatrix, and converting the columns A =...

2년 이하 전 | 0

답변 있음
how to save data into same excel sheet after each iteration
You can try writetable/writecell/writematrix with the 'WriteMode','append' parameter. e.g. writetable(myTable,'file.xlsx','Wr...

2년 이하 전 | 0

답변 있음
Unable to open file as a workbook excel 97
I tried opening one of your files in a hex editor, and it's not an excel file. It's a text file. What clued me in was a warning...

2년 이하 전 | 0

답변 있음
readtable command for csv file
Try this, opts = detectImportOptions(filename) T = readtable(filename,opts) I think the import options based default reading...

2년 이하 전 | 0

답변 있음
How to apply a function on all images in ImageDatastore ?
I think this is what you want. imds = imageDatastore(files,...) tds = transform(imds,@(img)classify(net,img)); YPred = readal...

2년 이하 전 | 0

| 수락됨

답변 있음
table calculation for CSV file
I tried readtable('CSVCWtable3') but MATLAB said Unable to find or open 'CSVCWtable3'. Check the path and filename or file permi...

약 2년 전 | 0

답변 있음
How can I import multiple .CSV files in MATLAB and SISTEMATICALLY process the data of each file?
You could also look at tabularTextDatastore with transform, and writeall functions. This is the basic way that's done, but you m...

약 2년 전 | 0

답변 있음
How to skip file in imageDatastore.ReadFcn?
The only way to do this is to remove the files from the Files list on the ImageDatastore, or make a copy of this dataset which c...

약 2년 전 | 1

| 수락됨

답변 있음
how to fix "unrecognized table variable name" error?
'ReadVariableNames',false This tells readtable not to read variable names from the file. So all the variable names will be "Va...

약 2년 전 | 0

더 보기