We are currently working on an application that has been using COM Interop in C# to import data into an Excel workbook. This data is fairly complex and lengthy, so we have been using the Import from XML feature in Excel. Because of the issues with running Excel on a server, we are now looking into moving to a 3rd-party solution for our workbook creation, such as SpreadsheetGear or Aspose.
SpreadsheetGear and Aspose do not support XML Import. Does anyone know of another 3rd-party, server-friendly tool that does?
--Edit-- The data is coming from an DB2 database that we are putting into C# classes and then serializing into XML. We are then importing the XML into around 30 tables and other cells. Then we copy and paste the tables to an output sheet and reuse the originals to import more.
--Edit-- The output is a form with multiple tables and fields on one sheet. Part of what the XML map helps with is keeping track of the locations of the cells, without having to massively hard-code cell-coordinates into the code.
Although I have not found a 3rd party tool that allows this functionality, Aspose.Cells has a "Smart Marker" feature that allows you to designate specific cells in a way similar to an XML map. I believe this may be the solution I have been looking for.