Hi,I have an Excel having data ranging from columns A to Z, I have following requirements.1. Column G along with values to be inserted/moved after Column B. 2. Column E and Column F needs to swap their positions.3. Needs to delete Columns P, S, and W...
HIWhile make a Release file, I failed to select dependencies of a process on BP 7.1.1It throws following error. I tried for different processes as well. Got same error while selecting dependencies.Any one assist here.------------------------------vin...
HI When my process is migrated from BP 7.1.1 to BP 6.4.1, I am facing following issue. Where all the stages are overlapping on each other in all pages.Do we have any solution.?------------------------------vinod chinthakindi--------------------------...
Hi All,I would like to color cells in Excel for specified cells.Let's say , Excel has a Column "Result" consists of values Yes and No.I want to color all cells with Red whose cell values are No similarly Green if cell value is YesDo we have any custo...
Hi All,May I know what is the Best Approach to Insert bulk collection (say >50k) to excel without chunking the collection------------------------------vinod chinthakindi------------------------------
Hi @shashank.kumar280 Thanks for the solution. For deleting multiple columns, how to provide range value.? For example I want to delete Columns P, S, and W. in a single go instead of calling delete column action thrice!------------------------------...
Hi Paul, Thanks for the solution. But I don't want to read excel data to collection. I want to Sort Columns positions within Excel.------------------------------vinod chinthakindi------------------------------
Thanks @ewilson. for sharing the DX link.It worked for me as expected. I just noticed the targeted versions are from BP 6.5 to BP 7.1. My requirement was in BP6.4.2. Anyway I converted to BP6.5 and imported to BP6.4.2 and it worked well.May I know i...
Thanks Carl for the suggestion.I have updated my code and also included Flags for Trim and Uppercase using If else condition within for loop. Now its working well.------------------------------vinod chinthakindi------------------------------
