2

Closed

EPPlus created files can't be viewed on iPhone / Blackberry

description

This is a great utility, it creates spreadsheets quite fast and easy but the versions it creates are not natively supported on iPhone or Blackberry. The files have to be opened with Excel 2007, saved, then sent to mobile devices.

Hoping the next version can be more compatible.

file attachments

Closed May 31, 2011 at 7:31 PM by
xslx generated in version 2.9 will open on IPhone. I have not blackberry to test with

comments

mcculla10 wrote Dec 27, 2010 at 7:35 PM

I found a work around, if I create a blank Excel 2007 file with an existing spreadsheet using Excel 2007 as the template, the iPhone seems to read the file just fine. It seems the error is in the ADDING of worksheets, but if you edit an existing worksheet you should be OK.

JanKallman wrote Jan 2, 2011 at 6:29 PM

This version is tested in Excel only.
I'll see if i can have a look at it. Which App are you using on the iPhone? Docs to go?

mcculla10 wrote Jan 4, 2011 at 1:08 PM

The built in iPhone spreadsheet viewer as well as the built in blackberry excel viewer. I did some file comparisons by opening up the .xlsx (convert to .zip and extract). There were some small discrepancies in the XML namespaces (EPP having namespaces while Excel not having namespaces). I'm really new to this component as well as OpenXML. I'll also open up a new work item regarding having a photo in the header / footer.

JanKallman wrote Jan 5, 2011 at 6:48 AM

I tried it on my iPhone and it is like you say, it just closes down with no error message. I'm not sure why. I'll see if I can fix it, but i'm not giving it the highest priority. Do you get any error message when you open it on the Blackberry? If you have the time to investigate, see if you can find out what part in the document that causes the problem.

mcculla10 wrote Jan 5, 2011 at 12:24 PM

These were some differences I immediately noticed as captured in the print screens.

These compared files were located in: xl\worksheets\sheet1.xml

JayPak wrote Jan 11, 2011 at 2:22 PM

I am also seeing the same behavior. My application is creating the files and attaching to an email. While they are viewable using Outlook on my PC - the same attachment is not viewable on my iphone. When I try to open the attachment on the phone, it attempts to open and then the mail app closes down. If I save the attachment from my PC email and THEN manually send the email out manually with the newly saved attachment, it works fine. FYI, on my local PC, I'm using Outlook 2010. While an unrelated app, from doing some research, it appears that Excel reports exported from SSRS have the same issue. I think this is probably a phone related problem? I'm going to try mcculla10's solution and see if I can get that to work.


In a somewhat related note, excel reports that are exported from SSRS appear to be having the same problem.

JayPak wrote Jan 13, 2011 at 6:23 PM

The fix that mcculla10 stated worked. I created a blank Excel file with 10 worksheets. My needs are such that a given workbook could have up to 10 worksheets in them. So I programmatically renamed them to what I needed and removed any extras. Worked like a charm.

cmnyc wrote Mar 9, 2011 at 3:14 AM

Hello, I'd be greatly appreciative if this could be addressed. I am experiencing this issue.

cmnyc wrote Mar 9, 2011 at 3:14 AM

Would greatly appreciate if this could be resolved...

JanKallman wrote Mar 11, 2011 at 7:08 AM

I have added a fix for this in the latest source (trunk). Tried it on my IPhone. The problem was that the relationships between parts had absolute URI's and the IPhone could'nt for some reason handle that. I have no Blackberry to trie it on so please give me some feedback if it works.