Unable to install Bala Reva easy excel packages

1 Like

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.

1 Like

Hi @Manju_Reddy_Kanughula

Basically the package works for legacy windows project

So could you create your new project to windows legacy

1 Like

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

1 Like

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

Yes, Correctly.

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

1 Like

Can you type manually once and check there? @Manju_Reddy_Kanughula

@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

2 Likes

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Hi All,
Now you have a new version 23.0.0. It is compatibility with windows legacy and windows.

Thank you
Balamurugan.S

3 Likes