Can it be done? (excel based question)

Question

5.00/5 (1 vote)

See more:

Hi, I have just started working for a big company who are looking for a system that can take in an excel spreadsheet add it to a database and output it back to an excel spread sheet in a different format.

I understand that you can take in a whole excel sheet but can you take individual cells or does it have to be the whole sheet or nothing?

I have never attempted to use excel and c# together so at the minute this is just a bit of research to see a. if its possible and b. if its possible for me to do it!

Thanks for any replies I greatly appreciate it!

Posted 30-Jun-11 8:48am

DanHodgson88

Add a Solution

1 solution

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)

S Houghtelin · Accepted Answer · 2011-06-30T09:09:00

Solution 1

A. Yes it is possible using Excel InterOp.

http://support.microsoft.com/kb/302084[^]

B. Without knowing what your experience in programming is in any language, No. For Anybody who's competent in some languages, it's not too difficult to figure out, as long as ytou are familiar with using Excel.

Regards

Posted 30-Jun-11 9:09am

S Houghtelin

Comments

DanHodgson88 30-Jun-11 15:29pm

cheers for the reply and the link. I have made simple apps in c# and some more complicated with java. I am pretty familiar with excel(usage on a daily basis for work etc). Right ill have a look appreciate your time bud

S Houghtelin 30-Jun-11 15:30pm

Happy to be of service, thanks for the upvote! :)