All,
I have a project where I am using an existing template, pulling data into worksheets, and refreshing pivots. I have several Active X Combo boxes that I need to fill with lists stored on a separate spreadsheet (these lists will vary in row count from refresh to refresh). My question is how to I set the list fill range using the Aspose.Cells library?
Thanks in advance!
Also, Haley was kind enough to help me out and post this for me, as I am unable to post and am getting the following message when I try:
I read the FAQ “How to send your license file to an Aspose staff member?”. It does not seem to apply to my circumstance. Any assistance in this matter would also be appreciated!
Thank you!
This message was posted using Email2Forum by haley.stuart.
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
You cannot access or manipulate ActiveX controls inside the workbook using Aspose.Cells API(s).
However you can work with Workbook Drawing Controls, if that could fit your needs.
Please see this article how to work with drawing controls inside a workbook.
You can try the Evaluation version of Aspose.Cells for your needs, evaluation version works exactly same as License version except it creates an extra worksheet.
Also, could you attach your sample source (xls/xlsx) file and the sample output (xls/xlsx) files and screenshots to illustrate your problem. You can create them manually using Ms-Excel and Ms-Paint.
If you have some more questions or need some help relating to Aspose.Cells API(s), please feel free to post, we will help you asap.