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

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

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

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

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

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

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

9 months ago | 0

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

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

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

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

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

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

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

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

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

1 year ago | 3

| accepted

Answered
Trouble loading in mixed data from txt file
You're adding 'CollectOutput' which is concatenating all the numeric columns into one. If you remove that, you should get the nu...

1 year ago | 1

| accepted

Answered
Yet another TEXTSCAN question...
If the numbers are always surrounded by double-quotes, try this, t = textscan(s,'"%f""%f""%f"','Delimiter',',') or, ...

1 year ago | 0

Answered
" Error using readtable (line 198) An internal error occurred ". How can I solve this issue?
I tried, T = readtable('Nuevo.xlsx') T = readtable('Nuevo.xlsx','Basic',true) And both worked for me. Sometimes the ...

1 year ago | 1

Answered
readtable function ignores certain options
READTABLE uses the variable names defined in the Options over the ones in the file. This is because you can re-use the options o...

1 year ago | 0

Answered
error using readtable with "opts" and "TreatAsEmpty" together
Hi, Only a subset of the parameters in READTABLE are allowed with the options. Part of the reason is that, in the import opti...

1 year ago | 0

| accepted

Answered
reading in text files
You should try |tabularTextDatastore| assuming everything has the same format. ds = tabularTextDatastore(pathToFiles) ds...

1 year ago | 1

Answered
Convert timestamps in CSV file to seconds using readtable and table2timetable
This will work as long as the times are on the same day (as in the file). T = readtable(file,'Format','%{dd-MMM-uuuu HH:m...

1 year ago | 0

| accepted

Answered
readtable can't get variable names from csv if different number of columns
Try giving a hint. opts = detectImportOptions(filename,'NumHeaderLines',0); T = readtable(filename,opts)

1 year ago | 1

| accepted

Answered
Error when synchronizing two time series
Hi, I think this is a simple fix, this code may not do what you think it's doing: t1 = SP(:,1); % is a table I don't thi...

1 year ago | 0

Answered
large csv import and split
With a file that's 25GB, you're going to need to break the data up. I recommend using ds = tabularTextDatastore(filename...

1 year ago | 0

Answered
Hello .. how to read a text file which is a matrix of [1000x512] order of complex numbers. could anyone please help me over this
Hi Darapu, This worked for me. T = readtable('Extracted_Dry_Tar_Road_prediction_file.txt','Whitespace',' ()'); T.Va...

1 year ago | 1

| accepted

Answered
readtable does not allow 'Format' option
Hi Xiaoyu, If you're using R2016b or later, you can specify details like this with spreadsheet import options. opts = de...

2 years ago | 0

Load more