search

dhoerl / DHlibxls

Framework to read Excel xls spreadsheets
271 stars 86 forks source link

Is there any way to get total number of cells or total count of row and col in an xls file. #6

Closed Abhay001 closed 11 years ago

Abhay001 commented 11 years ago

Hi, i am little new to this framework, my question is how to get a total number of cells or (may be the total count of row and col) i struggled with the frame work but din't able to crack it, and if any row contains a string in a middle of particular column how do i parse it, if i provide cell.type == cellBlank it will not come to that cell itself since previous cell is blank. any help will be greatly appreciated.

dhoerl commented 11 years ago

Did you see the iterator? So you use the "- (void)startIterator:(NSUInteger)sheetNum" method to open a sheet - say 0. Then you send "- (DHcell *)nextCell", and test the return cell. Its its type is "cellBlank" then you have gotten to the end - otherwise bump a counter and do it again. Now you have the count. Send "- (void)startIterator:(NSUInteger)sheetNum" again to reset things, and you can then send nextCell again to get and review each cell.

Also, did you look at the TestProject in the git source tree? Look at ViewController.m line 55 - there is an ifdef you can toggle that does just what I said above.

Abhay001 commented 11 years ago

Great thanks a lot, do i need to take care of any licensing for this framework? before uploading it to the strore?

dhoerl commented 11 years ago

No it's BSD no attribution required

Sent from my iPhone 4.

On Feb 25, 2013, at 1:50 AM, Abhay001 notifications@github.com wrote:

Great thanks a lot, do i need to take care of any licensing for this framework? before uploading it to the strore?

— Reply to this email directly or view it on GitHub.

Abhay001 commented 11 years ago

Thanks a lot.

JanX2 commented 11 years ago

We could close this issue!