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

1 year 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®,...

1 year ago | 1

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

1 year 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...

1 year 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);

1 year 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. ...

1 year 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...

1 year 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...

1 year 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...

1 year 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...

1 year 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...

1 year 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...

1 year 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...

1 year 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...

1 year 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.

1 year 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...

1 year ago | 1

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

1 year 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...

1 year 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...

1 year ago | 0

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

1 year 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...

1 year 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...

1 year ago | 1

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

1 year 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...

1 year 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...

2 years 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...

2 years ago | 0

Answered
Issue with data format when using textscan()
The format should be all lower case for duration. %{hh:mm:ss}T However, the data appears to be delimited as semicolon. Y...

2 years ago | 1

| accepted

Answered
MatLab doesn't read my .TXT file correct
Thanks for uploading the file! The first issue I see is that the file has a UTF-16 byte-order-mark. The file is stored as UT...

2 years ago | 4

| accepted

Load more