Casie Liucasie.hashnode.dev·Dec 20, 2024Convert Excel to SVG in Python Like a Pro | GuideAt first glance, Excel spreadsheets and SVG files might not seem related. Yet, there are situations where you need to convert an Excel table into SVG format—for instance, when you want to display Excel-generated data on a website or other visual plat...Python
esProc Desktopesproc-desktop.hashnode.dev·Dec 16, 2024#118 — Group by the Combination of Multiple ColumnsProblem description & analysis: Here below is a data table: Task: We want to group the data by Year and Quarter, and count the total sales of each quarter. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).groups(Year,Quarter;sum(Sale...10 likesexcel
Casie Liucasie.hashnode.dev·Dec 13, 2024How to Insert Images in Excel Files or Delete Them Using Python: Detailed GuideIn Excel, adding images can make worksheets more visually appealing and easier to understand. For instance, when organizing a client list, you might want to associate each client with their company logo for quicker identification. On the other hand, ...Python
esProc Desktopesproc-desktop.hashnode.dev·Dec 13, 2024#117 — Simple GroupingProblem description & analysis: Here below is a data table: Task: We want to group the data by Class and calculate the average score of each subject for each class. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).groups(Class;avg(Ma...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 12, 2024#116 — Concatenate Members with the Same RankingProblem description & analysis: Here below is a data table: Task: Rank the students by math score and concatenate the names of students having the same score with comma. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).group(Maths).(...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 11, 2024#115 — Ranking of Row-Based Data — by the ExpressionProblem description & analysis: Here below is a data table: Task: Calculate the ranking of data (in descending order) by the sum of three columns Maths, English and PE. Solution: Use SPL XLL and enter the following code in cell F2: =spl("=E(?1).(Mat...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 10, 2024#114 — Ranking of Row-Based Data — by the Combination of Multiple ColumnsProblem description & analysis: Here below is a data table: Task: Rank the data (in descending order) by the order combination of three columns, Maths, English, and PE. Solution: Use SPL XLL and enter the following code in cell F2: =spl("=?1.rank@z(...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 9, 2024#113 — Ranking of Row-Based DataProblem description & analysis: Here below is a data table: Task: Calculate the ranking of students by TotalScore (in descending order) and fill the results in corresponding cells of column D. Solution: Use SPL XLL and enter the following formula in...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 6, 2024#112 — Ranking of Simple MembersProblem description & analysis: Here below is a data table: Task: Calculate the ranking of members (in descending order) and fill the results in corresponding cells of column B. Solution: Use Excel add-in SPL XLL and enter the following code in cell...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 5, 2024#111 — Sort in GroupProblem description & analysis: Here below is a data table: Task: Sort the data (in ascending order) by Class and (in descending order) by Score. Solution: Use Excel add-in SPL XLL and enter the following formula: =spl("=E(?1).sort(Class,Maths:-1)",...10 likesexcel
