I'm just starting out looking at ASPOSE.CELLS as a solution to a problem I'm having and before I get started I want ot know if it can create a true .XLS or .XLSX file i.e. one that is not just an XML file renamed to .XLS.
My problem is that my client has a requirement to create spreadsheets from data stored in SQL Serer database via a web interface. Have their users make changes to the spreadsheets then load their contents back to the database.
We have tried the following;
Utilising OLEDB to write data to preexisting excel workbooks, this fails to suit because the data written is all text (i.e. numbers as text) and some large numbers are converted to scientific notation.
Utilising COM INTEROP, fails because it doesn't really work on a server based environment.
Creating teh spreadsheets by writing the XML, works brilliantly except out standard method of loading data from excel is via OLEDB which fails to process the spreadsheet when it is of the XML format.
I have some other solutions that I know will work but I'd rather get a component to do the work for me. So I'm looking for a component that can run as part of a .net web application serverside on Windows Server 2008 64bit and that can create TRUE .XLS or .XLSX files.
Does Aspons.Cells meet these requirements?