Ankur Heramb Joshi pharmankur
pharmankur
/ OpenOffice Export to JSON
Last active
April 20, 2021 09:03
— forked from aaronhoogstraten/OpenOffice Export to JSON
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 'OpenOffice Basic macro for exporting a .ods spreadsheet to JSON (and CSV) | |
| 'Project-specific formating I implemented: cull empty or "0" entries, '^' as separator value for the csv | |
| REM ***** BASIC ***** | |
| Sub Main | |
| 'First export to CSV which we will later use as the source for the export to json | |
| Dim Propval(1) as New com.sun.star.beans.PropertyValue | |
| Propval(0).Name = "FilterName" |