Recent content by soginiski

  1. S

    #SPILL! error in Excel

    Hello Sachin, I already checked our sheet and it happens with or without data within the cell. When I checked, it's turning the formulas into array formulas for some reason. Thanks for the help, though!
  2. S

    #SPILL! error in Excel

    Hello, There are times when I run the Write Collection action stage within Excel VBO, then some of the formulas return the #SPILL! error. Do you know any workaround for this? I cannot share any screenshot because the data is confidential. Thanks!
  3. S

    Cannot get multi-line text value from cell

    Hi VJR, The second scenario you showed was the situation I'm having trouble with now.
  4. S

    Cannot get multi-line text value from cell

    Hello sivagelli, Get Cell Value is what I used first but didn't work. I cannot share screenshots because the data is confidential, but I'll provide an example here. Let's say the cell contains: Multiline1 Multiline2 Multiline3 It returns the cell value as this: Multiline1Multiline2Multiline3
  5. S

    Cannot get multi-line text value from cell

    Hello, So I've been using MS Excel VBO and noticed that when I'm getting a cell value with multiple lines, it returns a single-line string. Any help? Thanks in advance!
  6. S

    Unzipping

    The link below shows how to extract with 7-zip. How will I do this if I'm only using Windows Explorer? EDIT: I can't seem to execute the first link, the .NET Framework on my machine is at 4.7 but it doesn't recognize ZipFile as a member of System.IO.Compression class.
  7. S

    Unzipping

    Good day! Is there a utility for unzipping a folder/folders? Thanks!
  8. S

    Separate data to collection

    Thanks!
  9. S

    Separate data to collection

    Good day! Is there a way to separate text in a data item then store it in a data collection? e.g. Data Item 1 (text) contains "email1@gmail.com, email2@gmail.com, email3@gmail.com", then I wanted to contain those 3 emails in one collection. Thanks in advance!
  10. S

    Copying email body with formatting and images from forward window in Gmail

    Good day. I'm having trouble copying email body in forward window in Gmail (done with shift+F). I was working on an object that will add content to the body but it overwrites the content in there, so I thought that I should copy the content first. The problem is, the content also includes...
  11. S

    Excel Data to Data Items

    Hello, I'm new here. Can I ask if it's possible to have Excel values created as separate data items? Let's say I have a column of data item names and another column for its values. Also, if that's not gonna work, is it possible to create data items if I fetched the data to a collection first...
See more
Top