Parsing and using regex on math questions and answers in structured excel sheets, to convert MathML to PNG images.
Write the converted image to an images folder with the file name and path in a new cell, along with the Question text.
Do this for 2 columns, Q and A columns.
Output to similar or same excel, processing several hundred MathML formula, AND process several TABS in the single Excel sheet.
Images are to be saved according to the Tag for the Q listed in the same spreadsheet.
Steps:
For Q
Convert MathML to PNG from cell NN,
read file name from cell AA,
save PNG with tag from AA into cell CC, with text from NN
For answer: repeat above.
Sample excel template provided to applicants to review before quoting or accepting
---
Explanation of method and approach to be provided in documentation.
One method could be using JEuclid [login to view URL] (a set of Java classes) for this purpose,
also refer [login to view URL] for formatting
---
text example: (excel provided to applicant to preview)
(a) 12, 4,
16
6
MathType@MTEF@5@5@+=feaagCart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLnhiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr4rNCHbWexLMBbXgBd9gzLbvyNv2CaeHbcYMGYbIL+kzQaibaieYlf9irVeeu0dXdh9vqqj=hEeeu0xXdbba9frFj0=OqFfea0dXdd9vqaq=JfrVkFHe9pgea0dXdar=Jb9hs0dXdbPYxe9vr0=vr0=vqpWqaaeaabiGaciaacaqabeaadaqaaqaafaGcbaWaaSaaaeaacaaIXaaabaGaaGOmaaaaaaa@41ED@
I've worked extensively on MathML and have written software to test student competency in answering questions through MathML. As part of this I had to covert a lot of formulae to PNG, I have the experience for this.