We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XlsIO - DataBoundGrid scenario help...

Thread ID:





33654 Aug 23,2005 07:15 PM UTC Aug 23,2005 10:02 PM UTC WinForms 1
Tags: GridControl
Michael Palmer
Asked On August 23, 2005 07:15 PM UTC

We recently purchased your UI suite and I''d like some direction, please. Scenario: We''d like to be able to load a GDBG from a database via a DataTable and also have one or multiple unbound formula columns whose computed values we''d like stored back in the DataTable as well as displayed in the grid alongside the bound columns. We''d also like the ability to export this grid to an Excel file (along with formulas/computed values) to allow a user to verify the formulas we''re using. How might I accomplish this scenario? I''ve become somewhat familiar with your object model and we have full source for your components. Thanks.

Administrator [Syncfusion]
Replied On August 23, 2005 10:02 PM UTC

The simplest way to do this is to add Expression columns to your DataTable if they will handle the type of formulas you want to allow your user to enter. If you need to use Excel-Like formulas (where cells in one row can refer to cells in another row) as opposed to Expression type formula where the formula is restricted to use values in the same row), then you will have to do additional work if you want to use such formulas in a GridDataBoundGrid. Here is a KB discussing the work you have to do. http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=104 Another option might be to just put the data from the datatable in a GridControl. This would simplify the Excel-Like formula use tremendously. Depending upon the size of your datatables, this may not be to costly either. Once you decide on the type you need, getting the information into either a CSV or Xls file should be straight forward. If you will provide more details about your formula requirements, we can try to give more specific advice.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon