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


  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


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


@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.
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


Workflow for ref:

SampleWorkflow.zip (19.3 KB)

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.

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.