none
Find the last cell that contains data in column RRS feed

  • Question

  • Hello
    I have an excel file that contains the names of the columns in the first row.
    How can I find the number of the last non-empty column in the first row?
    I use the library ClosedXML.Excel;
    Tuesday, November 27, 2018 1:52 PM

Answers

All replies

  • Hi Aleks,

    >>How can I find the number of the last non-empty column in the first row?

    Do you want to achieve that by coding? If so, what are you use, C# or VBA?<o:p></o:p>

    Could you please describe your problem in more detail?

    The following links are some similar questions:

    How can I find last row that contains data in the Excel sheet with a macro?

    Find name of the last cell with data in a row

    Last non-empty cell in a column

    Hopefully it helps you.

    Best Regards,

    Lina


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.

    • Marked as answer by Aleks Roth Saturday, December 1, 2018 11:42 AM
    Wednesday, November 28, 2018 2:21 AM
  • Hi Aleks,

     

    Thanks for your asking. Please remember to mark the replies as answers if they helped and please help us close the thread.

     

    Thank you for understanding. If you have any question, or update, please feel free to let us know.

     

    I wish you a happy life!

     

    Best Regards,

     

    Lina


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.

    Friday, November 30, 2018 5:56 AM