Hi Everyone,
my requirement is to insert column before the last column . For eg - if my last column is Z so i need to insert column before Z column .
Any one could help me in this will be a great help..
Thanks
i am also facing the same issue ..
date format is getting changed to datetime while writing to excel ...
so i need to change the format of column from datetime to date format
Hello Everyone,
My requirement is to update the power query in excel sheet every year using blue prism..
Can you please provide some methods or work around to do so .
Thanks..
Hi Team,
i have a large data in SQL which i have to get and paste same data to existing excel . I am storing the data in collection and then using the write collection to insert the data into excel. But this method is too slow .
So i have tried another method using OLEDB , but it is also...
Thanks @SERBEM ,
yes, i have added data item in collection by using Calculation stage
i have store the data item into collection i.e. [collection.Field]
This worked for me .
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.