Library to support conversion from OpenXML spreadsheet documents to Pandoc's markdown grid tables.
const xlsx2md = require('xlsx2md');
const fs = require('fs');
const archive = fs.readFileSync('./tests/sample.xlsx');
const configString = `<?xml version="1.0" encoding="utf-8" ?>
<xlsx2md>
<SheetLoader>
<Sheet name="">
<Title><![CDATA[Table 1. A sample table name]]></Title>
</Sheet>
</SheetLoader>
</xlsx2md>`;
const result = xlsx2md.convert(archive, 80, configString);
fs.writeFileSync('./tests/output.md', result, {
encoding: 'utf-8'
});
Table: Table 1. A sample table name
+:--------:+:-------------:+:--------------:+:--------------------------------:+
|**№** |{{B1}} |**Amount** |**Unit Price** |
+----------+---------------+----------------+----------------------------------+
|1 |Unit A |1 |$100\.00 |
+----------+---------------+----------------+----------------------------------+
|2 |Unit B |2 |$2\,000\,000\.00 |
+----------+---------------+----------------+----------------------------------+
|3 |Unit C |3 |$300\.58 |
+----------+---------------+----------------+----------------------------------+
|**Original Price** |**$2\,000\,400\.58** |
+----------+---------------+----------------+----------------------------------+
|**Discount** |**30\.3%** |
+ +----------------------------------+
| |**\-$606\,782** |
+----------+---------------+----------------+----------------------------------+
|**Current Price** |**$1\,393\,619\.07** |
+----------+---------------+----------------+----------------------------------+
|**Expiration Date** |2023/10/1 09\:10\:01\.234 |
+----------+---------------+----------------+----------------------------------+
---
'meta-Table 1. A sample table name':
'@align-r2c2': 'AlignLeft'
'@align-r2c4': 'AlignRight'
'@align-r3c2': 'AlignLeft'
'@align-r3c4': 'AlignRight'
'@align-r4c2': 'AlignLeft'
'@align-r4c4': 'AlignRight'
'@align-r5c2': 'AlignRight'
'@align-r6c2': 'AlignRight'
'@align-r7c1': 'AlignRight'
'@align-r8c2': 'AlignRight'
'@align-r9c2': 'AlignRight'
'B1': |
**Unit Name**
---