Json2Xlsx: Extraction and visualization of nested data in a sparse spreadsheet

• DOI: 10.1016/j.simpa.2023.100588
• Publication Date: 2023-10-13T15:59:18Z
• Authors: Raphael Scheible; Stephan Rusch; Maria Elena Maccari; Markus G. Seidel; Stephan Ehl; Alexandra Nieters; Gerhard Kindle
• Keywords: Data extraction

Data extraction, visualization and distribution is an important task in the daily work of a database management team. In medical field requests are often made by researchers who use spreadsheet programs such as Excel. Thus, we developed framework which allows us to extract tables with 1:N relations sparse prevents redundant information. The Framework implemented PHP using JSON interface. Further, offer connectors for direct connection Postgres database.