You can find the current (MXL v1.8) spreadsheets here:
SUs
Sets
You can also use the below PowerShell scripts to recreate the CSVs (without formatting). These scripts may only work with the current documentation, but could likely be updated easily. Please don't judge my scripts too much; I got a bit tired of trying to parse and got sloppy xD
SUs PowerShell script
Code: Select all
$suurl = "https://docs.median-xl.com/doc/items/sacreduniques"
$surequest = Invoke-WebRequest $suurl
$tables = $surequest.ParsedHtml.getElementsByTagName("table") | Where-Object{$_.classname -like "uniques"}
$wholeList = [Ordered] @{}
$count=0
foreach ($table in $tables) {
$checkRow = $table.rows[0].children | Where-Object{$_.tagname -like 'th'}
if ($checkRow) {
$itemClass = $checkRow.outerText.Trim()
$wholeList.$itemClass = @()
for ($n=1; $n -lt $table.rows.length; $n++) {
for ($i=1; $i -lt $table.rows[$n].cells.length; $i++) {
$itemName = ($table.rows[$n].cells[$i].outerText -split '\n')[0]
$wholeList.$itemClass += $itemName.Trim()
}
}
}
else {
$itemClass = "Jewelry$count"
$count += 1
$wholeList.$itemClass = @()
for ($n=0; $n -lt $table.rows.length; $n++) {
for ($i=1; $i -lt $table.rows[$n].cells.length; $i++) {
$itemName = ($table.rows[$n].cells[$i].outerText -split '\n')[0]
$wholeList.$itemClass += $itemName.Trim()
}
}
}
}
$wholeList.GetEnumerator() |
Select-Object -Property @{N='Item Class';E={$_.Key}},
@{N='Item Name';E={$_.Value -join ', '}} |
Export-Csv -NoTypeInformation -Path .\mxlsus.csv
Sets PowerShell script
Code: Select all
$setsurl = "https://docs.median-xl.com/doc/items/sets"
$setrequest = Invoke-WebRequest $setsurl
$tables = $setrequest.ParsedHtml.getElementsByTagName("table") | Where-Object{$_.classname -like "sets"}
$wholeList = [Ordered] @{}
foreach ($table in $tables) {
$split = $table.rows[0].cells[0].outerText -split '\n'
$set = $split[0]
$wholeList.$set = @()
$i = 2
while ($split[$i].Trim() -ne "") {
$wholeList.$set += $split[$i].Trim()
$i++
}
}
$wholeList.GetEnumerator() |
Select-Object -Property @{N='Set Name';E={$_.Key}},
@{N='Item Name';E={$_.Value -join ', '}} |
Export-Csv -NoTypeInformation -Path .\mxlsets.csv
Feel free to use as you'd like. Let me know if there are any issues! (: