How to get specific value for an excel sheet which I have read into a data-table?

Help Studio
, ,
1

Hi, I need to get the total value at the bottom for each of my excel sheets for MULTIPLE excel files. The format of the excel are all the same, I will always need to get the value in column H and with the row that says total value. How exactly can I do that?

image
image994×243 7.79 KB

I have the following activities but am stuck:

Excel application scope
Read Range ~ which outputs it to a data-table

What do i do next?

2

Hi @Chaaza,

You can use the filterdatatable activity.

You can adjust this filter better by looking at the dt range you are reading. I have added the following as an example.

image

Regards,
MY

3

@Chaaza Check the attached workflow

Example.zip (11.2 KB)

Input

Input

Output

Output
Output692×526 24.2 KB

4

Hi MY,

Thanks, Filter looks very useful, but the specific column I need is actually an unnamed column under column H. It is not “PO Value Curr,” because in the total value row that would be empty.

How do I write the programming language to correctly identify Column H? Do need to count from the 1st column? Where column A is 1, column B is 2 and so on?

5

@Chaaza

After reading data into data table you can take Read Cell Activity and in the cell field you can write the below exp. You can find this in the above attached workflow

"H"+Cint(DT.Rows.Count+1).ToString

DT is the data table name

6

I understand, then you can use inequality, not equality.

For example ;

image
image699×453 12.9 KB

This will get you the blank rows and the H column filled field total value.

Then you can get only the row with the total by using the Bring H filled filter.

8

@Chaaza What is the error that you are getting

9

Sorry let me attach the work file with more details, I did it as per your advice, but I seem unable to get the actual amount $ under write line.

I need to first get the total value so that I can later input it for subsequent workflows.
test.zip (5.0 KB)

10

The error I get when I use your example for my excel sheet (attached) is this:

22.4.3+Branch.master.Sha.926b4e643842c0bd04601053628fabcad850b6c3

DoubleConverter cannot convert from (null).

RemoteException wrapping System.NotSupportedException: DoubleConverter cannot convert from (null).
at System.ComponentModel.TypeConverter.GetConvertFromException(Object value)
at System.ComponentModel.TypeConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
at System.ComponentModel.BaseNumberConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
at UiPath.Excel.Activities.ExcelReadCell.SetResult(AsyncCodeActivityContext context, Object result)
at UiPath.Excel.Activities.ExcelInteropActivity`1.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

Utilization_Line_4500006216_10.xls (10.4 KB)

11

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