I am afraid this package works only for ‘windows-legacy’ projects right now. You can select compatibility (windows,windows-legacy or cross-platform) when creating a new project.
Basically the package works for legacy windows project
So could you create your new project to windows legacy
In Windows Compatibility we don’t have Balareva package for this moment.
You can try with Window Legacy Compatibility.
What task are you trying to do with Balareva.EasyExcel, can you explain that @Manju_Reddy_Kanughula ? May be we can see the workaround
I want add sum of the column
Amount 15,787 98,196 -2,87,829 1,76,243 1,88,480 2,36,388 -1,18,879 1,50,242 -1,88,297 2,11,822 -1,12,675 -72,623 -17,813 2,70,664 87,931 2,29,901 -2,33,229 -2,20,984 2,15,325 -1,35,168 -1,27,727 18,986 -1,09,668 1,45,837 -6,652 -1,48,487 2,72,601 37,935 2,07,554 59,204 2,34,111 -1,70,730 -69,662 -96,673 37,700 1,77,638 54,263
And you want the total amount as String? @Manju_Reddy_Kanughula
Checkout this expression @Manju_Reddy_Kanughula
Read the data and save it in the datatable
dt.AsEnumerable().Where(Function(s) Not String.IsNullOrEmpty(s("Amount").ToString) or Not String.IsNullOrWhiteSpace(s("Amount").ToString)).Sum(Function(a) CInt(a("Amount").ToString)).ToString
Can you type manually once and check there? @Manju_Reddy_Kanughula
Please try this
dt.AsEnumerable().Where(Function(x) Not IsNothing(x("Amount")) andAlso String.IsNumeric(x("Amount").ToString.Trim)).Sum(Function(x) Cdbl(x("Amount").ToString.Trim)).ToString
Try with this Linq expression
(From d in dtData.AsEnumerable Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim)) Select v = CDbl(d(1).toString.Trim)).Sum(Function (x) x)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Now you have a new version 23.0.0. It is compatibility with windows legacy and windows.