Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Aug 03, 2021 2:03 pm

Hello,

I would like to loop in all workheet rows, and for each row : loop in all row CellRange.

How can I do that ?

And how to read a specific CellRange in a row ?

Thanks a lot in advance.

Laurent.

laurent_diep
 
Posts: 4
Joined: Tue Aug 03, 2021 9:02 am

Tue Aug 03, 2021 2:24 pm

Hello,

I found by myself : You can access cells in a row by :

Code: Select all
oWorksheet.Rows[i].Cells[j]


Laurent.

laurent_diep
 
Posts: 4
Joined: Tue Aug 03, 2021 9:02 am

Wed Aug 04, 2021 3:22 am

Hello,

Glad to hear that the solution has been found by yourself.
If you encounter other issues related to our products in the future, please feel free to contact us. Wish you all the best!

Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Return to Spire.XLS