Hi Aspose Team,
could you please help me on this GridWeb, i have an single excel file
with 10 sheets..i need to bind the single sheet (Say Sheet5) in GridWeb
when importing the ImprotExcelFile method in page load...but 10 tabs
sheet name should display below on the screen. when i click on each tab
its should bind the data according to the sheets in the GridWeb.
Is this possible in this tool....Can u plase advice on this..?
Thanks for using Aspose.Cells for GridWeb.
Well, this feature is not supported by the component. When you will import the workbook using ImportExcelFile() method, it will load the entire workbook with all the worksheets.
However, as a workaround, you should use Aspose.Cells alongwith Aspose.Cells for GridWeb.
You should import the data into a dataset/datatable and then bind the dataset/datatable with your grid. It might not fulfill your needs completely but might help you to find some workaround.
Please see the Databinding GridWeb demos from the following link.
Please also download and use the latest version:
for GridWeb v22.214.171.1241
1 , In My Excel file having Macros and VBA Code script...when i
import this excel file to gridweb, Macros and VBA code in excel are not
getting reflected inside the GridWeb Excel. Can u advice on this Pls.
I am afraid, this feature is not supported by both Aspose.Cells and Aspose.Cells.GridWeb. Both of them cannot execute or modify the Macros and VBA Code script.
2. In GridWeb after importing my excel file if i change the values in
cell A1 as value 66 simultaneously in B1 cell values 66 should be
displayed or updated in the same worksheet. Can u pls give some
suggestion on this two quries.
Well, Aspose.Cells for GridWeb will not automatically calculate your values. You will have to manually press the tick button or you will have to submit the gridweb data via postback to make it calculated.
You can choose to do full postback or you can do a partial postback using Ajax.
After postback you will call the following method to run all the formulas.C#