df140227c3
* code for xlsm support
* updated support for xlsm
* updated code for xlsm support
* Update docling_parse_v4_backend.py
Signed-off-by: ShiroYasha18 <85089952+ShiroYasha18@users.noreply.github.com>
* Update docling_parse_v4_backend.py
Signed-off-by: ShiroYasha18 <85089952+ShiroYasha18@users.noreply.github.com>
* Update test_backend_msexcel_xlsm.py
updated the tests/test_backend_msexcel_xlsm.py:
have a function starting with test
removed all print statements
** To add an explicit assert {test}=={pred}
Signed-off-by: ShiroYasha18 <85089952+ShiroYasha18@users.noreply.github.com>
* Update base_models.py
Signed-off-by: ShiroYasha18 <85089952+ShiroYasha18@users.noreply.github.com>
* Update test_backend_msexcel.py
Signed-off-by: ShiroYasha18 <85089952+ShiroYasha18@users.noreply.github.com>
* Update test_backend_msexcel_xlsm.py
Signed-off-by: ShiroYasha18 <85089952+ShiroYasha18@users.noreply.github.com>
* Update document_converter.py
Signed-off-by: ShiroYasha18 <85089952+ShiroYasha18@users.noreply.github.com>
* Delete tests/test_backend_msexcel_xlsm.py
Signed-off-by: ShiroYasha18 <85089952+ShiroYasha18@users.noreply.github.com>
* xlsm file
Signed-off-by: ShiroYasha18 <85089952+ShiroYasha18@users.noreply.github.com>
* run tests
* ran tests
* Fix tests, upgrade XSLM example to a valid file
Signed-off-by: Christoph Auer <cau@zurich.ibm.com>
---------
Signed-off-by: ShiroYasha18 <85089952+ShiroYasha18@users.noreply.github.com>
Signed-off-by: Christoph Auer <cau@zurich.ibm.com>
Co-authored-by: Christoph Auer <cau@zurich.ibm.com>
29 lines
1.1 KiB
Markdown
Vendored
29 lines
1.1 KiB
Markdown
Vendored
## Pivot table with with 1 row header
|
|
|
|
| Year | Month | Revenue | Cost |
|
|
|--------|----------|-----------|--------|
|
|
| 2025 | January | $134 | $162 |
|
|
| 2025 | February | $150 | $155 |
|
|
| 2025 | March | $160 | $143 |
|
|
| 2025 | April | $210 | $150 |
|
|
| 2025 | May | $280 | $120 |
|
|
|
|
## Pivot table with 2 row headers
|
|
|
|
| Year | Quarter | Month | Revenue | Cost |
|
|
|--------|-----------|----------|-----------|--------|
|
|
| 2025 | Q1 | January | $134 | $162 |
|
|
| 2025 | Q1 | February | $150 | $155 |
|
|
| 2025 | Q1 | March | $160 | $143 |
|
|
| 2025 | Q2 | April | $210 | $150 |
|
|
| 2025 | Q2 | May | $280 | $120 |
|
|
|
|
## Equivalent pivot table
|
|
|
|
| Year | Quarter | Month | Revenue | Cost |
|
|
|--------|-----------|----------|-----------|--------|
|
|
| 2025 | Q1 | January | $134 | $162 |
|
|
| 2025 | Q1 | February | $150 | $155 |
|
|
| 2025 | Q1 | March | $160 | $143 |
|
|
| 2025 | Q2 | April | $210 | $150 |
|
|
| 2025 | Q2 | May | $280 | $120 | |