3 ms·
That's awesome! Mind sharing the prompt you used? I'm working on something pretty similar but a little more complex—looking to convert from an Excel sheet to Ma
by its_down_again 2y ago
That's awesome! Mind sharing the prompt you used? I'm working on something pretty similar but a little more complex—looking to convert from an Excel sheet to Markdown or JSON.
- xupybd 2y agoSure, here is the prompt. Can you write me a program that can generate formatted PDFs from JSON? Preferably using the simplest of tools
- rovr138 2y agoIf it was just that, I'd probably load onto a pandas df, then export the df to json. There's other ways, but this would be a simple enough way. Check, - https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html https://pandas.pydata.org/pandas-docs/stable/reference/api/p... - https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_json.html https://pandas.pydata.org/pandas-docs/stable/reference/api/p... Try something like, import pandas as pd file_path = 'excel_file.xlsx' df = pd.read_excel(file_path, sheet_name='WORKSHEET NAME') df.to_json('output.json', orient='records', indent=4)