I have the following questions regarding things I've seen with Apose.Cells:
1) I'm saving a file with 65000 Rows by ~49 columns. The resulting file size is about 41,944KB which isn't too bad. However, I opened the file in Excel and performed a save as and noticed that the file size dropped to 26,754KB. Is this because I have a large number of blank cells in the spreadsheet? I have a sample file that I can send with some scrubbed data, but prefer to post that privately.
2) Regarding memory usage. While producing the file mentioned in item 1, I noticed that the memory usage displayed in the task manager shoots up roughly 200 to 300 MB and doesn't release even after I set my excel object and sheets object to nothing. In fact, the only time it seems to release is when I call the .ImportFromDataReader the next time through the process. Is this normal? or is this a .net garbage collector problem?
Thank you for your assistance,