Export Excel sheet data to csv format

Question

I am storing my employees data in excel sheet i have developed a application where i can import csv file now i need to convert my excel sheet data to csv format so that i can import it to my application.I'm using microsoft office excel 2007 to store my data.

can any1 help me on this

Answer 1

excelSheets = excelWorkBook.Sheets("Sheet1")

excelSheets.Activate()

excelSheets.Shapes.Item(1).ControlFormat.List

Like this way you can find the different shapes (controls). Put a break point and check the values..