Solved

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

Posted on 2013-11-27
4
2,213 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 350 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

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
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…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

710 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