With open('DATA.I have a excel file which stored my game data, and successfully converted to json file.Ī sample on excel file and the converted json: # Open a new text file and write the contents of excel_data to it. I would like the JSON to follow this format: ) I have an excel file and I want to convert it into a JSON file. Print('Excel Sheet to JSON:\n', json_str) Then, running this code should result with printing a JSON string describing the excel sheet called Sheet.Įxcel_data_fragment = pandas.read_excel('excel_form.xlsx', sheet_name='Sheet'). It is a library made for data manipulation and has many more features. If you are looking for a more comprehensive solution, you might as well find pandas useful.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |