Looking to purchase ASPOSE.cells- have some questions

Aspose.Cells Product Family
1

Hi all,

We're currently building a .NET application and one feature we'd really like to implement is allowing users to bulk upload large sets of data to our microsoft sql 2005 database. Currently, .NET can do this, but the spreadsheet (excel) must follow a strict format where the first row is the headings, and the data is contained in the cells directly below.

We would like our users to retain the format of their spreadsheets, and not have to change to this strict format. We'd like our application to show the user what data the databases need, and allow the user to specify the starting cell to match the data columns in their spreadsheet to what the application is looking for, for the database.

Can apsose.cells accomplish this alone? If yes, how easy is the implementation?

Thank you in advance,

etb

2

Hi,

Thanks for your inquiry.

Well, Aspose.Cells for .NET is pure .NET library which is used to manage spreadsheets. The component performs the tasks in the background, it does not provide any interface to which the user can interact. The library can import/export data to and from the data sources e.g.., DataSet, DataTable, DataView, Array etc. So, if you want to export data to SQL Server database (without providing any grid matrix interface), you may use Cells.ExportDataTable() method to fill a datatable and later use ADO.NET APIs to update your SQL Server database. Check the docs for reference: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/exporting-data-from-worksheets.html and http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/importing-data-to-worksheets.html

We would like our users to retain the format of their spreadsheets, and not have to change to this strict format. We'd like our application to show the user what data the databases need, and allow the user to specify the starting cell to match the data columns in their spreadsheet to what the application is looking for, for the database.

If you want to provide some means for the users like graphical display/env. you may utilize our grid control .........original package is Aspose.Grid, which includes two controls i.e. Aspose.Grid.Web and Aspose.Grid.Desktop) is a GUI control that provides MS Excel like environment in WYSIWYG manner for desktop and web applications, you may easily place it on a winform / webpage (.aspx webform). It has its own grid matrix and has its own formula calculation engine to calculate all types of formulas at runtime. It can load existing excel files to the grid matrix (cells in rows/columns) or even bind data from some data source like MS Access / Sql Server database and can also save output files to disk / update the data source directly in WYSIWYG manner. It allows in such a way that a user can design its own spreadsheet with all the style formattings of his need too. For ref, please check the Aspose.Grid.Web featured demos: http://www.aspose.com/Products/Aspose.Grid/Demos/ and check the Data Binding demos especially, the demos (both Aspose.Grid.Desktop and Aspose.Grid.Web demos) get automatically installed on your machine when you use control's MSI installer, so you may open the solutions into VS.NET and check the source codes. Please check the docs for further ref: http://www.aspose.com/documentation/visual-components/aspose.grid-for-.net/index.html

Thank you.