Patrick Bailey patmandenver

patmandenver / createxls2.py

Created January 16, 2020 21:43

Simple example using openpyxl that create two worksheets

	#!/usr/bin/env python3

	import openpyxl
	from openpyxl import Workbook



	#############################################
	# MAIN
	#############################################

patmandenver / createxls_from_json.py

Last active January 14, 2024 10:33

	#!/usr/bin/env python3

	import openpyxl
	import json
	from openpyxl import Workbook


	#############################################
	# MAIN
	#############################################

patmandenver / createjson_from_xslx.py

Created February 4, 2020 01:51

	#!/usr/bin/env python3

	import openpyxl
	import json
	from openpyxl import load_workbook

	#############################################
	# MAIN
	#############################################
	if __name__ == '__main__':

patmandenver / createjson_from_xslx.py

Created February 5, 2020 21:26

	#!/usr/bin/env python3

	import openpyxl
	import json
	from openpyxl import load_workbook

	#############################################
	# MAIN
	#############################################
	if __name__ == '__main__':

patmandenver / createxls_from_json_multiple_sheets.py

Created February 7, 2020 01:14

	#!/usr/bin/env python3

	import openpyxl
	import json
	from openpyxl import Workbook


	def populate_sheet(json_data, sheet):
	sheet.cell(1,1, "Month")
	sheet.cell(1,2, "food")

patmandenver / createjson_from_xslx_multiple_sheet.py

Created February 7, 2020 01:20

	#!/usr/bin/env python3

	import openpyxl
	import json
	from openpyxl import load_workbook


	def get_sheet_dict(ws):
	year_dict = {}
	column_headers = {}

patmandenver / createxls_from_json_multiple_sheets.py

Created February 8, 2020 15:15

	#!/usr/bin/env python3

	import openpyxl
	import json
	from openpyxl import Workbook
	from openpyxl.styles import numbers

	def populate_sheet(json_data, ws):
	ws.cell(1,1, "Month")
	ws.cell(1,2, "food")

patmandenver / createxls_from_json_multiple_sheets.py

Created February 8, 2020 17:21

	#!/usr/bin/env python3

	import openpyxl
	import json
	from openpyxl import Workbook
	from openpyxl.styles import numbers

	def populate_sheet(json_data, ws):
	ws.cell(1,1, "Month")
	ws.cell(1,2, "food")

patmandenver / createxls_from_json_multiple_sheets.py

Created February 8, 2020 18:45

	#!/usr/bin/env python3

	import openpyxl
	import json
	from openpyxl import Workbook
	from openpyxl.styles import numbers

	header_dict = { "1": "Month",
	"2": "food",
	"3": "heating",

patmandenver / createxls_from_json_multiple_sheets.py

Created February 8, 2020 19:37

	#!/usr/bin/env python3

	import openpyxl
	import json
	from openpyxl import Workbook
	from openpyxl.styles import numbers
	from openpyxl.utils import get_column_letter


	header_dict = { "1": "Month",