Help A Newbie.. please :)

Question

4.33/5 (2 votes)

See more:

Hello everyone.

Im really new to this so decided to join this network for additional support / help.

Currently im working as an intern for a broker company. Most of the time im pretty busy but sometimes I get hours where everyone is occupied and I have nothing to do.. So i came up with an idea to be creative and actually help the company.

Im responsible for creating KPI report, however for every report I must manipulate the data from the spreadsheets to format it correctly with graphs and etc.

I was thinking, would it be possible to write something in .NET (or c# since its more relevant with excel) to import the raw data (in excel format), select which columns must be manipulated and create a graph based on my selection.

What would you recommend for this? Possibly any plugins or libraries I should be aware of?

Thanks in advance.

:)

Posted 31-Oct-11 2:24am

Ninus deMordorite

Add a Solution

Comments

Amir Mahfoozi 31-Oct-11 8:50am

Why don't you use excel charts ?

Ninus deMordorite 2-Nov-11 8:56am

Think of it this way.. I export the raw data on excel then manipulate it every month (20 clicks per raw data doc).
Now multiply the number of clicks on 30 different raw data reports.

I need to design a way that manipulates tables and creates the charts based on the raw data, so in basic terms the only clicks that the user will be performing after I am gone is just importing the raw data.

Plus it gives me something exciting to do during my off hours.

Bala Selvanayagam 31-Oct-11 8:55am

I agree with Amir and the excel charts with little bit of VBA should help

Ninus deMordorite 31-Oct-11 10:38am

Well the idea is that every single time a report is created is HAS to be manipulated.. something that macros can't do without any flaws. Therefore I decided to make an algorithm that does it for me for individual report.. so instead of 100 clicks to generate the KPI for each month.. the user has to do only 5. Plus will give me an oportunity to get more experience in the c# field

Manfred Rudolf Bihy 31-Oct-11 8:56am

[Copied from JnRC#Developer's non-solution]

Before I get technical do you have any C# coding experience?

Ninus deMordorite 31-Oct-11 10:36am

Yes I do, but have never done anything with other applications. I came as far as creating a media converter in c++ which interacted with windows media player APIs.

2 solutions

Solution 1

Look into PowerPivot, the Excel plugin which can handle huge amounts of data.

Posted 31-Oct-11 2:31am

Mehdi Gholam

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-10-31T02:34:00

Solution 2

Reading Excel From C#[^]
A simple C# library for graph plotting[^]

Posted 31-Oct-11 2:34am

OriginalGriff