Ignore blanks in an excel file

Help StudioX
,
2

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