convert xlsx to csv
13 次查看(过去 30 天)
显示 更早的评论
Dear all,
I have an .xlsx excel file and I am using Matlab2011 to transform it to an csv.file so as to be able to import this excel file as it is (that is, with the same structure) into Stata
The excel files has a structure similar to the example below
A={ 'Name1' 'Name2' 'Name_3' 'Name_4'
'AQ' '100_HOE_rev' 'TTT' [ 0]
'AQ' '100_HOE_rev' 'TTT' [ NaN]
'AQ' '100_HOE_rev' 'TTT' [ 345,8] };
I tried something like
path = NameFiles('D:\Cart_er_1.xlsx');
xlsx2csv(path)
but I get the following error
Transforming the xlsx file: D:\Cart_er_1.xlsx
Error using
Interface.Microsoft_Excel_14.0_Object_Library.Workbooks/Open
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description:
'D:\Cart_er_1.xlsx'
could not be found. Check the spelling of the file
name, and verify that the file location is correct.
If you are trying to open the file from your list of
most recently used files, make sure that the file has
not been renamed, moved, or deleted.
Help File: xlmain11.chm
Help Context ID: 0
Error in xlsx2csv (line 20)
Workbook = Excel.WorkBooks.Open(pathxlsx);
Is there any other way to do this conversion?
Thanks
0 个评论
回答(1 个)
Ryan Livingston
2013-2-19
You could just save it as a CSV in Excel:
7 个评论
Sean de Wolski
2013-2-22
It'd be pretty quick in MATLAB, a quick for-loop over the files xlsread/csvwrite, done...
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!