I was wandering if it were possible to have a server, with .cells running, that offers a web service.
Antoher app can pass an xml with data and a xslt with formatting (i have no idea if this is the correct way of passing formatting to excel or .cells), and the service responds with an excel with the formatting applied.
Is this possible without any "click here to do something" interaction from the user ?
I was wandering if it were possible to have a server, with .cells running, that offers a web service.
Antoher app can pass an xml with data and a xslt with formatting (i have no idea if this is the correct way of passing formatting to excel or .cells), and the service responds with an excel with the formatting applied.
Sure you can use Aspose.Cells in a web service. Some users have already done this.
For passing data, I think a SpreadsheetML file will be better. Aspose.Cells supports to import/export SpreadsheetML files but xml/xslt is not directly supported yet.
Is this possible without any "click here to do something" interaction from the user ?
I am not sure about your needs. Could you please elaborate your scenarios?
3. This server calls a web service hosted on another server. This web server accepts the xml data and populate it into an Excel file. Then it returns the output file to the first server.
4. The first server sends the output file to client.
If yes, I think Aspose.Cells can serve your need well.
When you download and install Aspose.Cells, you can see the demos source code. And you can check Aspose.Cells for more information.
Aspose.Cells creates Excel file without utilizing MS Excel, so you don't need to install MS Excel on your servers. For office 12 Excel service, I think you may have to install MS Excel on your servers.
Why choose Aspose instead of Excel automation: WhyNotAutomation.