Have you considered using a tool to turn your Spreadsheet into API like restsheet.com, sheet2api.com, sheetson.com, or sheet.best? Source: about 1 year ago

Use a paid wrapper like sheet.best or sheety.co. Much easier and robust from my experience and the free plans might be enough anyways. Source: over 2 years ago

// Submit Handler Function SubmitHandler = e => { e.preventDefault(); console.log(this.state); http://axios.post('https://sheet.best/api/sheets/a6e67deb-2f00-43c3-89d3-b331341d53ed', this.state) .then(response => { console.log(response); }) }. - Source: dev.to / over 2 years ago

Do fuzzy matching (something like fuzzywuzzy maybe) to see if the the words line up (allowing for wrong words). You'll need to work out how to use scoring to work out how well aligned the two lists are. Source: over 1 year ago

Convert the original lines to full furigana and do a fuzzy match. (For reference, the original line is 貴方がこれまでに得てきた力、存分に発揮してくださいね。) You can do a regional search using the initial scene data (E60) first, and if the confidence is low, go for a slower full search. Source: over 1 year ago

It's now known as "thefuzz", see https://github.com/seatgeek/fuzzywuzzy. Source: about 2 years ago

You can have a look at this library to use fuzzy search instead of looking for plaintext muck: https://github.com/seatgeek/fuzzywuzzy. Source: over 2 years ago

To deal with comparing the string, I found FuzzyWuzzy ratio function that is returning a score of how much the strings are similar from 0-100. Source: almost 3 years ago