Answered
problem reading with format
The leading spaces are not being counted toward the width of the fields as you're expecting. %n.pf - will read at most n charac...

environ 3 ans ago | 0

Answered
Loading/Reading .log File
Try this: data = readtable('omar_timing_test_MG125_Block_1.log','FileType','text') Jeremy

environ 3 ans ago | 0

Answered
Windows .NET Framework Update Breaks READTABLE()
Try, readtable(filename,'Basic',true) % or UseExcel false in a more recent release.

environ 3 ans ago | 0

Answered
WRITETABLE to spreadhseet mysterious failure
"=$0.00" This is probably the culprit. The writetable function has two modes: 'UseExcel' = true/false. If you're using Excel®,...

environ 3 ans ago | 1

Answered
Transpose/combine several variables using csvwrite or writematrix
The function writematrix is available in R2019a.

environ 3 ans ago | 0

Answered
import large csv file
The issue with 22 digits of precision in DECIMAL is that MATLAB's default number type is DOUBLE which really can only handle aro...

environ 3 ans ago | 0

Answered
Effective way to extract rows (range) from a text file
Readling line by line is quite ineffecient. Try this: C = textscan(fid,'%f','delimiter','\n', 'headerlines',182);

environ 3 ans ago | 0

Answered
How to convert xlswrite to writematrix?
XLSWRITE can write either a matrix (e.g. [ 1 2 4;5 7 8] or a cell {'a' 'b';'c' 'd'}) If your input is a cell, use WRITECELL. ...

environ 3 ans ago | 0

Answered
Importing a Large CSV in chunks and getting Data Range Invalid
I'd reccomend using tabularTextDatastore for this case. It will try to automatically detect formats and handle the reading of se...

environ 3 ans ago | 0

Answered
Extracting Unknown Amount of Columns from Excel Data
I recommend using READMATRIX if you have access to R2019a, or READTABLE for earlier releases. A = readmatrix(filename) Once yo...

environ 3 ans ago | 0

Answered
Reading a csv file
It's hard to say without know what you'll be doing with the data, but I'd reccomend using the table directly unless you need a d...

environ 3 ans ago | 0

Answered
How to use fread to read little endian data?
The control of byte order is on the creation of the file identifier.https://www.mathworks.com/help/matlab/ref/fopen.html#btrnibn...

plus de 3 ans ago | 0

Answered
I have an array of date time values. How do I separate Date and time and enter it in separate columns in excel?
Assuming you have a datetime array called DateAndTime which is a column vector: Date = dateshift(DateAndTime,'start','day') Ti...

plus de 3 ans ago | 0

Answered
Import time and date text file
I can think of many different ways to approach this. The most straight forward would be to pass in a format string to READTABLE...

plus de 3 ans ago | 0

Answered
how can i export a numeric vector that starts from 0 eg. 0001 from matlab to excel?
What's happening when you pass "0001" into a spreadsheet is the same thing that would happen if you typed that number into the s...

plus de 3 ans ago | 1

Answered
Problem reading a csv file
Your CSV is a semicolon delimited file with comma as the decimal separator character. This ought to work opts = detectImport...

plus de 3 ans ago | 1

Answered
How to solve: Error using "csvread". Too many output arguments
If you have both text and numeric data, I suggest you try READTABLE instead.

plus de 3 ans ago | 1

Answered
MATLAB 2018b readtable error after update
This is an installation issue. Although this might not resolve the issue try >> restoredefaultpath >> rehash toolboxcache You...

plus de 3 ans ago | 3

Answered
How to read out a textfile from a specific line
You might try READTABLE with import options: >> opts = detectImportOptions(filename) % Check that the number of header lines...

plus de 3 ans ago | 0

Answered
How can I speed up "writetable" for large tables?
As a more programatic solution based on Walter's suggestion: If you're in a recent release (I think 18b), you can provide the 'U...

plus de 3 ans ago | 0

Answered
2018 release: Slow xlsread
Is this happening with all files? You should contact MathWorks support and include an example file for which reading has slowed...

plus de 3 ans ago | 0

Answered
How to read multiple CSVs files
I'd try tabularTextDatastore.

plus de 3 ans ago | 0

Answered
How can I import only the numbers from an csv.-files with a text header?
You should be able to add 'NumHeaderLines',7 to the datastore call and get what you want. The issue is that this looks a lot li...

plus de 3 ans ago | 1

| accepted

Answered
How to read a text file into a numeric array?
This was a tricky one. I was able to get something in, but there are extra rows at the end that aren't importable. This file ap...

plus de 3 ans ago | 1

Answered
i am asking the user for a file and i wana transform that file into a matrix, i dont know how many lines or colums there is i only know that is a square matrix and that the numbers are seperated with space bar
T = readtable(filename,'Delimiter',' '); A = T.Variables

plus de 3 ans ago | 0

| accepted

Answered
How to put a string in a text file to define headers to data?
The issue is here: fprintf(filename1, '# GHz S DB 50'); fprintf doesn't accept a file name, it need an open, writable file-id ...

plus de 3 ans ago | 0

| accepted

Answered
Reading csv file NaN and NaT problem
Based on the description, I think this is what you'd want. Without an attached file, I cannot say more. opts = detectImport...

plus de 3 ans ago | 0

Answered
Hello! i have been given a task to find monthly log return time series and then aggregate each to an annual log return series. but every code i use, follows with an error. how do i convert the data to annual the easiest possible way?
Should one of these be *Time*? |log(RFRmonthly. _Index_./ lagmatrix(RFRmonthly. _Index_,1));|

presque 4 ans ago | 0

Answered
How to use textscan to read my 2nd column and ignore the string or non numerical values?
I suggest trying opts = detectImportOptions(filename) T = readtable(filename,opts) Also, if you want to ignore those...

presque 4 ans ago | 1

Answered
xlswrite randomly overwrites entire spreadsheet!
I suggest trying in a newer version of MATLAB. If it works there, contact technical support to report the bug. I'd also sugg...

presque 4 ans ago | 0