PragyanCTF2018-Scientists-research

Question

Excel

observations.xlsx

Solution

就咁睇全部格都係裝住一個6位既數字 , 估計可能係color code黎 , 所以直接寫條script轉番每一格做顏色

1
2
3
4
5
6
7
8
9
10
11
12
13
14
from xlrd import open_workbook
from PIL import Image 

wb = open_workbook('observations.xlsx')
for sheet in wb.sheets():
	number_of_rows = sheet.nrows
	number_of_columns = sheet.ncols
	flagImage = Image.new('RGB', (number_of_columns,number_of_rows))
	for row in range(1, number_of_rows):
		for col in range(number_of_columns):
			value = str(hex(int(str(sheet.cell(row,col).value)[:-2]))[2:]).zfill(6)
			rgb = tuple(int(value[i:i+2], 16) for i in (0, 2 ,4))
			flagImage.putpixel((row,col),rgb)
flagImage.save("flag.png")

Flag