回答済み
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...

約7年前 | 0

回答済み
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...

約7年前 | 0

回答済み
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...

約7年前 | 0

回答済み
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...

約7年前 | 0

回答済み
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...

7年以上前 | 0

回答済み
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...

7年以上前 | 1

回答済み
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...

7年以上前 | 1

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

7年以上前 | 1

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

7年以上前 | 4

回答済み
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...

7年以上前 | 0

回答済み
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...

7年以上前 | 0

回答済み
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...

7年以上前 | 0

回答済み
How to read multiple CSVs files
I'd try tabularTextDatastore.

7年以上前 | 0

回答済み
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...

7年以上前 | 1

| 採用済み

回答済み
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...

7年以上前 | 1

回答済み
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

7年以上前 | 0

| 採用済み

回答済み
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 ...

7年以上前 | 0

| 採用済み

回答済み
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...

7年以上前 | 0

回答済み
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));|

7年以上前 | 0

回答済み
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...

7年以上前 | 1

回答済み
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...

7年以上前 | 0

回答済み
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...

8年弱前 | 1

| 採用済み

回答済み
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...

8年弱前 | 5

| 採用済み

回答済み
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...

8年弱前 | 1

| 採用済み

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

8年弱前 | 0

回答済み
" 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 ...

8年弱前 | 2

回答済み
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...

約8年前 | 0

回答済み
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...

約8年前 | 1

| 採用済み

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

約8年前 | 1

回答済み
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...

約8年前 | 0

| 採用済み