Excel created with EPPlus having no data but large size

1
votes

I am using EPPlus open source tool for creating / editing excel files on server. When I insert data to excel created by EPPlus by opening it using C# .net code some time size of files gets increase upto 8-10Mb. If I copy all content in MS Excel from that file and save it then it is of only 20 kb.

What should be the actual cause behind increasing excel file size created by EPPlus

1
c#.netexport-to-excelepplus
How much data are you inserting? When you open the sheet with Excel do you see the expected data? Is it a xls or xlsx file? – Tarik
What do you do when inserting data? code? – Leon
No not fix value of insertion some time single record some time 20-30 records – Prasad Joshi
I upload excel & copy-paste content from cell to cell – Prasad Joshi
@edTarik Data is very much important... – Prasad Joshi

1 Answers

0
votes

It was due to unreadable content generated in excel it self. When I used new release of EPPlus (4.1.0) I have not get any problem like this.