Delete first n rows of excel attachment

parth2
Tera Contributor

‎08-22-2022 12:26 AM

Hi,

 

I am trying to import an excel file with header starting from row 10. The problem I am facing is there are merged cells in first 9 rows that are causing parsing issue as shown in the image below.

find_real_file.png

My question is, is there a script I can use in Flow Designer to delete first 9 rows before uploading it to Data source and triggering the import?

TIA!

 

Labels:
Preview file
40 KB
0 Helpfuls
  • 665 Views
3 REPLIES 3

Muhammad Khan
Mega Sage
Mega Sage

‎08-22-2022 12:32 AM

Hi parth,

 

Did you try this ?

find_real_file.png

Preview file
4 KB
0 Helpfuls

parth2
Tera Contributor
In response to Muhammad Khan

‎08-22-2022 12:39 AM

Yeah I did try that. But due to merged cells in first 9 rows, I am getting the above error

0 Helpfuls

pbadion
Tera Contributor

‎12-28-2023 07:17 AM

Hi parth,

Were you able to find a fix for this? Having the same issue and the file is coming from a 3rd party inbound email action.

Don't have control on the contents of the excel file.

 

Thanks.

0 Helpfuls