Excel file size inceases on applying styles using EPPlus in c#

Question

2.00/5 (1 vote)

See more:

I am exporting a datatable to an excel file using EPPlus and the applying styles for some range of cells before exporting.Because of the styles, the file size increases drastically to 5 MB. When I export the same without applying any styles its size is 400 kb. What is the problem?? and what is its solution?

Posted 29-Jul-13 17:55pm

Ambika Jadhav

Updated 29-Jul-13 23:17pm

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 30-Jul-13 1:25am

Not enough information...
—SA

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

The_Inventor · Answer 1 · 2013-07-30T21:35:00

The problem is that you are 'embedding' the styles from the EEPlus. These FONT FILES are not located with the FONT FILES in the C:\Windows\system or C:\Windows\System32 locations for fonts. It may be that the style fonts provided by EEPlus are proprietary, and need to be embedded in order for them to be displayed at all. If you can load/apply the style files prior to loading (like in a batch file of some sorts) the actual excel workbook file, then your file will be smaller, or if someone else needs to see them, then install them (style files and any supporting DLLs) on the system where the excel file is going.

Sergey Alexandrovich Kryukov · Answer 2 · 2013-07-29T19:29:00

Not enough information to answer this somewhat vague question. You can research the problem if your Excel supports *.xlsx files. This format is XML based and packed using ZIP algorithm. So, you can unpack the files (for this purpose, you may need to rename "*.xlsx" to "*.zip") and study and compare their content. You can use, in particular, XML viewers of Visual Studio or any other, some file comparison tools, etc.

—SA

Excel file size inceases on applying styles using EPPlus in c#

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0