没有回应iPad显示excel单元格数据 [英] no response for iPad to show excel cell data

问题描述

我想使用QZXLSReader Framework从Xcode 5.1.1的项目文件夹中读取excel文件。当谈到执行。它不起作用并显示所需的值。请问您是否还有其他替代方法来阅读excel数据？如何阅读项目目录下Excel文件的内容？

I would like to read the excel file from my project folder at Xcode 5.1.1 using QZXLSReader Framework. When it comes to the execution. it does not work and show the required values.WOuld you please tell me are there any other alternatives to read excel data ? How to read the content of the excel files under project directory ?

以下是我的输出日志消息

The below is my output log message

2014-06-13 16:25:13.558 marker[4130:60b] conetnt /var/mobile/Applications/D01BD499-C336-4A73-870A-6643B621E28E/marker.app/test_fr.xls
2014-06-13 16:25:13.559 marker[4130:60b] conetnt /var/mobile/Applications/D01BD499-C336-4A73-870A-6643B621E28E/marker.app/test_fr.xls
2014-06-13 16:25:13.560 marker[4130:60b] firstname (null)

以下是我的代码：

NSString *filePath = [[NSBundle mainBundle] pathForResource:@"test_fr" ofType:@"xls"];
NSURL *url = [NSURL URLWithString:filePath];
QZWorkbook *excelReader = [[QZWorkbook alloc] initWithContentsOfXLS:url];
NSArray *sheets =excelReader.workSheets;
NSMutableArray *words = [[NSMutableArray alloc] init];

for(int i = 0 ; i < [sheets count] ; i ++){
    QZWorkSheet *sheet = [sheets objectAtIndex:i];
    NSArray *columns = [ sheet columns];
    NSArray *rows =  columns.firstObject;
    for(int  j = 0  ; j < [rows count] ; j ++){
        QZCell *nextObject =  [ rows objectAtIndex:j ] ;
        [words addObject:            nextObject.content ];
NSLog(@"%@", extObject.content);

    }
}

推荐答案

我正在使用这个框架，而不是出现问题，

I was using this framework, and not problems to show it,

我使用过：

NSUrl* url = [NSURL fileURLWithPath:[[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:@"NameOfXls.xls"]]; // caminho do xls

QZWorkbook* excelReader = [[QZWorkbook alloc] initWithContentsOfXLS:url]; // pega o workbook
QZWorkSheet* firstWorkSheet = excelReader.workSheets.firstObject; // pega a primeira worksheet daquele workbook
[firstWorkSheet open];

NSLog(@"%@",firstWorkSheet.rows); // to show all rows, is obvious have some nulls values, check the output

这篇关于没有回应iPad显示excel单元格数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！