EasyXLS
http://forum.easyxls.com/

Can't Upload a XLSX File
http://forum.easyxls.com/viewtopic.php?f=4&t=1173		 Page 1 of 1
Author:  dzyann [ Mon May 11, 2009 6:01 pm ]
Post subject:  Can't Upload a XLSX File
Hi,

I am new in this forum as with EasyXLS.

I am having an issue trying to read an XLSX file. The code i am using was developed before I arrived to the project, and can have some problems, and noone knows if it ever worked. Now i checked on the tutorials, and it seems it should work. Probably i am missing something, but i don't really know what it is. I would really appreciate if you could help me with this issue.

The application should allow upload files from XLS or XLSX, so the code that reads the data from the excel is something like (the file was previously uploaded with a fileuploader):

Code:
public DataSet GetExcelData(byte[] xlsStream)
        {
            ExcelDocument xls = new ExcelDocument();
            DataSet ds = new DataSet();

            //Load the excel into the DataSet
            if ((xls.easy_LoadXLSFile(new MemoryStream(xlsStream))) || (xls.easy_LoadXLSXFile(new MemoryStream(xlsStream))))
            {
                /*Does something*/
            }
            else
            {
                return null;
            }

            return ds;
        }


The problem is that for XLS files is working perfectly. But for XLSX is not working at all, it always returns false.

Now i would assume the previous developer tested the application for both excel versions and it worked for him. But the only difference I have with his environment, is the version of EasyXLS. He was using the v6.1, and i am using the EasyXLS Reader for .Net - Developer Edition v6.3.

Can anyone help me with this?

Thanks.-
Author:  oana [ Tue May 12, 2009 5:50 am ]
Post subject:  Can't Upload a XLSX File
Hi,

ExcelDocument.easy_LoadXLSFile method is working with memory stream but ExcelDocument.easy_LoadXLSXFile is not, because EasyXLS needs the HDD to extract the archive of xlsx file.
Author:  dzyann [ Tue May 12, 2009 8:31 am ]
Post subject: 
Hi Oana, thanks for answering me.

I am sorry but i don't really quite understand your answer. You mean that there is not available a method that could extract from memory the XLSX file? I checked the documentation and saw there was 2 implementations for upload an excel, both for XLS files and XLSX files. So i wouldn't know why it would work for XLS and not for XLSX.

The implementations i am talking about are:
For XLS:
-public bool easy_LoadXLSFile(System.IO.Stream f)
-public bool easy_LoadXLSFile(System.String sPath)

For XLSX:
-public bool easy_LoadXLSXFile(System.IO.Stream f)
-public bool easy_LoadXLSXFile(System.String sPath)

So i see that for loading XLS and XLSX are available 2 ways, and i dont understand why it would work for XLS and not for XLSX.

Maybe i understood you wrong?

Regards.-
Author:  oana [ Wed May 13, 2009 4:21 am ]
Post subject:  Can't Upload a XLSX File
Hi,

For ExcelDocument.easy_LoadXLSFile(System.IO.Stream f), System.IO.Stream can be any stream.

For ExcelDocument.easy_LoadXLSXFile(System.IO.Stream f), System.IO.Stream has to be a stream that points to a file on the HDD because EasyXLS needs the HDD to extract the archive of xlsx file.
Author:  dzyann [ Wed May 20, 2009 2:49 pm ]
Post subject: 
Thanks Oana for your answer.

I have tested diferent aproachs, and finaly found one that works. The
tried to use a FileStream, but it wouldn't work either.

Just the overload that receives a file path worked, after that had a minor problem that i could solve with the information on a thread of this forum,
wich was curious because it wouldnt happen when exporting from a excel of older versions.

Is just not clear for me, why would be this the only aproach that worked, and why there doesn't seem to be anything related to what you mentioned in the documentation about that method.

Thanks for your answers again!

Regards.-
Author:  dzyann [ Tue Jun 02, 2009 4:43 pm ]
Post subject: 
Hi Again.

This issue after the solution i found was posponed in my project because we did not like it.

We have been doing further analysis, and found that each time we were reading an XLSX file, the method "xls.easy_getError()", had this error:
"Access to the path 'C:\WINDOWS\system32\EasyXLS_633795635597208236' is denied.

Invalid file format!"

We did not know well what to do, so just for trying, we copied the EasyXLS.dll to the system32 folder.
But after testing the method had still the same error. So we gave permisions to everyone (just for the sake of testing) in system32, and found that now our code was working perfectly.

We would like to know why is that for this method we need to copy the DLL in that folder and not when we are uploading a 2003 excel file. Are we configuring something wrong?


Regards.-
Author:  daniela [ Wed Jun 03, 2009 8:14 am ]
Post subject: 
The xls file format is a binary format.

The xlsx file format is basically a zip file. EasyXLS needs a place to extract the archive. In case that no path was supplied, as a MemoryStream, EasyXLS uses the Environment.CurrentDirectory to extract the files. In your case this application variable is set to 'C:\WINDOWS\system32'. The access on this folder is forbidden.

So for xls files the files is read directly from the MemoryStream, but for xlsx the file from the MemoryStream is extracted on HDD.

This is why it works for xls files and does not work for xlsx files.

I hope this will help you to find a workaround in your case.
Author:  dzyann [ Wed Jun 03, 2009 8:40 am ]
Post subject: 
Hi Daniela,

Thanks for your answer! Now all makes more sense. Was kinda confusing before. And when I would look info for that method i wouldn't find anything related to what you mentioned.

Thanks for you help!

Regards.-
Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/