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

Is there any other way to do this conversion?

Thanks

Answer 1

[Ryan Livingston]

You could just save it as a CSV in Excel:

http://www.completecampaigns.com/WebHelp/Management/Imports/How_to_convert_an_existing_Excel_file_into_a_csv_format.htm

[antonet]

 I have 100 such files.. Sorry for  not mentioning that from the beginning

thanks

[Oleg Komarov]

http://download.cnet.com/XLSX-To-CSV-Batch-Converter-Software/3000-18483_4-75727292.html

[antonet]

thanks Oleg. SO this means that I can not do this conversion within Matlab?

[Oleg Komarov]

Yes you can, but IMO MATLAB is a bit of an overkill and you should be quicker off using a specific tool.

[antonet]

What is IMO MATLAB?

[Ryan Livingston]

IMO is an acronym for In My Opinion

[Sean de Wolski]

It'd be pretty quick in MATLAB, a quick for-loop over the files xlsread/csvwrite, done...