Open a XLS at Sharepoint List

Posted by: christosk on 8 September 2017, 10:26 am EST

  • Posted 8 September 2017, 10:26 am EST

    Hello,

    I would like to show (just show) an xls in a sharepoint page.

    I managed to make a web part.

    I can show a xls located on the disk, yet, when I try to open an xls from a sharepoint list (openexcel()) I get the error:

     <b>URI formats are not supported </b>

     Any workarounds?

    Also, is there a white paper for howto make a web part out of spread for ASP.NET

     

     

  • Replied 8 September 2017, 10:26 am EST

    Hello,


    We do not have a White Paper on making a web part from our Spread product. We sell a seperate product that is a Web Part that is fully integrated with SharePoint.


    The OpenExcel method requires to load the Excel file from a hard coded path on the server or from a stream. You can not pass in a URI address to load the Excel file.

  • Replied 8 September 2017, 10:26 am EST

    Spread for sharepoint is used for a list - I'm interested in showing an actual XLS file which resides on a document library in sharepoint.

    We tried to use  a  stream as an intermediator, yet we got the error: this stream doesnot support seek operations.

    We tried using a memoryStream (see attached file), and we got a error attempting to read after the end of stream

     Do you have a project showing how to use stream is an input to spread?

    We are evaluating Spread for our website and we don't have an actual physical path for our files - everything reside on document libraries.

    Thanks

     Christos


    2008/11/New Text Document.txt
  • Replied 8 September 2017, 10:26 am EST

    Christos,


    Your code for reading a file into a stream was correct except you need to reset the Position property of the MemoryStream back to 0 before feeding it into the OpenExcel method.

  • Replied 13 October 2020, 9:41 pm EST

    We can open SharePoint list from Excel directly by: Open Excel > Data tab on the ribbon > From Web > Type list URL in Address bar > Go > Select Arrow icon which holds the list table > Import > select an area in excel worksheet > OK.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels