I'm encountering an issue with the 'Write Range' workbook activity when attempting to write a large volume of data. Additionally, the Excel file contains multiple sheets with extensive data. After writing to the file, it becomes corrupted and cannot be op

Help Studio
, ,
1
  • List item

I’m encountering an issue with the ‘Write Range’ workbook activity when attempting to write a large volume of data. Additionally, the Excel file contains multiple sheets with extensive data. After writing to the file, it becomes corrupted and cannot be opened. How can I resolve this problem?

2

@Srabony_Majumder1

Write RAnge workbook does not handel large Amounts of data .Use Excel Process Scope

3

Hi Srabony,

This is because the limit of excel is limited to 1,048,576 rows by 16,384 columns, but this can be handled with EXCEL ACTIVITIES i.e., dont use workbook related activities for such large and use excel activities which will directly use MS Excel application.

Cheers!

1 Like
4

Hi @Srabony_Majumder1

You can use excel activities to write the datatable back to excel using the activity Write DataTable to Excel. Since Write Range Workbook will not allow you to handle large amount of data. Use Excel activities to dump the data. This will help you resolve the error.

If you still face any error, post your queries here, I’m happy to help.

Regards

5

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