Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

C# creating excel worksheet in a windows form and format the form ? this possible?

Posted on 2013-11-27
4
Medium Priority
?
2,409 Views
Last Modified: 2013-11-28
Hello,

I am looking at trying to create an excel worksheet in a windows form, where the data would be populated by selection critieria in the windows form drop downs etc and of course format the data appropriately.

From what I can see there is no native excel contanier control that I can put into a C# windows, is that correct? Is there anyway that this can be done? Programatically or 3rd part add-in?
0
Comment
Question by:Jordan_WM
  • 2
  • 2
4 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39682469
You want to see it on the screen or do you just want to generate the file that can be opened later?

1st: http://emoreau.com/Entries/Articles/2013/01/Hosting-an-application-in-a-Windows-Forms.aspx

2nd: http://www.aspose.com/.net/excel-component.aspx
0
 

Author Comment

by:Jordan_WM
ID: 39683683
I want I am trying to do is show a an excel worksheet or workbook in a windows form. I would like the user to select options from a drop down in C# which will make a call to a DB and repopulate the data in the worksheet, then able to control the style and formatting from C# and possibly incorporate other robust functionality with in the .net framework.

The reason that I am looking at this as a possible option is that the excel work book (2003) that is being built is turing into an application and the user requests are growing. I want to look at using something more robust .net 4.0 with VS2010 to turn into into an application but I need the spreadsheet look and feel since it is financial data.
Hope that makes sense.
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 1400 total points
ID: 39683723
0
 

Author Closing Comment

by:Jordan_WM
ID: 39684071
Awesome, that is exactly what I am looking for, thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
After several hours of googling I could not gather any information on this topic. There are several ways of controlling the USB port connected to any storage device. The best example of that is by changing the registry value of "HKEY_LOCAL_MACHINE\S…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question