Cannot write range after Extract Document Data (Document Understanding)

Help Activities
, ,
1

Hi All,

I am using activity Extract Document Data under Document Understanding activity to extract data. The output is called ExtractedData_Result. Then, i want to write extracted data in excel.

ExtractedData_Result.DocumentMetadata.ResultsAsDataTables(0) for first table @ simple fields

ExtractedData_Result.DocumentMetadata.ResultsAsDataTables(1) for second table @ table

^Both datatype for above is datatable

However, i faced error when write range of the extracted data,

“Write Range Workbook: Unable to set cell value to 1600”

1600 is the first table

Write Range Workbook: Unable to set cell value to -19 -13 -25 -25 -12 -30

Above is the result of second table.

2

@aqiffm

Can you show some screenshots if activity it s properties and the error message

Cheers

3

This image shows part of a UiPath workflow with "ExtractDocumentData" and "Log Message" activities, utilizing the "mWiseForms" extractor and specifying properties for document data extraction, such as a timeout of 3600 seconds and auto-validation turned off. (Captioned by AI)
This image shows part of a UiPath workflow with "ExtractDocumentData" and "Log Message" activities, utilizing the "mWiseForms" extractor and specifying properties for document data extraction, such as a timeout of 3600 seconds and auto-validation turned off. (Captioned by AI)1201×537 29.3 KB

The image depicts a UiPath workflow configuration for writing data to an Excel file, with specific settings for the worksheet name, starting cell, and data table input. (Captioned by AI)
The image depicts a UiPath workflow configuration for writing data to an Excel file, with specific settings for the worksheet name, starting cell, and data table input. (Captioned by AI)1225×400 28.9 KB

The image shows a UiPath workflow with two "Write Range Workbook" activities writing extracted data to the "Area" and "Items" sheets of a workbook. (Captioned by AI)
The image shows a UiPath workflow with two "Write Range Workbook" activities writing extracted data to the "Area" and "Items" sheets of a workbook. (Captioned by AI)1230×622 39.1 KB

The image shows a UiPath Studio debugging session where a "Write Range Workbook: Unable to set cell value to 1600" error is displayed in the Output panel. (Captioned by AI)
The image shows a UiPath Studio debugging session where a "Write Range Workbook: Unable to set cell value to 1600" error is displayed in the Output panel. (Captioned by AI)1342×820 54.5 KB

4

@aqiffm

Open the data from locas panel …looks like there is only one row…try to remove add headers and check

Aso in locals panel open exception details to know full exception message

Alternately just to verify try to write the data using the excel app scope and check

Cheers

5

Hi,

It may be caused by mismatch data type of DataColumn.

Can you try either of the following?

  • Write it into csv file Using WriteCSV activity then convert it the csv to xlsx using ReadCSV and WriteRange OR UseExcelFile directly.

  • Create new DataTable and copy all data into it using ForEachRow etc.

Regards,

6

@Anil_G and @Yoichi , thank you for your input. I have solved it by using Assign activity.

dtFirstPage = ExtractedData_Result.DocumentMetadata.ResultsAsDataTables(0)

Then, write range normally, then it solved the issue.

1 Like
7

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