I avoided having to write a programming script to convert a PGN games file into a spreadsheet, but I used a word processing application instead. GenerateExcel(dates,welo,belo,white,black) Wb = openpyxl.load_workbook(filename=file) WhiteLong.append(test_str) //The max length of a nickname in is 35 charactersÄef generateExcel(dates,welo,belo,white,black): You need to install chess and openpyxl libraries with pip. I have created a file called chess_games.xlsx and I have inserted the five values you are asking using a python2 script. i imagine the output will be messier for mixed chess960 and chess. Consider for example this player: Replacing 'gmwso' with the player's username will yield a weird output. It appears there's a problem when it gets to the case of chess960 only. Update 1: It appears Mike Steelson has an answer here, where the code is given as =arrayformula( regexextract(split( substitute(substitute(substitute(getDataJSON(A1 "/games" "/pgn") "" "") """" "") char(10)) "\s.*") ) How do I get this data into a spreadsheet like column 1 is all the dates, column 2 is the corresponding white elo, column 3 black elo, col4 white username and col5 black username? There's gonna be a bunch of stuff like say Sequel to this question: Live statistics chess960 from ?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |