excel fields

  1. H

    Transpose Collection

    Hello, As we all know Transpose collection in Utility Collection Manipulation VBO - Changes the horizontal cells to Vertical I was wondering is there any way to transpose collection from vertical cells to horizontal. Thanks in Advance! Himavanth
    • himavantht
    • Thread
    • blueprism collection manipulation excel fields excel import
    • Replies: 1
    • Forum: Blue Prism
  2. A

    How to save time in excel

    Hi All, I am trying to save a Data item in time format to an excel column, where it saves in Date time Format, not sure whether it is excel behavior to save time in date time format, Can any one tell me how to fix this ? Thanks Anandh
    • Anandh
    • Thread
    • blue prism date and time excel fields
    • Replies: 0
    • Forum: Blue Prism
  3. A

    How to find the Average of bottom 10 cells in excel

    Hi, I have an excel with 3 columns and i want to find the average of 10 rows from bottom only from column c. Ex: How the column c looks from bottom 1 2 3 4 5 6 7 8 9 10 11 12 13 14 i want to find the average from bottom (14 to 5). Thanks
  4. R

    Blue Prism excel

    Hi All, I have a scenario in which the original excel contains data like 1/1/2018 12:00:00 AM 1/1/2018 01:00:00 AM . . . 1/1/2018 23:00:00 PM Now sometimes we receives the file from source destination with missing data example : 1/1/2018 12:00:00 AM 1/1/2018 01:00:00 AM 1/1/2018 02:00:00 AM...
    • rohitsle
    • Thread
    • blue prism collection manipulation excel fields
    • Replies: 5
    • Forum: Blue Prism
  5. D

    Excel 2016. Unable to capture fields in Text Import Wizard.

    Hi All, I'm having a hard time to capture fields in my Excel 2016 using object cloning. My colleagues was able to capture the same field. Do i need to uninstall my MS Office. Does it has something to do with the specs of our laptop? Regards, Dan
Top