How to get the hidden formulas from an excel

Question

0.00/5 (No votes)

See more:

Hi,

I am creating an application to get the data written in the excel. But along with this i would like to get the hidden formula from the excel which have been already created. Can someone guide me how would i go with this. I mean are there any specific lib which will help me to get those or is there any way to do it.

I am planning this to write either in VC++ or C# which works in a window platform.Please guide me in building this application.

Thanks in Advance.

What I have tried:

I already have an application to get the data from the pdf,text and doc files. Now i would like to create new or add this functionality to the existing, but I haven't tried anything with regards to excel files.

Posted 19-Dec-16 0:55am

Rocky_Bas

Updated 19-Dec-16 1:42am

#realJSOP

v2

Add a Solution

3 solutions

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)

Simon_Whale · Answer 1 · 2016-12-19T01:26:00

Solution 1

have a look at this

how can I access the formula in an excel sheet with c#? - Stack Overflow[^]

Posted 19-Dec-16 1:26am

Simon_Whale

#realJSOP · Answer 2 · 2016-12-19T01:38:00

Solution 2

The cell's value can be a formula. Try this in your excel interop code (assuming you have excel interop code):

C#

string value = (string)(workbook.ActiveSheet.Cells[row, col].Value2);

Posted 19-Dec-16 1:38am

#realJSOP

LeifJuhl · Answer 3 · 2016-12-19T01:42:00

If I understand you correctly

1. Select the cell or range of cells that contain the formulas.
2. Choose Format – Cells to display the Format Cells dialog box. (Alternatively, use Ctrl+1 on the keyboard.)
3. Select the Hidden and Locked check boxes on the Protection tab.
4. Click OK.
5. Choose Tools – Protection – Protect Sheet to display the Protect Sheet dialog box.
6. Make sure that the Protect Worksheet and Contents of Locked Cells check box is selected.
7. Type the password for protecting the worksheet in the Password to Unprotect Sheet text box.
8. Click OK. Excel will display the Confirm Password dialog box.
9. Type the password again, and then click OK.