c# - How to get the series data from Excel -

i have following requirement. while import excel(it consists chart) need chart series data excel. how can get? using c#

this excel file... need candle series data.. can please this

if export .csv xls can:

        string[] lines = system.io.file.readalllines(@"yourfolder\yourcsv.csv");          // display file contents using foreach loop.         string[] arr;         foreach (string line in lines)         {              //you array each cell value              arr=line.split(";")              //do want arr[1] suppose col interested         } 

or if want use .xls file format use linqtoexcel suggested here optimal way read excel file (.xls/.xlsx)