Solved

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

Posted on 2013-11-27
4
2,093 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 69

Expert Comment

by:Éric Moreau
Comment Utility
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
Comment Utility
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 69

Accepted Solution

by:
Éric Moreau earned 350 total points
Comment Utility
0
 

Author Closing Comment

by:Jordan_WM
Comment Utility
Awesome, that is exactly what I am looking for, thanks
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now