-1

how can i export the results to excel

I tried to export the options' volumes from this website. But I find i can't export the results to excel bc I don't know the type of 'response'. How should I do?

sue Apple
  • 1
  • 2
    please post code as code. also post copy-pasteable data – Gulzar May 06 '21 at 12:10
  • It's always better to add the code who have tried so far. For better and clear understanding. And provide more detail along with your code. –  May 06 '21 at 12:13
  • At first glance the output appears to be a JSON string. Check [this](https://stackoverflow.com/questions/15379178/how-to-convert-json-to-xls-in-python) answer out. – bluevulture May 06 '21 at 12:17

1 Answers1

1

You cand try openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.

Library documentation: https://openpyxl.readthedocs.io/en/stable/

modo24
  • 64
  • 1
  • 9