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?
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.
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?
Sorry don't have any sample application of NPOI. Take a look at http://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.
Thanks Stephan. I will try in the way you explained.