How to export results in aspx sheet to Excel without installing Excel on server?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RajeshPune
    New Member
    • Sep 2010
    • 2

    How to export results in aspx sheet to Excel without installing Excel on server?

    We are deveopingawebis te in asp.net. There are tempelates of each aspx page made in the form of excel sheet. Upon completion of the online calculation, the user is to be allowed to export the results to excel and save them. There would be obviously no formulae in such sheet
    I do not want to install Excel on theserver and instead want to utilize the Excel installed on the user's computer for this purpose as every user's computer is expected to have Excel installed. Is this possible to do? How to do this?
    I am not an expert in this. so please let me know if you would need any more information or clarification.
    Thanks in advance.
  • Frinavale
    Recognized Expert Expert
    • Oct 2006
    • 9749

    #2
    If the server has to do a process that involves using Excel, than Excel must be installed on the server or else you won't have access to the necessary components to do the process.

    -Frinny

    Comment

    • ZiadElmalki
      New Member
      • Sep 2010
      • 43

      #3
      Excel 2003 introduced XML file format for excel files called SpreadSheetML. You can create an XSLT that generates the Excel file without word being installed.

      Bing/Google Excel and XSLT and you will find tons of examples on the internet. You do the xslt on the server and give the user the file.

      Another option is using the OLEDB jet provider on the server. You can read and write to excel files in SQLish way with out Excel being installed.

      Excel is exposed via COM which javascript supports so I don't see why you could not do client side. In fact I found some examples on the internet.

      Real's HowTo : Useful code snippets for Java, JS, PB and more


      This is NOT recommended though. The best approach would be to do use an XSLT server side and require the users have at least excel 2003.

      There is DCOM also that will let you use Excel hosted on another machine. This also is strongly NOT recommended.

      Comment

      Working...