rows

  1. D

    Read row starting from a specific cell

    Hi! How can I get values from row starting from a particular cell from Excel file? Example, I need to extract all values from 2nd row, starting from B2 cell? P.s. it's better to extract non-empty cells. Thanks in advance.
  2. R

    Compare multiple rows in a Collection

    Hi, I'd like to get ideas and tips for how to compare multiple rows in a Collection to group them together. The purpose is that the larger item (bytes) from the same date will be used for one purpose and the other for another. Se example: Items - Bytes - Date FieldX 1 50...
  3. A

    Write a large collection into an Excel

    Hello, I have a collection of 20,000 rows and I can´t write them in an excel, I don´t know how to write it by code or if there is some other way, thank you.
  4. Y

    Solved How to Delete Rows in Excel if Cell in Column 'A' contains 0

    I have an Excel workbook where is needed to remove all rows wherever appears a 0 value in a certain column before adding it into a collection (see attached picture as an example: When column D contains 0 value, that row must be deleted). I tried these actions with MS EXCEL VBO 1.Get Cell value...
Top