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. Image for the cookie policy date

first empty row

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

Thanks.

5 Replies

SA Sivaneswaran Amsu Syncfusion Team May 3, 2019 04:44 AM

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


JL JF Landreville May 3, 2019 12:26 PM

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


AV Abirami Varadharajan Syncfusion Team May 6, 2019 04:43 AM

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 



JL JF Landreville May 6, 2019 09:07 AM

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 !


SA Sivaneswaran Amsu Syncfusion Team May 7, 2019 06:43 AM

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

Loader.
Live Chat Icon For mobile
Up arrow icon