dhoerl / dhlibxls Goto Github PK

Assertion failed: (reader), function -[ViewController viewDidLoad],

stop in:
if (!(pWB->olestr=ole2_fopen(ole,(BYTE *)"Workbook")) && !(pWB->olestr=ole2_fopen(ole,(BYTE *)"Book")))

PhaseScriptExecution "Run Script" /Users/nikhilgahlot/Library/Developer/Xcode/DerivedData/MWIExcelPresenter-dbhrmhrdkxdrzibogdvgdydwevjv/Build/Intermediates/DHxlsReaderIOS.build/Debug-iphonesimulator/DHxlsReaderIOS.build/Script-DEB78B6414BC793700845894.sh
cd "/Users/nikhilgahlot/Desktop/MWI Eloquence App /MWIExcelPresenter/MWIExcelPresenter/DHlibxls"
/bin/sh -c /Users/nikhilgahlot/Library/Developer/Xcode/DerivedData/MWIExcelPresenter-dbhrmhrdkxdrzibogdvgdydwevjv/Build/Intermediates/DHxlsReaderIOS.build/Debug-iphonesimulator/DHxlsReaderIOS.build/Script-DEB78B6414BC793700845894.sh

svn: Repository moved permanently to 'https://svn.code.sf.net/p/libxls/code/trunk/libxls'; please relocate
Command /bin/sh failed with exit code 1

Hi David

Just wondering if there is any intention to submit to cocoapods? Would you consider a PR to do so?

git clone https://github.com/dhoerl/DHlibxls.git Cloning into 'DHlibxls'... remote: Enumerating objects: 369, done. remote: Total 369 (delta 0), reused 0 (delta 0), pack-reused 369 Receiving objects: 100% (369/369), 511.68 KiB | 2.96 MiB/s, done. Resolving deltas: 100% (130/130), done. fatal: cannot create directory at 'DHxlsReaderIOS.xcodeproj?xcuserdata': Illegal byte sequence warning: Clone succeeded, but checkout failed. You can inspect what was checked out with 'git status' and retry the checkout with 'git checkout -f HEAD'

The error is
fatal: cannot create directory at 'DHxlsReaderIOS.xcodeproj?xcuserdata': Illegal byte sequence

Funny how no one is getting this error though...

I had to clone this project on a linux server and scp it to my mac to be able to use it.

Im trying to read a xlsx(excel > 2004) and I know are not working, this not read xlsx? Any idea how to read?

Everything was working fine. I then replaced my .xls file with another .xls file of the same name (I deleted the original first). After that I got this error. I have tried putting the original file back as well as several other .xls files I get this error with everything now.

It happens here:
_reader = [DHxlsReader xlsReaderFromFile:path];
assert(_reader);

at the assert. I have checked the path and it is correct.

The full error:
Assertion failed: (_reader), function -[ConvertExcel init], file /Users/me/Documents/Stuff/Inventory/Inventory/ConvertExcel.m, line 19.

You are probably aware that in this project you are using your libxls and the follow-up project by Jan is using xlslib which cannot read xls files at all, right?
While there is no option to read/parse files in Jan's project (yet?), I'd advise to update the README once again to reflect that.
Might save someone (like me) an hour or two ;)

I'd like to use the DHlibxls framework within my Mac project. The core project is coded for IOS but really doesn't use any IOS objects. Can I use it 'as is' and drop it into a Mac project or do I need to OS X-ize it first? Kind of a dopey question but I'm new at this.

I need to get the color while importing(reading) excel file into my project. Is it Possible ?

Could support for a password protected xls be added?

Your app does not work with .xslx. How can i fix it?

i had run it on arm，it works ok;

then i run it on mips,have some problem,i compiler libxls-1.3.1\cplusplus*.cpp，and run,below is the print,can you help to fix it?
my compiler:mipsel-linux-gcc 4.1.2 glibc 2.6.1

[root@Ingenic /root]# ./testXlsRead

ole2_open /tmp/xls.xls
ole2_open: /tmp/xls.xls
==== OLE HEADER ====
verminor: 3E
verdll: 3
sect len: 200 (512)
mini len: 40 (64)
Fat sect.: 1
Dir Start: 1
Mini Cutoff: 4096
MiniFat Start: 2
Count MFat: 1
Dif start: FFFFFFFE
Count Dif: 0
Fat Size: 512 (0x200)
SecID[0]=-3
SecID[1]=80
SecID[2]=-2
SecID[3]=81
SecID[4]=5
SecID[5]=6
SecID[6]=7
SecID[7]=8
SecID[8]=9
SecID[9]=10
SecID[10]=11
SecID[11]=12
SecID[12]=13
SecID[13]=14
SecID[14]=15
SecID[15]=16
SecID[16]=17
SecID[17]=18
SecID[18]=19
SecID[19]=20
SecID[20]=21
SecID[21]=22
SecID[22]=23
SecID[23]=24
SecID[24]=25
SecID[25]=26
SecID[26]=27
SecID[27]=28
SecID[28]=29
SecID[29]=30
SecID[30]=31
SecID[31]=32
SecID[32]=33
SecID[33]=34
SecID[34]=35
SecID[35]=36
SecID[36]=37
SecID[37]=38
SecID[38]=39
SecID[39]=40
SecID[40]=41
SecID[41]=42
SecID[42]=43
SecID[43]=44
SecID[44]=45
SecID[45]=46
SecID[46]=47
SecID[47]=48
SecID[48]=49
SecID[49]=50
SecID[50]=51
SecID[51]=-2
SecID[52]=53
SecID[53]=54
SecID[54]=55
SecID[55]=56
SecID[56]=57
SecID[57]=58
SecID[58]=59
SecID[59]=60
SecID[60]=61
SecID[61]=62
SecID[62]=63
SecID[63]=64
SecID[64]=65
SecID[65]=66
SecID[66]=67
SecID[67]=68
SecID[68]=69
SecID[69]=70
SecID[70]=71
SecID[71]=72
SecID[72]=73
SecID[73]=74
SecID[74]=75
SecID[75]=76
SecID[76]=77
SecID[77]=78
SecID[78]=79
SecID[79]=-2
SecID[80]=-2
SecID[81]=-2
SSecID[0]=-2
SSecID[1]=2
SSecID[2]=3
SSecID[3]=4
SSecID[4]=-2
SSecID[5]=6
SSecID[6]=7
SSecID[7]=8
SSecID[8]=-2
SSecID[9]=10

SSecID[10]=-2

ole2_sopen start=1h

ole2_read (end)
start: 1
pos: 128
cfat: 0
size: -1
fatpos: 80
bufsize: 512
eof: 0
OLE NAME: (null) count=0
OLE NAME: (null) count=0

OLE TYPE: root file=0

ole2_read (end)
start: 1
pos: 256
cfat: 0
size: -1
fatpos: 80
bufsize: 512
eof: 0
OLE NAME: (null) count=1
OLE NAME: (null) count=1

OLE TYPE: user file=1

name: (null) (size=18 [c= ])
bsize 18
type 2
flag 1
left 2
right 4
child FFFFFFFF
guid 0000-0000-0000-0000 0000-0000-0000-0000
user flag 0000
sstart 0052

size 14029

ole2_read (end)
start: 1
pos: 384
cfat: 0
size: -1
fatpos: 80
bufsize: 512
eof: 0
OLE NAME: (null) count=2
OLE NAME: (null) count=2

OLE TYPE: user file=2

name: (null) (size=10 [c= ])
bsize 10
type 2
flag 1
left FFFFFFFF
right 6
child FFFFFFFF
guid 0000-0000-0000-0000 0000-0000-0000-0000
user flag 0000
sstart 0000

size 0020

ole2_read (end)
start: 1
pos: 0
cfat: 1
size: -1
fatpos: -2
bufsize: 512
eof: 0
OLE NAME: (null) count=3
OLE NAME: (null) count=3

OLE TYPE: user file=3

name: (null) (size=24 [c= ])
bsize 24
type 2
flag 0
left FFFFFFFF
right FFFFFFFF
child FFFFFFFF
guid 0000-0000-0000-0000 0000-0000-0000-0000
user flag 0000
sstart 0004

size 24554

ole2_read (end)
start: 1
pos: 128
cfat: 1
size: -1
fatpos: -2
bufsize: 512
eof: 0
OLE NAME: (null) count=4
OLE NAME: (null) count=4

OLE TYPE: user file=4

name: (null) (size=40 [c= ])
bsize 40
type 2
flag 1
left 3
right 5
child FFFFFFFF
guid 0000-0000-0000-0000 0000-0000-0000-0000
user flag 0000
sstart 0001

size 0208

ole2_read (end)
start: 1
pos: 256
cfat: 1
size: -1
fatpos: -2
bufsize: 512
eof: 0
OLE NAME: (null) count=5
OLE NAME: (null) count=5

OLE TYPE: user file=5

name: (null) (size=56 [c= ])
bsize 56
type 2
flag 0
left FFFFFFFF
right FFFFFFFF
child FFFFFFFF
guid 0000-0000-0000-0000 0000-0000-0000-0000
user flag 0000
sstart 0005

size 0240

ole2_read (end)
start: 1
pos: 384
cfat: 1
size: -1
fatpos: -2
bufsize: 512
eof: 0
OLE NAME: (null) count=6
OLE NAME: (null) count=6

OLE TYPE: user file=6

name: (null) (size=18 [c= ])
bsize 18
type 2
flag 0
left FFFFFFFF
right FFFFFFFF
child FFFFFFFF
guid 0000-0000-0000-0000 0000-0000-0000-0000
user flag 0000
sstart 0009

size 0111

ole2_read (end)
start: 1
pos: 512
cfat: 1
size: -1
fatpos: -2
bufsize: 512
eof: 1
OLE NAME: (null) count=7

OLE NAME: (null) count=7

ole2_fopen SummaryInformation
str (nil)
str (nil)
str (nil)
str (nil)
str (nil)
str (nil)

str (nil)

ole2_fopen DocumentSummaryInformation
str (nil)
str (nil)
str (nil)
str (nil)
str (nil)
str (nil)

str (nil)

ole2_fopen Workbook
str (nil)
str (nil)
str (nil)
str (nil)
str (nil)
str (nil)

str (nil)

ole2_fopen Book
str (nil)
str (nil)
str (nil)
str (nil)
str (nil)
str (nil)
str (nil)
Workbook not found
terminate called after throwing an instance of 'std::string'
Aborted

Hi!

In the Terminal, I manually called the script run when compiling the test app in Xcode, in order to permanently accept the svn certificate. After doing that I could build the test app.

I load up the TestDHlibxls.xcodeproj file, and hit Run.

It just says "Build succeeded" without running.

I'm trying to run it in the iOS6 simulator, which doesn't load when I build the app.

Also tried building it to an iPad2 running iOS6. Same thing.

Is there something I need to change in the project to get it to run?

Using Xcode 4.5

EDIT Solution:
Had to select the executable file in Product -> Edit Scheme -> "Run TestDHlibxls.app" -> Executable.
It was set to "none"

Link are break, is possible with this framework Read and Write in any xls?

Noticed that there is a segfault in xls_addCell when loading large files. Might there be an easy way to instead index rows with ints or longs? If not, maybe fail gracefully instead. Otherwise this parser is great! lmk if you cannot reproduce this behavior.

When trying to open large files (the 'dividing line' seems to be around 23,400 KB) that have been saved from Excel on Windows (the same file saved from Excel on OSX works fine), I get a crash on [DHxlsReader xlsReaderWithPath:]

• thread 24, stop reason = EXC_BAD_ACCESS (code=1, address=0x7fd35b0c35a4)
  • frame 0: 0x00000001104e6077 xls_dumpSummary(buf=, isSummary=0, pSI=0x000060800028f000) at xls.c:1395 [opt]
  • frame 1: 0x00000001104e5fa4 xls_summaryInfo(pWB=0x000060400011b1b0) at xls.c:1336 [opt]
  • frame 2: 0x00000001104fc476 -[DHxlsReader setWorkBook:](self=0x000060800027d9c0, _cmd=, wb=) at DHxlsReader.m:106 [opt]
  • frame 3: 0x00000001104fc342 +[DHxlsReader xlsReaderWithPath:](self=, _cmd=, filePath=) at DHxlsReader.m:75 [opt]

I followed the directions on the link posted, but I keep getting a "PBXCp Error." Any thoughts on how to fix this? It says "No such file or directory."

libDHxlsReaderIOS.a file not found and /Users/subhashkrjha/Desktop/DropBox/DHlibxls-master 2/DHxlsReaderIOS.xcodeproj Couldn't load DHxlsReaderIOS.xcodeproj because it is already opened from another project or workspace even though DHxlsReaderIOS.xcodeproj is closed.

DHxlsReaderIOS.build/Debug-iphonesimulator/DHxlsReaderIOS.build/Objects-normal/x86_64/ole.o

error: Build input file cannot be found: '/Users/guoxiaoliang/Downloads/DHlibxls-master/libxls/src/ole.c' (in target 'DHxlsReaderIOS' from project 'DHxlsReaderIOS')

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.

File: xlstool.c

Problem: asprinft is declared as static, but previous declaration (in stdio.h) is not static. In stdio.h is declared as:
int asprintf(char **, const char *, ...) __DARWIN_LDBL_COMPAT(asprintf) __printflike(2, 3);

But in xlstool.c is declared as:

 #if HAVE_ASPRINTF != 1

 #include <stdarg.h>

 static int asprintf(char **ret, const char *format, ...)
 {
 ...

Proposed fix: make it non static

I would like to use the DHlibxls, but I have some problem on how to include it in my project.

On README I found this:

Usage: include the enclosed project in your primary Xcode project. Ensure that there is a dependency on it in an Target that uses it. [It does not use categories so no need for "-forceload".]

What you mean with encloused project?
Do you mean only the DHxlsReaderIOS.xcodeproj? or the TestDHlibxls.xcodeproj?
What about the others files and folders?

Thanks

I cloned this repo and didn't modify anything, but it showed untracked files. Is it a redundant file?

I tried to see the file in Github, but it showed the error page. https://github.com/dhoerl/DHlibxls/tree/master/DHxlsReaderIOS.xcodeproj%A4xcuserdata/dhoerl.xcuserdatad/xcschemes

I have an excel file which contains dates in this format dd/mm/yy in its cells. Im trying to read and store them as strings but when I read the cell and output its contents it shows a weird number. For example:
18/02/14 is producing an output of 41682.0000
and in the very next line the same date 18/02/14 is being shown as 41688.0000

Everything else is being read properly. Any idea what's causing this?

Hi.
I'm struggling with this and trying to read an Excel file with accented chars (ISO-8859-1 chars), for an iOS App.

The chars are like these:
á, é, ñ, etc.

I've tried almost everything changing and tweaking the code. But as far as I understand, internally Excel (and libxls) is using UFT-8, but Cocoa's NSStrings are UTF-16. In the conversion, I always get nil. So when you try to read the contents of a cell and the String as one of these chars, boom! nil

I've been using the last version of your code, pulling libxls correctly from svn, etc. In the log window I can see:
CellType: cellString row=2 col=B/2
string: Espana

But if I change the content of the cell to "España", I obtain nil

The test file I've been using is here: http://dl.dropbox.com/u/1012348/test.xls

Can you please help me?

And, BTW: nice wrapper!

Is there a way to know the background/foreground colors of a cell?

If an Excel file has a table with any empty cells, DHXlsReader will stop reading and return end of file (it won't read any subsequent rows / columns in the table or anything else in the file). I can submit an example Excel file if someone can explain how to attach a file to an issue submission (it seems to only allow an image). I have attached an image of a file that fails. It will stop reading after encountering in blank cell in row 3 column 1.