How to handle blank data in a row of Excel sheet


#1

I have an Excel sheet which contains 12 columns and more than 1000 rows but some columns value is missing and I want to write all the filtered values in new excel file. So please suggest me a solution so that I can fix this. It’s giving Null reference exception right now.CBCCICOMSConnectsDisconnects (5).zip (1.4 KB)


#2

Hey @Asmit_Anand1

As per my understanding you wanna skip Blank cell contained rows ?

Regards…!!
Aksh


#3

No i don’t wanna skip any blank row i have to copy each an every data to the new Excel file . I am comparing the present date with the column’s date if the match is found i have to copy every data even the blank one too.Please help me out i have to submit the workflow today only.
If u want i can upload my workflow too.
Thanks for fast reply


#4

Look into this: - Sample.zip (3.3 KB)

Note - You should do assignment by yourself and try to solve them as much you can . actually not you others too. It is not like just got something to do and you will put here. Instead you can ask where you are struggling and a logical approach you are trying so you can get a hint.

Rest upto you guys… even if i will not give sample many more to give :smile:

But if you wanna learn then think about it.

Regards…!!
Aksh


#5

Thank you so much :slight_smile:


#6

I need one more help, I want to read csv file and write into a database but this i have to do using cmd and there is a script which will upload data in the table of the database.So i have to execute that script and after reading the csv file.Please provide a hint :slight_smile:


#7

I checked your workflow, using read CSV method i am also not getting any problem but when i am trying to read xlsx file using read range activity then it’s throwing null reference error.


#8

Quick question your file is having .csv extention so why you will read it with excel though we can but still?

Regards…!!
Aksh


#9

File i am downloading from the link may contain Exel or CSV file so i am checking the file type if it is csv then it will go inside if condition else inside else. So CSV file is working fine but for excel i am getting exception.
Thanks