How to get the series data from Excel

Question

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

This is my excel file... i need to get the candle series data.. can you please help this

What did you try? you have enough points to show you've been here long enough to know we dont just spew code.. — BugFinder, Jul 12 '16 at 11:56
i can't able to get the series data and didn't get any solution — Akbar Basha, Jul 12 '16 at 11:57
don't forget he's also indian, he should be much better than us :D — Lorenzo, Jul 12 '16 at 11:58
why not @AkbarBasha we arent mind readers here, there are tons of examples of getting stuff out of excel.. so.. what have you done? — BugFinder, Jul 12 '16 at 11:59

score -1 · Answer 1 · edited May 23 '17 at 10:28

If you could export the .csv from the xls you can:

        string[] lines = System.IO.File.ReadAllLines(@"yourFolder\yourCsv.csv");

        // Display the file contents by using a foreach loop.
        string[] arr;
        foreach (string line in lines)
        {
             //you get an array with each cell value
             arr=line.split(";")
             //do what you want with arr[1] which i suppose is the col you are interested to
        }

or if you want to use the .xls file format you could use LinqToExcel as suggested here Optimal way to Read an Excel file (.xls/.xlsx)

How to get the series data from Excel

1 Answers1