So far we have been successful implementing Aspose.Cells with SSIS, but we are running into an issue.
It seems like the tools read the value displayed in the cell (1.04), not the actual value displayed on the formula bar (1.04000003)… is there a way to fix this?
It is good to know that you were able to sort out this issue. If you encounter any other issue, please feel free to post on our forums, we will be glad to help you further.
Thanks for your posting and using Aspose.Cells for .NET.
There is no size limitation. The larger the Excel file, larger the resources it will take during processing. Since, your file is large, it will take more memory and time. You should have sufficient memory to process the large file.
We are now running our tests and we are getting a weird one and I do not understand why.
My solution processes around 200 Excel files in one run… around the file number 100, the solution throws an exception: Exception has been thrown by the target of an invocation.
The code runs just fine and we have tested different Excel files and they seem to be processed correctly.
Which leaves me with the only logical option: do you think this might be related to LICENSING?
When you use the product in evaluation mode (without using/setting valid license in your codes), you can only open/process 100 files at one time. When you exceed this limitation, an exception would be thrown.
I think you may ask for 30 days temporary license, please follow the directions provided here.