Find Jobs
Hire Freelancers

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

$10-50 USD

Lukket
Slået op cirka 5 år siden

$10-50 USD

Betales ved levering
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.
Projekt-ID: 18992568

Om projektet

4 forslag
Projekt på afstand
Aktiv 5 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
4 freelancere byder i gennemsnit $56 USD på dette job
Brug Avatar.
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 på 10 dage
4,9 (129 anmeldelser)
6,9
6,9
Brug Avatar.
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 på 10 dage
4,9 (42 anmeldelser)
5,9
5,9
Brug Avatar.
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 på 1 dag
4,4 (102 anmeldelser)
6,3
6,3
Brug Avatar.
I read job description and I can do your project.I can even work on urgent basis and complete your project soon..contact me for more information
$55 USD på 2 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for PAKISTAN
Lahore, Pakistan
5,0
1
Betalingsmetode verificeret
Medlem siden mar. 27, 2018

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.