Beantwortet
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 ...

mehr als 3 Jahre vor | 0

| akzeptiert

Beantwortet
export a cell array to excel spreadsheet
Try writecell.

mehr als 3 Jahre vor | 0

| akzeptiert

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

mehr als 3 Jahre vor | 1

| akzeptiert

Beantwortet
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...

mehr als 3 Jahre vor | 0

| akzeptiert

Beantwortet
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 =...

fast 4 Jahre vor | 0

Beantwortet
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...

fast 4 Jahre vor | 1

Beantwortet
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...

fast 4 Jahre vor | 0

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

fast 4 Jahre vor | 0

Beantwortet
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...

fast 4 Jahre vor | 0

| akzeptiert

Beantwortet
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...

fast 4 Jahre vor | 0

Beantwortet
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...

fast 4 Jahre vor | 0

Beantwortet
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...

fast 4 Jahre vor | 1

| akzeptiert

Beantwortet
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...

fast 4 Jahre vor | 0

Beantwortet
problem with the function "fread"
The error indicates that fopen returned an invalid file ID. Try this: [fid,msg] = fopen(filename) if fid < 0 error(msg) ...

fast 4 Jahre vor | 0

Beantwortet
Read fixed number of numbers from text file
I assume the dots are meant as ellipses and not literally dots in the file. If so, you can use textscan pretty effectively here....

fast 4 Jahre vor | 1

| akzeptiert

Beantwortet
Import multiple .csv files with different of variables and rows
More recent versions of MATLAB generate code with the Import Tool which used the Import Options and readtable. The code is simpl...

etwa 4 Jahre vor | 0

Beantwortet
Csv file: reading values with comma
I think you need to set the decimal separator and thousands separator. Also, duration may be the better type for two of the vari...

etwa 4 Jahre vor | 0

Beantwortet
Problem to read csv file with a blank line
Hi, As others have pointed out, your CSV (Comma separated value) file is actually semicolon separated. If readtable is using c...

etwa 4 Jahre vor | 0

Beantwortet
How to import data from attatched csv file?
In R2020a, T = readtable('data.csv','TrimNonNumeric',true,'NumHeaderLines',11); or in earlier releases, opts = detectImportO...

mehr als 4 Jahre vor | 1

Beantwortet
How to import data from .txt file?
The textscan function expects a fileID, not a file name. you need to use fopen. [filename,pathname]=uigetfile({'*.fl.txt' 'Torq...

mehr als 4 Jahre vor | 0

Beantwortet
readtable with multiple date formats
Without seeing the file, I can only guess, but I'd try the following first: T = readtable(filename,'DateLocale',locale,...) No...

mehr als 4 Jahre vor | 0

| akzeptiert

Beantwortet
How to use Excel application, how can i know all the functions and ways to use it?
Active X is a Microsoft feature, controling the application depends on the APIs the application exposes. For Excel, you should c...

mehr als 4 Jahre vor | 1

Beantwortet
using spreadsheet column headers as variable
When you create import options from scratch, you need to specify all the information, including where the variablenames and data...

mehr als 4 Jahre vor | 0

Beantwortet
Error using readmatrix - Unable to determine range. Range must be a named range in the sheet or a single cell within 'XFD1048576'.
'Range' also accepts numeric inputs [r1 c1 r2 c2], the drawback being you need to specify the columns. You can specify only the...

mehr als 4 Jahre vor | 1

| akzeptiert

Beantwortet
Using writetable to create a text file
WriteMode is available in R2020a. What version are you using?

mehr als 4 Jahre vor | 0

Beantwortet
How to change the date format of ,txt file?
https://www.mathworks.com/matlabcentral/answers/516121-how-do-i-specify-a-datetime-format-when-reading-a-csv-excel-file

mehr als 4 Jahre vor | 0

| akzeptiert

Beantwortet
Errors using xlsread to import data from Excel
Sometimes the Excel instalation can break xlsread, there shouldn't be a reason MATLAB install changed anything for you. It might...

mehr als 4 Jahre vor | 1

| akzeptiert

Beantwortet
how to check whether a sheet exists or not, while using readtable function
I don't know if it's any better, but there is https://www.mathworks.com/help/matlab/ref/sheetnames.html Otherwise, try/catch mi...

mehr als 4 Jahre vor | 1

Beantwortet
Error in XML file
You could try fid = fopen(fname); bytes = fread(fid); fclose(fid); find(bytes==1) If that doesn't find anything, then it ma...

fast 5 Jahre vor | 0

Beantwortet
Does MATLAB add extra data to text files?
I'd check the new line characters "\r" isn't typically used for a new line in most modern environments. It may be that the tex...

fast 5 Jahre vor | 1

| akzeptiert