Library to support conversion from OpenXML spreadsheet documents to Pandoc's markdown grid tables.
npm install xlsx2mdLibrary to support conversion from OpenXML spreadsheet documents to Pandoc's markdown grid tables.
``javascript
const xlsx2md = require('xlsx2md');
const fs = require('fs');
const archive = fs.readFileSync('./tests/sample.xlsx');
const configString =
;
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
---
``