Get null value from excel

Help
, ,
1

In Excel sheet I have one column total check amount.This column have null value when I try to fetch this in data table.I am not got null value.How to fetch null value.??

2

Hi
can i have a screenshot of that column in excel if possible
or
once after getting datatable dt we can use a FOR EACH ROW activity and mention the varaible dt as input and inside the loop use a IF condition like this
String.IsNullOrEmpty(row(“columnname”).ToString)
if true it will go to THEN part where we can use a assign activity like this
row(“Columnname”) = String.Empty

@Aditya10989

3

yes sure column name is total check amount.How to get value of column C in data table

Untitled
Untitled1440Ă—900 127 KB

4

But I did not got value in data table.

5

Fine is the range mentioned as “” or “A1” in READ RANGE activity and ADD HEADERS property enabled so that the column C wiil be considered
then we can assign the string.empty with assign activity inside the IF condition as mentioned above
@Aditya10989

6

yes I got null value but when I use finalDt = exceldataDt.copy
finalDt,exceldataDt both are data table variable.I did not got null value

7

Is column C always empty in your excel? What is the error you are getting?

8

when I am using filter data then it remove column value total check amount. As mention in attachment

Untitled
Untitled1440Ă—900 75.2 KB
Untitled1
Untitled11440Ă—900 52.5 KB
.In this excel sheet value of this column is zero but some it may have value.

9

Sorry but i still dont understand what is the problem, what are you trying to do? Do you want to filter using the C column?

10

problem is when I use filter I did not got null value and not get column name also.I already pass the column name in o/p columns.but did not got null value as mention in screen shot

11

your screen shot of the datatable does show the C column and the null value is there, that is why you have 2 commas with nothing in between…

12

yes right but after this I used filter then value as well as column removed

Untitled
Untitled1440Ă—900 59.1 KB

13

I am very sorry but i cant understand what are you trying to filter there? you are showing the wrong tab…

14

because in my excel sheet have 25 column I want just 8 so I used filter table.

15

I wouldnt use filter if you dont want to filter, i would just create a string array with all columns i want to remove and after a for each with Remove Data Column.

1 Like
16

hi are you available …?