Thanks for your posting and using Aspose.Cells.
Actually, the values 1112 entered in cells A4, A7 etc are strings not numbers, therefore even if you will format them as number, they will not change. You should convert these strings into numbers so that formatting could be applied.
Please see the following sample code. It reads your Asset+overview.xlsx file and convert string values to numeric values. I have attached the output xlsx file for your reference. As you can see in the output file, all values 1112 have been formatted as 1,112.
string filePath = @“F:\Shak-Data-RW\Downloads\Asset+overview.xlsx”;
Workbook workbook = new Workbook(filePath);
Worksheet worksheet = workbook.Worksheets;
Similarly, if you will enter some numeric value as a string, it will not be formatted as number.
now 1234 will be entered as string and formatting will not be applied on it.
But, if you enter it like Cell.PutValue("1234", true);
then Aspose.Cells will convert this string to number before entering in cells and formatting will be applied.
Similarly, if you enter it like Cell.PutValue(1234);
then this is not string but it is a number so formatting will be applied on it.
Aspose.Cells is a very light weight component and it does not take much system resources and consume time while entering thousands of records. You can create some console application and test it in a standalone environment.
As an example, we have tested it by entering 1 million rows in 16 columns and it took almost 2.5 minutes on Windows 7 - 64 bit with 8 GB RAM.
Please check this post for your reference.
( https://forum.aspose.com/t/78535 )