Unable to install Bala Reva easy excel packages

[Manju_Reddy_Kanughula]

[Konrad_Mierzwa]

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.

[nikhil.girish]

Hi @Manju_Reddy_Kanughula

Basically the package works for legacy windows project

So could you create your new project to windows legacy

[Gokul001 (Gokul Balaji)]

Hi @Manju_Reddy_Kanughula

In Windows Compatibility we don’t have Balareva package for this moment.

You can try with Window Legacy Compatibility.

Regards
Gokul

[Sudharsan_Ka]

What task are you trying to do with Balareva.EasyExcel, can you explain that @Manju_Reddy_Kanughula ? May be we can see the workaround

[Manju_Reddy_Kanughula]

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

[Sudharsan_Ka]

@Manju_Reddy_Kanughula

I want add sum of the column

And you want the total amount as String? @Manju_Reddy_Kanughula

[Manju_Reddy_Kanughula]

Yes, Correctly.

[Sudharsan_Ka]

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

Regards
Sudharsan

[Manju_Reddy_Kanughula]

[Sudharsan_Ka]

Can you type manually once and check there? @Manju_Reddy_Kanughula

[Anil_G]

@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

Cheers

[Gokul001 (Gokul Balaji)]

HI @Manju_Reddy_Kanughula

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)

Regards
Gokul