Skip to Content (Press Enter)
UserImage.jpg
Sagar Nannaware
800Views
6Comments
[Advanced Excel] Support for .xls file
Question
Forge
advanced-excel
Service icon
Advanced Excel (O11)
Forge asset by Carlos Freitas
Hi,

I am using this component and it is working perfect for 2007/2010's file format ie xlsx file. It is very useful component, but it is not supporting xls file format. It returns error as,
"Can not open the package. Package is an OLE compound document. If this is an encrypted package, please supply the password"

Is there any way to include xls file format too? Except "Save As" option. :)

Or can you please suggest another component which can support both xls and xlsx file formats?


Regards,
Sagar S. Nannaware
0
0
30 May 2013
Copy Link
2011-06-15 10-50-44
Stephan Schevers
Hi Sagar,

You can create your own extension based on https://npoi.codeplex.com/. This component supports xls, xlsx and docx. Hope this helps

regards,

Stephan Schevers
1
0
31 May 2013
Copy Link
UserImage.jpg
Sandhya Gidda

Hi Stephan,

Creating own extension based on NPOI means do we need to create .Net application using NPOI component,perform the logic to import excel and then use .Net application as an extension in outsystems?


Thanks,

Sandhya.

0
0
02 Sep 2016
Copy Link
2011-06-15 10-50-44
Stephan Schevers

Sandhya,


With Integration studio( and visual studio) you can create your own .net extensions which can be used in the platform. Have a look at the Advanced Excel  and check which methodes are implemented. Create your own extension and try to port the methods to a npoi implementation.


regards,


Stephan Schevers

0
0
02 Sep 2016
Copy Link
UserImage.jpg
Sandhya Gidda

Thanks Stephan.

If it is possible,could you please me a sample application of using NPOI and Advanced Excel which will be a great help for me?


Many Thanks,

Sandhya.

0
0
05 Sep 2016
Copy Link
2011-06-15 10-50-44
Stephan Schevers

Hi Sandhya,


Sorry don't have any sample application of NPOI. Take a look at https://npoi.codeplex.com/documentation for some sampes. Google is most of the your biggest in finding samples. Download the Advanced Excel extension and open with integration studio to have a look how it's implementend.


regards,


Stephan

0
0
06 Sep 2016
Copy Link
UserImage.jpg
Sandhya Gidda

Thanks Stephan. I will try in the way you explained.


Regards,

Sandhya.

0
0
06 Sep 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.