I've a requirement to create a xsl file based on the list data. I can't use the default way to export list items into a excel file. I was testing the NPOI api but in my Visual web part it is not working...

Error message when debbuging:

the type or namespace HSSFWorkbook is not valid in this scope

Can someone help me on this? Any other API I can use?

  • Do you mean you don't want to use owssver dll? Feb 25 '15 at 14:05
  • yes I do. The client want a file with a different format. The file will have some tabs to show the data for each list. (Tab1,Tab2,Tab3...)
    – leonardo
    Feb 25 '15 at 14:09
  • Even though I haven't worked on it, but you are using Sandbox solution which are very restrictive. Do you see same error if you create a farm based solution? Feb 25 '15 at 14:15
  • I have not tested this, but the API worked well in a Console application...
    – leonardo
    Feb 25 '15 at 14:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.