Output while reading excel file

[office_work]

I am running query in sql sever
and getting the out put but unable to write the output into excel
i am uploading my the UiPath file
please correct me
here is the error
"UiPath.Excel.ExcelException: Could not write the data table starting with cell A1. —> System.Runtime.InteropServices.COMException: The message filter indicated that the application is busy. (0x8001010A (RPC_E_SERVERCALL_RETRYLATER)) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode)
at Microsoft.CSharp.RuntimeBinder.ComInterop.ComRuntimeHelpers.CheckThrowException(Int32 hresult, ExcepInfo& excepInfo, UInt32 argErr, String message)
at CallSite.Target(Closure , CallSite , Object , Object , Object )
at System.Dynamic.UpdateDelegates.UpdateAndExecute3[T0,T1,T2,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2)
at UiPath.Excel.WorkbookApplication.WriteDataTable(Range startRange, Int32 startRow, DataTable newTable, Boolean includeHeaders)
at UiPath.Excel.WorkbookApplication.WriteRange(String range, DataTable data, Boolean includeHeaders)
— End of inner exception stack trace —
at UiPath.Excel.Activities.ExcelInteropActivity`1.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

Database_Connection.xaml (21.6 KB)

[kadiravan_kalidoss (Kadiravan K)]

@office_work

Could not write the data table starting with cell A1.

Hi @office_work ,

Please check these suggestions below:

Excel append range gives UiPath.Excel.ExcelException: Could not write the data table DataTable starting with cell A1

Please check the data in your excel. In my case the error is caused by ‘=’ or ‘==’ symbol in one of the row. I noticed this by running it multiple time and saw the robot always stuck at the same row. In my case i can filter the data as it is not required and proceed with write range/append range activity.

Excel append range gives UiPath.Excel.ExcelException: Could not write the data table DataTable starting with cell A1

Hey, Im not sure if you have already fixed your issue, But I was having the same error as you and I realised it was because there was a cell in the dateable that somehow started with a “=” even thought it wasn’t a formula. You could check if that is the case for you. I fixed this by using a for each row, assign the cell value to " ’ " + Original Cell Value, The " ’ " is used in excel to combat excel formatting and is not visible in the output. Hope this helps you and others having the same is…

Excel append range gives UiPath.Excel.ExcelException: Could not write the data table DataTable starting with cell A1

Check data to be written in excel file, the data might contain special characters, formulas etc bad data which results in failure while writing to excel file. Alternative solution, use workbook write range

Thanks!

[Vimal_Mishra1 (Uipathdev23)]

@office_work You should check your datatable and write range activity.

[office_work]

I tried this but it’s not working

[Anil_G (Anil Gorthi)]

@office_work

Are you writing to a fresh excel only?

or else if there are filters on existing excel you might get this error

also try with write range workbook activity

cheers