How to apply formulas on rows and columns in JExcel? RRS feed

  • Question

  • 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?
    • Moved by CoolDadTx Monday, September 14, 2020 2:36 PM Not C# related
    Monday, September 14, 2020 11:42 AM

All replies

  • Hello,

    For anything for ASP.NET use https://forums.asp.net/

    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    profile for Karen Payne on Stack Exchange

    Monday, September 14, 2020 11:57 AM