Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Mahesh
200
Any Infragistics Tool which can replace OWC11 Spreadsheet control?
posted

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Hi,

Here I come around with One requirement to replacement Mircosoft OWC control with some other tools. So our first option is look something with Infragistics.

So Do we have some Infragistics tools which can replace OWC11 spreadsheet functionality or any similar tool?. Our basic requirement is open a excel template in our Windows Application UI form where user can export/import some excel/xml template and also User can fill the data from SQL Server and allow to edit the records and save back to database.

  • 44743
    posted

    What kind of stuff is in your template (static data, formatting, formulas, charts,...)?

    For many things, our Excel library supports creating, editing, and removing, such as cell data, formulas, most display and print settings, named references, and many other commonly used Excel features.

    There are other things that currently only have round trip support, such as charts, VBA code, and data validations. So if they are in the template, the will also appear in the re-saved file, but you cannot edit them. In some cases, you can remove these round tripped entities as well so they don't appear in the re-saved file.

    Other things are currently not supported at all and will be lost when loading a template and saving out again, such as pivot tables.

    In addition, there is no way to directly hookup the Excel library to a SQL database, so that will have to be done manually.