Hi,
Thanks for your query.
Well, you may not need to change your existing code much as you are using simple / basic features, although you have to update your existing code a bit. For your information, in the new versions, we have re-organized API structure (we have added some new namespaces and move the relevant APIs to them to make it more compact and organized)
Also, we have renamed some APIs (regarding collection classes) e.g Validations class now becomes ValidationCollection, similarly, Worksheets class becomes WorksheetCollection, etc., There are quite a few other examples too. For a complete reference, please see the Aspose. Cells. Documentation and its API Reference:
Now let me come towards your significant change in your existing code for formattings that you have to update your code a bit accordingly:
1) Aspose.Cells.Style property is eliminated/obsoleted now, you should adjust your code to use Aspose.Cells.GetStyle() and Aspose.Cells.SetStyle() methods, it will also enhance your performance to a certain extent:
e.g
Your sample code using Style attribute should be updated accordingly, e.g
Style style = wsNdaa.Cells[0, 0].GetStyle(); // here wsNdaa is worksheet object
style.Font.IsBold = true;
wsNdaa.Cells[0, 0].SetStyle(style);
Styyle style2 = cells["I1"].GetStyle();
style2.HorizontalAlignment = TextAlignmentType.Center;
style2.BackgroundColor = System.Drawing.Color.Navy;
style2.Font.IsBold = true;
cells["I1"].SetStyle(style2);
For a complete reference, please see the documentation in the relevant sections:
2) Workbook.Open method is obsoleted and you should now use Workbook constructor instead, see the sample code line below:
Sample code:
Workbook wb = new Workbook ("e:\\test2\\Book1.xlsx");
Hopefully, now adjusting your code segments accordingly, everything would be fine.
Let us know if you need further help.
Thanks