Thanks for your posting and using Aspose.Cells.
Please share your sample code and also your sample expected output excel file. You can create expected output excel file manually using Microsoft Excel. Please provide the simplest excel file which serves the purpose so that we could focus on the main issue. We will then look into it and provide you a sample code to achieve your expected excel file which you can then later incorporate into your main code. Thanks for your cooperation.