How to create Dynamic application driven by excel formulas using CircularGauge
You can create dynamic application driven by excel formulas using Circular Gauges and update the Gauge pointers based on the cell values of an Excel sheet. To achieve this requirement, you need to consider the following three areas,
The project has been created using SfCircularGauge and XlsIO controls. Refer the following namespaces.
Note: Implementation and APIs are similar in both WinRT and WPF Platforms. You can refer the mentioned UG link for WinRT platform.
Figure 1: Car Dashboard
The above sample contains five Circular Gauges and you can update its value for every 10 seconds. You can use DispatcherTimer to update pointer values in its ticks.
To change the values of the cells in the Excel sheet, you can use Numeric Up Down control.
Figure 2 : Numeric Up Down control to change Cell values
To connect with the Excel sheet (where you have the values for Gauge pointers), you can maintain a class with some necessary properties in it.
You can easily connect and access the required Excel Sheet by maintaining the following class.
Step 1: To get the cell Value from the excel sheet
The following code example explains how to retrieve the particular cell value from the Excel sheet.
Step 2: To set the cell values for the pointers
You can set the cell values for each Gauge pointer in the timer tick event to update for every ten seconds.
Step 3: To change the cell value through the Numeric Up Down control
You can bind the cell value with the numeric up down control value as mentioned in the following code example.
Step 4: To set or change the cell Value in the Excel sheet.
You can change/set (to write) the value on the Excel sheet as mentioned in the following code example.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:||Product Version:|