UiPath .xlsm file write

Help Activities
, , ,
1

I am wiritng a datatable to a “.xlsm” file.
The datatable has around 500 rows.
I am writing it in the .xlsm but ony fiurst row is getting added.

2

Hi @Ritaman_Baral

Ensure that your datatable has 500 rows.
If it’s okay, share your workflow screenshot.

3

If you are writing a DataTable to an .xlsm file, and only the first row is getting added, it’s possible that there may be an issue with how you’re writing the data or with the structure of your Excel file.

1.If you are using the “Write Range” activity, make sure you are specifying the correct Excel file path, worksheet name, and range. The range should cover all the rows in your DataTable.

@Ritaman_Baral

4

Hi @Ritaman_Baral ,

Hope you are doing Good.

Write range workbook will write Data Table values into Excel but not sure why it’s not happening.

Can you please share screenshots if possible.

Thanks,
Sandhiya P

5

check if any macro is running mean time which could possibly delete the records
Or
Make sure that the DataTable variable is not empty. Run in debug mode to check that

Cheers @Ritaman_Baral

6

Hi @Ritaman_Baral

Check the DT count before adding the data in the excel file.

Share the screenshot if possible?

Regards
Gokul

7

My issue has been solved. The business provided template wss not in proper format.

8

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