After getting license key can we remove the evaluation sheet from the generated excel file?
Hi,
Well. sure, you need to set the valid license file (e.g Aspose.Cells.lic) in your codes before using any other APIs of the product, see the document for your complete reference for your needs:
Thank you.
This worksheet will always show as the active worksheet in the generated excel file using Aspose.Cells library. Only in licensed version, you can set the active worksheet to other worksheets. Moreover, you can't hide the Evaluation Copyright Warning (the extra worksheet) in the GridWeb control too, it will always be added (at the end in the worksheet tabs) in the contro l as shown in the figure below:
- This means Evaluation sheet will be still part of the excel file - even after license key is used.
Hi,
What do you mean by “license key is used”? We told you use the licensing code (as mentioned in the document/ article suggested) to specify the license file path using the APIs. Do you have license file (e.g Aspose.Cells.lic/ Aspose.Total.lic)? For your information, when you purchase the product, the license file is mailed to your email id (normally). The license file is a plain text XML file that contains details such as the product name, number of developers it is licensed to, subscription expiry date and so on etc. You need to set a license before utilizing Aspose.Cells if you want to avoid its evaluation limitation or if you need to remove the evaluation worksheet which would be always added to your output Excel file. It is only required to set a license once per application (or process). The license can be loaded from a file, stream or an embedded resource.
The easiest way to set a license in your code, is to put the license file in the same folder as that of Aspose.Cells.dll and specify just the file name without its path.
e.g
Sample code:
//Instantiate an instance of license and set the license file through its path
Aspose.Cells.License license = new Aspose.Cells.License();
license.SetLicense(“Aspose.Cells.lic”);
Let us know if you still have any confusion.
Thank you.
Dear Amjad Sahi,
We are in planning to buy a license of the Aspose.cells for .NET platform , but in your forum it is only mentioned that after license , we can only set the active sheet index to the other sheet than the evaluation sheet.This indicates output file still will have the evaluation sheet attached.
But our question was can we remove permanently the evaluation sheet in output file - if so kindly provide the code for the same.
Hope my issue of concern is clear to you.
Thank You.
Hi Poornima,
Thank you for writing back.
This is the evaluation restriction that whenever you save the results using Aspose.Cells APIs in evaluation mode (that is; without setting a valid license), the resultant file would contain an extra worksheet with evaluation warning. This worksheet will also be set as active so that when opened in MS Excel this evaluation worksheet would be the first to display. In evaluation mode, you can not alter this behavior nor you can remove the evaluation worksheet. Although, when you set a valid license before instantiating an object of Aspose.Cells APIs, there will not be an evaluation worksheet in the resultant file therefore you may set any worksheet as active in your code. Please note, by default, the first worksheet from the collection would be set as active when license is properly set.
Regarding your concerns, when you set the license using the simplest statements as shared in our previous posts, there will not be any evaluation worksheet so you do not need to remove it. We would recommend you again to check the following article in detail to know the evaluation limitations and how you can set the license in your application.
Moreover, if you wish to test the product without any limitations in order to check the behavior when valid license is properly set, we would recommend you to get a 30 day temporary license before actually purchasing a full license/subscription. Please follow the instructions provided on the below linked article to apply for a temporary license. Once your request is approved, we will send out the license via an email.
Please feel free to write back in case you still have any concerns or questions.
Thank you so much for your clear clarifications.
We will try with temporary license and any issues/concerns will be shared.
Thank you.
Hi,
Good to know that you understand now.
Also, we will enhance the statements in the Licensing document soon:
i.e., “…This worksheet will always show as the active worksheet in the generated excel file using Aspose.Cells library. Only in licensed version, you can set the active worksheet to other worksheets…“
to:
e.g
”…This worksheet will always show as the active worksheet in the generated excel file using Aspose.Cells library. Only in licensed version, you can set the active worksheet to other worksheets and there will be no evaluation worksheet…” etc.
Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.
Thank you.