How to apply formulas on rows and columns in JExcel?

  • Thread starter Thread starter coder-hlp
  • Start date Start date
C

coder-hlp

Guest
Hello, I have jexcel table that I use in my ASP.Net application. I want to display the sum of certain columns in the bottom row of this tab (Example: A Total = A1 + A2 + ... + Moment). I also want to apply a formula to the relevant column of each row (Example: D1 = (A1 + B1) * C1), but instead of writing A1, B1 one by one, I want to apply it to all rows with a single query. How can I do it? I just discovered Jexcel. Is there any resource you can recommend?

Continue reading...
 

Similar threads

G
LINQ C# - How do we get specific column (startswith) of a row in a datatable using LINQ C#
Replies
0
Views
118
Gani tpt
G
F
Get values from DataGridView by CellContentClick then populate list for export to excel
Replies
0
Views
175
FriQenstein
F
L
WPF Binding to ItemSource in behind code and setting up columns and rows
Replies
0
Views
89
labjac
L
L
WFP DataGrid with Dynamic Columns and Rows and how to bind them to XAML without fixed properties
Replies
0
Views
83
labjac
L
S
How to query data table columns collection by LINQ
Replies
0
Views
160
Sudip_inn
S
Back
Top