Write Range(Workbook) with Large Volume

Help Forum
, , ,
1

My Data table contains 104356 rows and 101 columns. I am trying to write that data table into the Excel sheet using Workbook activity, but facing an error “Job stopped with an unexpected exit code 0xE0434352”.

I have tried the same thing with Excel write range it is working fine. But the problem is using Excel write range, some formats will change. For example a cell consists “001” as data in it. If we use Excel write range, it directly changes to the value “1”. Is there any way to handle this? Please let me know.

Thanks in advance.

2

Hi @Konda_Sai_Charan_Goud ,

I’d say its better if you use an Excel Application Scope for this one, since the data is large and you can try toggling the Visibility to off so that the entire process works in background.

image

The Excel Application Scope is built precisely for Excel so chances of running into any errors with it are less although it will take more time.

Kind Regards,
Ashwin A.K

3

@ashwin.ashok Thanks for the Response, But using Excel write range, The Data will be not accurate. I have mentioned you an example. for suppose Column A consists of values 01,02,03,04,05… If we write this data using write range(Excel activity), the Column changes to 1,2,3,4,5. So any solution for this?

4

Hi @Konda_Sai_Charan_Goud ,

Could you try this instead?

image

(From row In dt_sampleData.AsEnumerable()
Let ls = row.ItemArray.ToList()
Let ra = ls.ConvertAll(Function(a)  "'"+a.ToString).Cast(Of Object).ToArray()
Select dt_result.Rows.Add(ra)).CopyToDataTable()

ExcelUnTruncate.xaml (8.5 KB)

Kind Regards,
Ashwin A.K

5

@ashwin.ashok Thanks for the Solution🙂