Solved

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

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

806 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