Creating Excel File

Question

Well, I didn't find any libs to create Excel file in Windows Phone 7 and the default libs for Excel are not working because they weren't compile for it.

Does any of you guys know how to do this?

I really doubt you can do this. Can't you use a web service layer and have the heavy work done on the server? If so, in the server, you can surely use the OpenXML SDK to handle office files. — Davide Piras
– Davide Piras, Commented Jan 16, 2012 at 12:58
if your file is simple enough you could go for a csv file instead of a full fledged excel sheet — thumbmunkeys
– thumbmunkeys, Commented Jan 16, 2012 at 13:00
I was trying to avoid any online operation, and unfortunatelly it's my sheet isn't tha simple =/ I hope someone come up with a solution. — Andre Mariano
– Andre Mariano, Commented Jan 16, 2012 at 13:02
You could get the EPPlus source code and try to compile it for WP7... — Nuffin
– Nuffin, Commented Jan 16, 2012 at 13:12

Mark Ransom · Accepted Answer · 2012-01-16 16:15:03Z

3

Excel is able to open many different kinds of files beyond the .xls or .xlsx. Most common is CSV; it's dead simple but not very capable, and I would avoid it for all but the simplest applications.

A format I've used successfully is the Symbolic Link (SYLK) format. The .slk files open directly in Excel, and you can include cell formatting and formulas. It's easy to save out a file from Excel itself and use it as a template for creating your own files.

answered Jan 16, 2012 at 16:15

Mark Ransom

310k44 gold badges423 silver badges660 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Joey Over a year ago

SYLK doesn't support Unicode, though, which probably makes it a poor choice nowadays.

Andre Mariano Over a year ago

Thats a good solution for my case, because I'm writing for only one country. Thanks

Mark Ransom Over a year ago

@Joey, I just tried it - when Excel 2010 wrote out the file it substituted a ? for the Unicode π. Unfortunately you're right. I don't know how it would treat UTF-8 in the input but I expect it fares just as badly.

Richard Szalay · Accepted Answer · 2012-01-16 14:58:08Z

0

You're going to struggle to find a library to do this simply because WP (as of 7.1) doesn't include the System.IO.Packaging namespace, which most libraries will depend on to read/write docx/xlsx/etc files.

answered Jan 16, 2012 at 14:58

Richard Szalay

85.1k19 gold badges186 silver badges242 bronze badges

Collectives™ on Stack Overflow

Creating Excel File

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related