Aspose Cell for integration with post TFS build tasks

Aspose.Cells Product Family
1

Hi all,

Currently I am looking at Aspose.Cells as a technology to be able to read Excel workbooks as a data source for test cases to be run as post build task. For each test case, the Excel workbooks will be copied into a separate output directory per test case run.

Could you please provide further detail on how Aspose.Cells handles concurrent processes trying access the Excel workbook file.

What type of locking will be used while the file is being accessed?

This is a concern especially noting that it will be used as part of a process run as a post build task.

Kind regards,

Marcus

2

Hi,


Thanks for your query.

Well, Aspose.Cells is a pure .NET component created in managed C#, so , concurrency and multithreading is not a problem by any means. For your information, as long as you don’t have shared data source and every time a user access a new Workbook or Excel file in different threads, there would be no problem at all. However, if you have a shared data/resource or the same Excel file/ workbook, then you will have to do synchronization by yourself. Also, in that case, we recommend you to create/manipulate of filling data into different workbooks and calculate formulas for different spreadsheets in different threads accordingly, because, you should not use one workbook/file in multiple threads at the same time least you would not get stable data ( FYI, there is global shared data/ resources in Excel file spreadsheets, so knowing the nature of the Excel file formats, you should not share a workbook in multiple threads), I am afraid.

Thank you.