Write Range UIPath Activity Error

Help
, ,
1

When writing a datatable into an excel spreadsheet (xlsx), there is sometimes an error 'Error saving file (with filepath) using exception.Message - when this occurs, it appears to remove all of the formatting and other tabs as if it is saving it as a .csv file?

Could anyone confirm what UIpath does with the excel file in this case?

Thanks

1 Like
2

Hello,

Iā€™m using ā€œExcel Application scopeā€ + ā€œExcel Append Rangeā€ to do it. Do you use the same method ?

1 Like
3

Hi,

I am not using that, just using System Integration Write Range.

4

When UI Path canā€™t find the Excel file (filename, filepath) a brand new file is created. You probably have an issue with the file path as mentionned by the error message.

To write into an Excel file, i recommend to use ā€œAppend rangeā€, you should then be able to write into an excel file already customised

5

Hi,

Thanks :slight_smile:

We are overwriting an excel file rather than appending, using the excel application scope and excel write range seems to have fixed the issue.

We found out that it was ā€˜deletingā€™ the file when trying to overwrite the file and it therefore created a new file with just the datatable.

Thanks for the help.

6

I thought this may help somebody with similar errors. The way I managed to clear the error was using the ā€œAppend Rangeā€ activity under ā€œSystem>File>Workbookā€ instead of the ā€œAppend Rangeā€ under ā€œApp Integration>Excel>Tableā€. hope this helps.

7

The message filter indicated that the application is busy.I am getting this error.can anyone please help me out?
Thanks in Advance