清空筛选条件
清空筛选条件

Convert .csv file to .mat file

547 次查看（过去 30 天）
Ainuddin Khan
Ainuddin Khan 2019-2-10
评论： Imtiaz nabi 2022-1-4
I have a csv file of 2 colunms and want to be saved as a .mat file(of desired name) with two variables of desired name(each variable of dimension 1xk)
please let me know how to write a matlab code for this.
  4 个评论
显示 2更早的评论
Elise Barbeau
Elise Barbeau 2021-2-2
What if I have several csv files in one folder and I want to convert them all to .mat?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

madhan ravi
madhan ravi 2019-2-10
T=readtable('mycsv.csv');
% ^^^^^^^^^------ your csv filename
p=T{:,1};
q=T{:,2};
save('mymat.mat','p','q')
% ^^^^^^^^^----- your resulting .mat filename

更多回答（2 个）

Saidul islam Tanveer
i have 8855 rows and 1155 colums ,how cant i convert it to mat file
  3 个评论
显示 1更早的评论
Saidul islam Tanveer
Saidul islam Tanveer 2020-3-14
Thanks a lot.how can i covert times series data to array.I am trying to covert time series and date .it covert as 0.So,how can i solve this Nan file.
Imtiaz nabi
Imtiaz nabi 2022-1-4
can you give a bit more info on the time series data? maybe like showing your data rows etc so that I can guide you accordingly

请先登录，再进行评论。

Harsimran Singh
Harsimran Singh 2021-5-3
use this link, it works perfectly for me:
https://www.mrexcel.com/board/threads/delete-first-2-rows-of-each-csv-file-in-a-folder-1-000-csv-files.890203/
Option Explicit
Sub FixCsvFiles()
Dim SelectFolder As String
Dim csvFiles As Variant
Dim csvWb As Workbook
Dim x As Integer
'browse for folder with csv files
On Error GoTo FixCsvFiles_Error
SelectFolder = GetFolder("c:\")
Application.ScreenUpdating = False
'Check user did not cancel folder selection
If SelectFolder = "" Then
MsgBox "No Folder Selected - Cannot continue", vbCritical
End
End If
SelectFolder = SelectFolder & "\"
csvFiles = Dir(SelectFolder & "*.csv")
Do While csvFiles <> ""
Set csvWb = Workbooks.Open(SelectFolder & csvFiles)
Rows("1:2").Delete
x = x + 1
csvWb.Close True
csvFiles = Dir
Loop
Application.ScreenUpdating = True
MsgBox "A total of " & CStr(x) & " files processed", vbInformation
On Error GoTo 0
Exit Sub
FixCsvFiles_Error:
MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure FixCsvFiles of Module2"
End Sub
Function GetFolder(strPath As String) As String
Dim fldr As FileDialog
Dim sItem As String
Set fldr = Application.FileDialog(msoFileDialogFolderPicker)
With fldr
.Title = "BROWSE TO FOLDER LOCATION WITH CSV FILES"
.AllowMultiSelect = False
.InitialFileName = strPath
If .Show <> -1 Then GoTo NextCode
sItem = .SelectedItems(1)
End With
NextCode:
GetFolder = sItem
Set fldr = Nothing
End Function

类别

在 Help Center 和 File Exchange 中查找有关 Scripts 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by