marovst
commented
3 years ago Answer from Gergely:
A torture utility is available now, here: https://www.nesys.uio.no/LZExcel2JSON/ The torture part is that the pages in the Excel sheet have to be copied there one by one: 1 - open https://www.nesys.uio.no/LZExcel2JSON/ in a browser 2 - open the Excel workbook in Excel 3 - go to a sheet, select everything somehow. Either you know a clever way, or press Ctrl+A twice, because the first one usually select only a block of data you are in, the second one selects everything. Again, usually 4 - Copy (Ctrl+C) 5 - go to the browser, Paste into the textbox (Ctrl+V) 6 - press "Add Sheet" button. If everything goes well, textbox gets empty and the "Sections:" row starts gathering section IDs. If a section added multiple times, the page will figure that out and internally replaces the existing one. If there was some simple problem, you get an error message. If there was a grave problem, you probably won't see anything 7 - repeat from step 3. 8 - press "Generate JSON", the JSON will appear in a separate window, Copy-Paste it to a suitable file 9 - "Start new series" button can be used to forget everything and start a new list of sections. The button does not ask for confirmation, but it's hard to click on it accidentally.
I tested it with EXP6_ctrl_2 (it has just 5 sheets), it seemed to work, however the JSON file you have seems to contain more markers for the last two sections than the Excel file. Output for the first 3 sections was identical, so I tend to think the difference really comes from the files and not from the utility.
Majpuc
Request: tool that convert localizoom coordinates stored in excel sheets to Localizoom ready .json files.
Background information: I have coordinates plotted in Localizoom that have been exported to excel sheets with the "Export to excel" function. The coordinates cannot be read by Localizoom with use of the in the excel sheets. I need these excel sheets to be converted to .json files to view my plots in Localizoom at a later time.