convert xlsx to csv

25 次查看(过去 30 天)
antonet
antonet 2013-2-19
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

回答(1 个)

Ryan Livingston
Ryan Livingston 2013-2-19
  7 个评论
Ryan Livingston
Ryan Livingston 2013-2-22
IMO is an acronym for In My Opinion
Sean de Wolski
Sean de Wolski 2013-2-22
It'd be pretty quick in MATLAB, a quick for-loop over the files xlsread/csvwrite, done...

请先登录,再进行评论。

类别

Help CenterFile 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!

Translated by