We need to do a SUM in excel but we dont know the range of our data.
For example, if i have a excel with a column where i have data in B1,B2 and B3 I will write: =SUBTOTAL(9,B1:B3) but with Aspose.Cells I have in B1 &=Datos.Valor but i dont know how many rows i will have. How can i write the function? &=&=SUBTOTAL(9,?:?)
I attached my excel with aspose and my output excel.
My problem is the range when i write the function if i dont know the number of my rows.