File saving from CreateOpenXmlReader

Feb 10, 2010 at 1:24 PM
Edited Feb 10, 2010 at 1:29 PM

Hi,

I have a question/observation regarding how it appears the CreateOpenXmlReader method works.

From what I've seen in the source code the content of the sheets is saved (for xlsx files) in the temporary files.

Was this necesary?

Is this likely to be changed in the future?

My primary concern is that I was planning to use this component for reading uploaded excel files on the web app and I didn't want any files saved on the server.

Cheers

Ivan

Apr 13, 2010 at 2:41 PM

This maybe due to ZipWorker.

Regards, Tasos

Apr 13, 2010 at 3:19 PM

xlsx files are a zipped set of mostly xml files. Which appears to be the reason for using the ICSharpCode.SharpZipLib library. ZipWorker knows how to use the unzipped files (in their folder structures).

The problem I have is that it looks like the clean-up code doesn't have the expected result -> no clean-up...

 

Apr 13, 2010 at 3:26 PM

Interestingly, the clean-up now works! :-/

(After I have removed the many existing TMP_Z temporary folders, I haven't seen anymore being left again.)

 

Apr 13, 2010 at 3:35 PM

Thanks for your replies Tasos. It is good to know the xslx files are working now. I will try to test it tomorrow.

Regards, Ivan