Working with temporary excel files?

[Ciara]

We have a requirement to download an excel file (IE), open it, format columns and save to a directory.

Anyone any ideas on the best approach for this?

1. Is it best to save to a location, do editing and save to required directory?
2. Other option is to open and edit directly, in the C\Users\temp\templocation but the file always opens in protected view so we can't check the location until this is disabled, but we can't interact with it via BluePrism if we don't know the location. And we cant do a broad 'turn off security' due to system requirements. Working with the temp files seems to be too difficult to handle - how do we know where the temp file will be stored?

Any help greatly appreciated.

Thanks,
C

 

[VJR]

Hi Ciara,

Are you able to open the file and do a SaveAs to some folder via BP even if it opens in the temp folder?
Also what are you using to download the file - clicking a link, or spying something, etc?

 

[Ciara]

Hi VJ,
Thanks for the reply. Yes I can do a saveAs via BP and save to a directory, just wondering if there was a quicker way. I.e. not having to save first but looks like I will have to save to directory first, do editing then save to required folder.

We are downloading via a link in IE.

Thanks
Ciara

 

[VJR]

Hi Ciara,

Yes it would be better to work in some folder versus in the temp location.

Also instead of
i. save to directory first
ii. do editing
iii. then save to required folder

you could also do
i. save to the required folder
ii. do editing there itself

 

[Ciara]

Thanks VJ!