Copy/paste range from clipboard, selected to exclude header, uipath copies the header anyway

Dear All,

I have an issue with copying a list without the header from a webpage to excel. I have selected to “exclude the header”. however the robot copies it despite the selection. Any workaround you are aware of? Thank you!

1 Like

Hey @Laslo85

Could you please post the screenshots with an explanation?

It will be helpful in debugging & suggesting an approach if any.

Thanks
#nK

I’m not sure I can post a screenshot, it’s sensitive information within.

1 Like

Cool, No prob @Laslo85

If you can show some other sample websites the same scenario, it will be great.

@Laslo85

Welcome to our UiPath community.

May I know what type of output data are you getting it from Web application ?

it is a list of names, dates and numbers

maybe the first row is not recognized as header line from the data extraction. Just run a test and include the header for checking what additional is written to Excel.

Based on the result we can decide if first row / item from data should be excluded

@Laslo85

Use Invoke Method activity to remove first value from the list.

TargetType: null
TargetObject: varList
MethodName: RemoveAt

Under Parameters field value as 0 to remove starting value from it.

Why are you using copy/paste? You should be reading the Excel file with Workbook Read Range.

Hey @Laslo85 ,

Would it be possible to share with us some repro steps to help us understand where this issue is coming from? Alternatively, could you share with us a sample project with data extracted from a non-sensitive website?

Thanks,
Raluca

Hi lakshman,

Thank you for the reply.
I have 0 programming background, so am a bit lost here :slight_smile: Where exactly should I add this activity in the process: to table extraction or to the copy/paste range?