Digital Exchange

Expand all | Collapse all

Adding worksheet to a Work Queue, but it keeps blank

Jump to Best Answer
  • 1.  Adding worksheet to a Work Queue, but it keeps blank

    Posted 09-13-2019 21:01

    enter image description here

    I'm getting a worksheet as Collection, then I add it to a queue, and it 'works fine', but when I look in the collection I see a lot of informations, and a lot of rows (more than in the worksheet, I don't know why), and when I look in the queue it is only with one empty row, therefore, presenting the same columns titles as in the collection.

    enter image description here

    enter image description here

    enter image description here

    --------------------------------------------------
    Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by Mauro Henrique.


  • 2.  RE: Adding worksheet to a Work Queue, but it keeps blank
    Best Answer

    Posted 09-14-2019 15:55
    Hi Mauro,

    Your excel sheet seem to be having blank rows in between data. You can do a clean up of the sheet data by deleting blank rows. When you try running again, make sure you delete the old data from the queue so as to not read the older blank items.


    Thanks,
    Shashank

    ------------------------------
    Shashank Kumar
    Senior Associate
    EY
    Asia/Singapore
    ------------------------------