我以前一直在尋求一種解決方案，可以讓我將無序串列轉換為格式化的 HTML 表格。
當時，一位好心的用戶提出了一個解決方案，我附在下面。
該解決方案將無序串列轉換為 Google 表格中的常規表格，其中不同的值被劃分到各自的單元格中。相反，我希望將無序串列轉換為僅放置在一個單元格中的格式化 html 表格串列。
如果可能的話，除此之外，我希望能夠將數百個無序串列放入腳本中，然后將其轉換為它們自己的 HTML 格式表。
請參閱下面我從另一個用戶那里獲得的先前解決方案。
希望這一切都有意義。
編輯： 我還在這篇文章的最底部添加了輸入和首選輸出。
In your situation, how about the following sample script?
Sample script 1:
This script parses your value using the regex.
function myFunction1() {
// This sample value is from your question.
const sample = `<ul>
<li>Material: 100% polyester with polyurethane coating</li>
<li>Water column pressure: 4000mm</li>
<li>Fit: Regular unisex</li>
<li>Elasticated waistband with drawstring</li>
<li>Elasticated cuffs with tonal coated zips</li>
<li>Single back pocket with eyelet</li>
<li>Concealed side pockets</li>
<li>Ultrasonically welded seams</li>
<li>Reflective accents</li>
</ul>`;
// Parse list.
const obj = sample.matchAll(/<li>([\w\S\s] ?)<\/li>/g);
const values = [...obj].map(e => {
if (e && e.length > 1) {
const temp = e[1].split(":");
return temp.length == 1 ? [temp[0].trim(), ""] : temp.map(f => f.trim());
}
return ["", ""];
});
// Put the values to the sheet.
const sheetName = "Sheet1"; // Please set the sheet name.
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
sheet.getRange(1, 1, values.length, values[0].length).setValues(values);
}
When this script is run, your sample value is parsed. And, the values are put to the sheet.
Sample script 2:
This script parses your value using XmlService.
function myFunction1() {
// This sample value is from your question.
const sample = `<ul>
<li>Material: 100% polyester with polyurethane coating</li>
<li>Water column pressure: 4000mm</li>
<li>Fit: Regular unisex</li>
<li>Elasticated waistband with drawstring</li>
<li>Elasticated cuffs with tonal coated zips</li>
<li>Single back pocket with eyelet</li>
<li>Concealed side pockets</li>
<li>Ultrasonically welded seams</li>
<li>Reflective accents</li>
</ul>`;
// Parse list.
const root = XmlService.parse(sample).getRootElement();
const values = root.getChildren("li", root.getNamespace()).map(e => {
const temp = e.getValue().split(":");
return temp.length == 1 ? [temp[0].trim(), ""] : temp.map(f => f.trim());
});
// Put the values to the sheet.
const sheetName = "Sheet1"; // Please set the sheet name.
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
sheet.getRange(1, 1, values.length, values[0].length).setValues(values);
}
References:
map()
setValues(values)
Added:
From your following additional question,
That does the job for doing it on one single product. Let's say I have a batch of product details for several different products. Like here below. Is there a way to run the script on all three at once so it becomes three different tables?
In this case, how about the following sample script?
Sample script:
function myFunction2() {
// This is from your new question.
const samples = [
"<ul><li>Material: 100% polyester with polyurethane coating</li><li>Lining: 100% polyester</li><li>Insulation: 100% polyester</li><li>Measurements: H160cm x W140cm x D1cm / H63 x W55.1 x 0.4 inches</li><li>When packed: H13cm x W47cm x D25cm / H5.1 x W18.5 x D9.8 inc?</li><li>Pack-carry-store system with buckles and adjustable webbing straps</li><li>Soft, quilted and padded side</li><li>Waterproof upper on reverse</li></ul>",
"<ul><li>Material: 100% polyester with polyurethane coating</li><li>Water column pressure: 4000mm</li><li>Soft mesh lining</li><li>Circumference: S1 – 61.5 cm / 24.2 inches, / S2 - 66 cm / 26 inches</li></ul>",
"<ul><li>Material: 100% polyester with polyurethane coating</li><li>Lining: 100% polyester </li><li>Water column pressure: 8000mm</li><li>Measurements: H16 x W21 x D8.5cm / H6.3 x W8.3 x D3.3 inches</li><li>Volume: 3 liters / 0.8 gallons</li><li>Coated tonal zip closure</li><li>Single main compartment </li><li>Detachable adjustable webbing shoulder strap </li><li>Carry handle</li></ul>"
];
const sheetNames = ["Sheet1", "Sheet2", "Sheet3"]; // Please set the sheet names.
samples.forEach((sample, i) => {
const root = XmlService.parse(sample).getRootElement();
const values = root.getChildren("li", root.getNamespace()).map(e => {
const temp = e.getValue().split(":");
return temp.length == 1 ? [temp[0].trim(), ""] : temp.map(f => f.trim());
});
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetNames[i]);
sheet.getRange(1, 1, values.length, values[0].length).setValues(values);
});
}
請參閱下面的輸入和首選輸出。
每當有一行帶有冒號的文本，例如“材料：100% 聚酯與聚氨酯涂層”，我希望它在表格中分成兩列，以便“材料：”在第 1 列中，并且“帶有聚氨酯涂層的 100% 聚酯”在第 2 欄中。
輸入：
/** List 1 **/
<ul>
<li>Material: 100% polyester with polyurethane coating</li>
<li>Lining: 100% polyester</li>
<li>Insulation: 100% polyester</li>
<li>Measurements: H160cm x W140cm x D1cm / H63 x W55.1 x 0.4 inches</li>
<li>When packed: H13cm x W47cm x D25cm / H5.1 x W18.5 x D9.8 inc?</li>
<li>Pack-carry-store system with buckles and adjustable webbing straps</li>
<li>Soft, quilted and padded side</li>
<li>Waterproof upper on reverse</li>
</ul>
/** List 2 **/
<ul>
<li>Material: 100% polyester with polyurethane coating</li>
<li>Water column pressure: 4000mm</li>
<li>Circumference: S1 – 61.5 cm / 24.2 inches, / S2 - 66 cm / 26 inches</li>
<li>Soft mesh lining</li>
</ul>
/** List 3 **/
<ul>
<li>Material: 100% polyester with polyurethane coating</li>
<li>Lining: 100% polyester </li>
<li>Water column pressure: 8000mm</li>
<li>Measurements: H16 x W21 x D8.5cm / H6.3 x W8.3 x D3.3 inches</li>
<li>Volume: 3 liters / 0.8 gallons</li>
<li>Coated tonal zip closure</li>
<li>Single main compartment </li>
<li>Detachable adjustable webbing shoulder strap </li>
<li>Carry handle</li>
</ul>
想要的輸出：
/** Table 1 (converted from List 1) **/
<table>
<tbody>
<tr>
<td>Material:</td>
<td>100% polyester with polyurethane coating</td>
</tr>
<tr>
<td>Lining:</td>
<td>100% polyester</td>
</tr>
<tr>
<td>Insulation:</td>
<td>100% polyester</td>
</tr>
<tr>
<td>Measurements:</td>
<td>H160cm x W140cm x D1cm / H63 x W55.1 x 0.4 inches</td>
</tr>
<tr>
<td>When packed:</td>
<td>H13cm x W47cm x D25cm / H5.1 x W18.5 x D9.8 inc</td>
</tr>
<tr>
<td>Pack-carry-store system with buckles and adjustable webbing straps</td>
<td></td>
</tr>
<tr>
<td>Soft, quilted and padded side</td>
<td></td>
</tr>
<tr>
<td>Waterproof upper on reverse</td>
<td></td>
</tr>
</tbody>
</table>
/** Table 2 (converted from List 2) **/
<table>
<tbody>
<tr>
<td>Material:</td>
<td>100% polyester with polyurethane coating</td>
</tr>
<tr>
<td>Water column pressure:</td>
<td>4000mm</td>
</tr>
<tr>
<td>Circumference:</td>
<td>S1 – 61.5 cm / 24.2 inches, / S2 - 66 cm / 26 inches</td>
</tr>
<tr>
<td>Soft mesh lining</td>
<td></td>
</tr>
</tbody>
</table>
/** Table 3 (converted from List 3) **/
<table>
<tbody>
<tr>
<td>Material:</td>
<td>100% polyester with polyurethane coating</td>
</tr>
<tr>
<td>Lining:</td>
<td>100% polyester</td>
</tr>
<tr>
<td>Water column pressure:</td>
<td>8000mm</td>
</tr>
<tr>
<td>Measurements:</td>
<td>H16 x W21 x D8.5cm / H6.3 x W8.3 x D3.3 inches</td>
</tr>
<tr>
<td>Volume:</td>
<td>3 liters / 0.8 gallons</td>
</tr>
<tr>
<td>Coated tonal zip closure</td>
<td></td>
</tr>
<tr>
<td>Single main compartment</td>
<td></td>
</tr>
<tr>
<td>Detachable adjustable webbing shoulder strap</td>
<td></td>
</tr>
<tr>
<td>Carry handle</td>
<td></td>
</tr>
</tbody>
</table>
uj5u.com熱心網友回復：
對于這種情況，我建議嘗試使用這樣的自定義公式：
function to_table(range) {
const do_replace = text => text
.replace(/<ul>/g, '<table>')
.replace(/<\/ul>/g, '</table>')
.replace(/<li>/g, ' <tr>\n <td>')
.replace(/<\/li>/g, '</td>\n </tr>')
.replace(/: /g, ':</td>\n <td>')
.replace(/(<tr>\n <td>. ?<\/td>\n)( <\/tr>)/gm, '$1 <td></td>\n$2');
try { return range.map(row => do_replace(row[0])) } // for a range
catch(e) { return do_replace(range) } // for a single cell
}
要處理單個單元格：
要處理一整列：
uj5u.com熱心網友回復：
嘗試
function myFunc() {
const sample = `<ul>
<li>Material: 100% polyester with polyurethane coating</li>
<li>Water column pressure: 4000mm</li>
<li>Fit: Regular unisex</li>
<li>Elasticated waistband with drawstring</li>
<li>Elasticated cuffs with tonal coated zips</li>
<li>Single back pocket with eyelet</li>
<li>Concealed side pockets</li>
<li>Ultrasonically welded seams</li>
<li>Reflective accents</li>
</ul>`;
const result = sample.replace(/<li>|<ul>|<\/li>|<\/ul>/g,'')
const sheetName = "Sheet1"; // Please set the sheet name.
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
sheet.getRange(1, 1).setValue(result);
}
該串列將僅放置在一個單元格中
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/459040.html
標籤：html 谷歌应用脚本 谷歌表格 html表 html 列表
上一篇：如果單詞存在于兩列之一中，則查詢
下一篇：Keras中的張量乘法