When copying 20 invoices from Excel to a new sheet in Excel, the value is incorrect

Description:

  1. I have one excel, I can read and get right datatable, however,when using write range in the new Excel, the 20 invoices value is incorrect
    2.I read “VAT received list.xlsx” and write range at “Test.xlsx”
    Test.xlsx (9.0 KB)
    VAT received list.xlsx (11.0 KB)
    Test.xaml (13.4 KB)

Hi @Lori

Try like this

Regards,

Hi @Lori - When using Read Range make sure you enable Preserve Format.

@Lori

@rlgandu @ushu
I had checked the option what your said, however, It does not work.

@Lori - Is it possible to share your workflow

I just make a mistake, I had put wrong file, this is the right file.
@ushu
RoboticEnterpriseFramework.zip (3.6 MB)

@Lori - I tried with Workbook activities then it worked. Can you please try the same. Make sure you enable Preserve Format while using Workbook Read Range

Output

Workflow for ref:

SampleWorkflow.zip (19.3 KB)

@Lori
Yes, you are using Excel application scope instead use Workbook activities
Or if it is also not working try this
Update UiPath Package: Ensure that you are using the latest version of the UiPath.Excel.Activities package. Sometimes, updating the package can resolve known issues and improve compatibility.

@ushu
Thanks for you help, I test and find that If i does not use Excel Application scope, use File–Excel activities, can get wanted result, thanks for you help.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.