We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

first empty row

Thread ID:

Created:

Updated:

Platform:

Replies:

144359 May 2,2019 01:45 PM UTC May 7,2019 11:43 AM UTC WinForms 5
loading
Tags: XlsIO
JF Landreville
Asked On May 2, 2019 01:45 PM UTC

Hi ! How can I get the first empty row within an excel spreadsheet with XLSIO ?

Thanks.

Sivaneswaran Amsu [Syncfusion]
Replied On May 3, 2019 09:44 AM UTC

Hi JF Landreville, 

Thank you for contacting Syncfusion support. 

We have prepared a sample to get the first empty row in the Excel document which can be downloaded from the following link. 


Kindly try this and let us know if this helpful for your requirement. 

Regards, 
Sivaneswaran . A

JF Landreville
Replied On May 3, 2019 05:26 PM UTC

Thanks. Now one more question, How can I get the first empty cell in a range.. Because, I want the first empty row but I want to exclude a column.. because I have text or formule in column A, So I want the first empty row , checking a cell B from B11...

thanks.

screenshot attached.

Attachment: Capture.PNG_c4103556.zip

Abirami Varadharajan [Syncfusion]
Replied On May 6, 2019 09:43 AM UTC

Hi JF Landreville, 

We have modified the sample to get the first empty row from the specified range B11 and the sample can be downloaded from the following link. 


Kindly check if it fulfils your requirement. 

Regards, 
Abirami 


JF Landreville
Replied On May 6, 2019 02:07 PM UTC

Thank you very much ! If I want to zip all eg. pdf files that are in a directory with Syncfusion .. any sample ? Have. a nice day !

Sivaneswaran Amsu [Syncfusion]
Replied On May 7, 2019 11:43 AM UTC

Hi JF Landreville, 

We have prepared sample for as per your requirement which can be downloaded from the following link. 


To know more about the zip files, please refer the below UG documentation links. 


Kindly try this and let us know if this helpful for your requirement. 

Regards, 
Sivaneswaran . A

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon