I am using 7.5.1.4 version of Aspose and have two questions below:
1. Is it possible to import data table into .net application in a dataset ot datagrid and update that data table or data set and again export into that same cell range?
For example I want to fetch data from AI1:AL4 into a datatable or grid and then update some values and then export it into the same range.
Will this work if the cell is formulated cell?
2. is it possible to run a macro button through Aspose.cell from my .Net application?
3. Can Aspose apply a filter in header which is placed anywhere in a sheet for example header range is C1:C5?
Is these feature available in latest version ASPOSE version ?
Well, you can export data from a Worksheet range to fill a DataTable, arrays etc. To bind the dataset/DataTable with .NET DataGrid control, you have to write your own code. Furthermore, Aspose.Cells does not support data binding so the data imported from worksheet to DataTable/DataGrid, would not be connected. I think for your needs, you got to first export data to fill a DataTable/DataSet via Aspose.Cells APIs and bind with DataGrid control, now update the DataTable/DataGrid with data via your own .NET APIs, now you will import data from final (updated) DataTable to Excel worksheet cells/range via Aspose.Cells APIs. Please see the document on different data importing and exporting options Aspose.Cells APIs provide for your reference:
By the way, if you need to have visual Excel like environment for display/editing spreadsheets directly, we provide separate grid (Desktop and Web based grid controls) suite which supports data binding feature, see the documents in the section for your reference:
I am afraid, Aspose.Cells API does not support running or executing macros/ vba code, it only supports to create or manipulate macros/vba codes at the moment.
Aspose.Cells does support data filtering feature, see the document for your reference:
My requirement is to embed one worksheet of a excel template(template contains several worksheets), which is containing formulated cells into the UI and user can work real time excel and then update the worksheet into the server.
Is the dll Aspose.Cells.GridWeb.dll present in the ASPOSE version 7.5.1?
Well, I think Aspose.Cells.GridWeb can suit your needs, so you may try it. And, yes, Aspose.Cells.GridWeb.Dll (v2.7,20,xxxx) file is there in “\net2.0” folder @ your installation directory (if you have installed Aspose.Cells for .NET v7.5.1). Moreover, if you don’t have this version with you, I am afraid, we cannot provide it for you. In fact we cannot provide any version of Aspose APIs which is older than one year or so. So, if you don’t have your required version with you, we can only recommend you to kindly upgrade to and use latest version of Aspose.Cells for .NET v8.8.1.
Thanks for the information. I can see the respective Dll in the folder and included in my project.
Can you provide sample code for binding a specific worksheet which have some formulated cell and have different datatype like integer boolean and also containing some formulas.
I am attaching an example in which the we have to bind a specific sheet and display that sheet into the UI using gridWeb(other tabs can be hidden) and edited some values real time and save it back to server?
As I said earlier, you may try to use grid suite (Desktop and Web based grid controls) which supports data binding feature, see the documents/ articles in the section on how to use/implement DataBinding feature in GridWeb control for your reference here:
I am trying to load a xlsb file and trying to import into the GridWeb control.It is showing an System.OutOfMemoryExceptionexception with both the option . My xlsb file is containing 29 sheets(550KB file).
Are you using older version of Aspose.Cells.GridWeb (e.g 2.7.20.xxxx) (from Aspose.Cells for .NET v7.5.1 package)? Well, I am afraid, we might not evaluate your issue using older version of GridWeb, nor we can help you to sort out your issue in older version for importing your Excel file into Aspose.Cells.GridWeb. We can only suggest you to kindly upgrade and use latest version of Aspose.Cells.GridWeb v8.8.1 (you may install Aspose.Cells for .NET v8.8.1 package using its MSI installer to get the latest version of Aspose.Cells.GridWeb control) to import your XLSB file into its grid matrix. If you still find the issue, kindly provide us your template XLSB file here, we will check it soon.