convert xlsx to csv

16 views (last 30 days)

antonet on 19 Feb 2013

0
Link

Direct link to this question

https://uk.mathworks.com/matlabcentral/answers/64102-convert-xlsx-to-csv

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);