Good day.

I have an assignment recently. I was asked to develop a 'simple' system to actually read data from an Excel worksheet and generate a graph and display the graph in a form of VB app.

Well, if the graph is to be generated in report, I guess Crystal Report would be the option. However, this case required the graph to be displayed in the form.

I read an example in MSDN in how to populate a Dataset with Excel using Db Conn. But is it possible to create a chart from a dataset in .Net ?

Is there any other way to actaully read the data from Excel ? As far as I know, the only option left would be using COM object which I tried to avoid. Generating graph require to add COM object as well using MSChart.

Any advices on this problem ?

Thanks a lot !

SonicWave