Ignore blanks in an excel file

Hi my automation goes like this:

I am trying to copy information from an excel file into a word document. However, the excel files contains certain blanks. How do I automate such that UiPath would ignore the blank and if it’s a blank, it takes the information from a previous cell?

Hi

Hope the below steps would help you resolve this

  1. First let’s read the excel file and get the datatable and remove the blank rows from it

  2. For removal of blank rows refer this thread for a sample xaml
    How to delete Blank/Empty rows in an Excel - #8 by Lahiru.Fernando

  3. And once after that we need word package to be installed
    For that go to Design tab → Manage Packages → all Packages → search as UiPath.Word

  4. Install it and now in design panel include word scope activity

  5. Inside that scope use a https://docs.uipath.com/activities/docs/word-insert-data-table

Cheers @MANDY_CHONG_YEE_LING

1 Like