Excel file has the following data, no database, how to do data statistics?

ID Band (brand) num (sales quantity) Price (unit)
1 Samsung 7677 2300
2 Huawei 9877 1699
3 Apples 24552 6799
... More brands, the number is unknown, consider the large amount of Excel inside the situation

Problem:
If you are going to count the top 3 brands with the largest total amount of sales (database not available)
Next idea, thank you.

Reply content:

ID Band (brand) num (sales quantity) Price (unit)
1 Samsung 7677 2300
2 Huawei 9877 1699
3 Apples 24552 6799
... More brands, the number is unknown, consider the large amount of Excel inside the situation

Problem:
If you are going to count the top 3 brands with the largest total amount of sales (database not available)
Next idea, thank you.

PHP Gets the execl content, each cell will be a key to the array, according to the brand key cumulative sales (quantity * price), the final sort of the top three.

Thank you for inviting me. You can use the Excel file to read a program to organize the array, and then sort the price of the array. Personal understanding

Problems with Excel?

• Create a new column to calculate the total sales for each row;

• Turn on filtering

• To sort

PHP Implementation method:

