Excel equation (equation editor 3.0) convert to text or any other format to upload equations to database.

Question

0.00/5 (No votes)

See more:

Hi,

I have a spreadsheet with equations. equations inserted in a cell as image (object). I want to upload those equation to database but I don't want to upload equations as image.Is there a way to convert it to any other format and upload to DB.

Is it possible to convert image data( equation in excel cell saved as object ) to text data.

Please let me know if you know any other options.

Thank you.

What I have tried:

I know there are online OCR converters which convert image to text data but equations are not converted accurately. I also tested open image file as document file in Google drive. No accurate conversion. I also tried equations save as pdf file and convert it to text.

Posted 18-May-20 12:05pm

peoria123

Updated 19-May-20 10:33am

Add a Solution

Comments

Maciej Los 19-May-20 16:10pm

Why Excel equation?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2020-05-19T10:34:00

I'd suggest to read these:
Formula editor - Wikipedia[^]
Enable Your Users to Write Math Equations in Your Web and Desktop Apps[^]
A Calculation Engine for .NET[^]
Flee Fast Lightweight Expression Evaluator - CodePlex Archive[^]
NCalc - Mathematical Expressions Evaluator for .NET- CodePlex Archive[^]
Parsing Mathematical Expressions in VB.NET: Mission Possible[^]
How to convert file content to numbers in visual studio[^]

Conclusion: you can save mathematical expression as a text, image and either as object then to display it any format.