extracting data

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Guys,

I need to create pie charts,bar diagrams and percentages
based on an excel spreadsheet.I guess this is one of that
vb automation job, but I havent done VBA before

Is crystal reports the way forward, how can I do the
above using crystal reports.

I would appreciate links to tutorials and how-tos also
any other alternatives ideas this could be done

regards
..
 
Gary,

You should be able to do all of that in Excel. If you want to go this
route, look for "excel office automation" on google, or the MSDN search
site, and you should find a number of links on how to automate Excel to do
this.

If you would rather go to a reporting mechanism, and the data is in a
tabular format in Excel, then you should be able to use the classes in the
System.Data.OleDb namespace to connect to it (using the Jet provider) and
get the data in a DataSet. Once you have that, you should be able to pass
that to any reporting system and display something based on that.

Hope this helps.
 
thnaks nicholas,

I have been using C# for a while now, Can I do the
automation using C#.

what is the best place for me to learn automation using
C#
 
Back
Top