Connect to Excel for fares - Githubissues

Limaru-Minecraft / iciwi

Universal transport ticket plugin

MIT License

5 stars 0 forks source link

Connect to Excel for fares #52

Open Mineshafter61 opened 11 months ago

Mineshafter61 commented 7 months ago

The Google Sheets API may not be accessible to every server owner, therefore I've changed the goal to Microsoft Excel instead.

If you don't have Microsoft Excel, simply create your fare table on Google Sheets and download the workbook as an Excel file.

Milestones/Methods:

[x] Read Excel file
[x] Split each spreadsheet into individual tables
[x] Read those tables
[x] Write the data to fares.yml

Tests:

[x] Single large table at A1
[x] Tables at A1 and Ax
[x] Tables at B1 and X1
[x] Tables at A2 and Ax
[x] Tables at Xx and Yy
[x] More than 2 tables
[x] Multiple sheets
[ ] Do everything within 0.05s