Solution to import Subscript and Superscript from an excel file to mySQL Database?

$10-50 USD

Κλειστή

Αναρτήθηκε

περίπου 5 χρόνια πριν

$10-50 USD

Πληρωμή κατά την παράδοση

We have a lot of chemistry MCQs in an excel file with lot of chemistry formulas and equations. When we tried to import these MCQs into mySQL based database all subscripts used in formulas lost and taken as normal character e.g, H2SO4, CO2, CH3 etc and makes our formulas and elements name nonsense. We need any solution by which mySQL can import subscript and superscript as it is from excel Or any solution by which we can force excel to consider subscript and superscript as inserted symbols because mySQL can pick symbols as it is. Our exam application made by PHP and mySQL and we need permanent solution for it e.g, method, utility etc. A sample file with chemistry formula with sub and super script is attached.

Database Programming

MySQL

PHP

Software Architecture

SQL

Ταυτότητα εργασίας: 18992568

Σχετικά με την εργασία

4 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

4 freelancers δίνουν μια μέση προσφορά $56 USD για αυτή τη δουλειά

@kipdev13

Nice to meet you. I've read the project description and definitely can develop this. I'll provide you with the highly skilled & professional HTML/CSS, PHP/WordPress/CodeIgniter, JavaScript, MySQL, front & back-end web development services and complete the site in time. Please contact with me. Thank you very much.

$35 USD σε 10 ημέρες

4,9

(129 αξιολογήσεις)

6,9

@kanwalrafique

Hi, I read your project brief. I'd like to help you but I can't because the PHP libraries which are available for reading Excel files have severe limitations. So I'm bidding on this project just to inform you about the limitations in current libraries for reading spreadsheet files. These libraries don't yet support all the rich text styling features of MS Excel therefore the formatting info stored in the Excel file for subscripts and superscripts is ignored by these libraries hence you're getting only plain text . I presume you may be using the very popular PHPExcel or its latest incarnation PhpSpreadsheet library for this task. They don't fully support all the rich text formatting features yet. Another option is to use Spout library for reading MS Excel XLSX files but it also don't yet support getting subscripts or superscripts values. So what I suggest for you is to stop wasting your time finding a solution using these libraries and look for something else.

$35 USD σε 10 ημέρες

4,9

(42 αξιολογήσεις)

5,9

@anshulikabansal

Hello Sir, I have understood your issue to capture superscript or subscript so that Formulas would not look like nonsense. I can develop such import script from CSV to MYSQL for you. So it will not kill the look of superscript and sub script and you can see the real formula at your web page via DB. Please ping me for further discussion. Looking forward for your reply. Thanks & Regards, Anshulika Bansal

$100 USD σε 1 ημέρα