The situation is like this:
Within the company has a more complex coefficient calculation Excel spreadsheets, Excel spreadsheets are very vulnerable to crack, however, is want to Excel in EXE program,
The Excel spreadsheet has many forms, but only a few places is the input of original data, other places are multifarious formula form,
Finally the calculated data is displayed in a specific field,


Consult a great god, and want to use visual studio to the function realization of what to do?


First of all, the application of Excel formula can fill in the formula in table next to the list then direct reference to the original data input, can be layers of reference, the final results,
1. But not so many blank Spaces in the visual studio, how should solve?
2. The problem of data mutual reference how to solve? The program itself is not difficult, just mutual reference between the data is very complex,
3. Is there a way to make the contents of the Excel spreadsheet called directly into the visual studio, then only the output in the window? And argue that the EXE program on any computer can realize functions?




Master looking for some ideas!

CodePudding user response:

Formula can be "layers of reference,"
Do in programming languages, can not take "the previous formula" as a result, as the next step calculation "data input"!

CodePudding user response:

Have no choice, only a formula of a formula to straighten out its
Since all use VS, why not open the bondage of EXCEL jump?

CodePudding user response:

Even those formula is provided in Excel algorithm, don't know how to write their own code,
Can also create Excel object, through this object to invoke the formula of calculation result obtained it,

Own program interface, can use a few text box (or form) allow the user to input the raw data,
And then as a "formula" of the original data to calculate,

CodePudding user response:

reference 1st floor Chen8013 response:

formula can "layers of reference,"
Do in programming languages, can not take "the previous formula" as a result, as the next step calculation "data input"!

Well, you're right, I am in order to lighten the work burden, how will want to direct reference,,, as long as the packaging into an exe is good

CodePudding user response:

Encapsulated into an exe is a kind of formula of B,

CodePudding user response:

Aeons120

reference 4 floor response:

Quote: refer to 1st floor Chen8013 response:

Formula can be "layers of reference,"
Do in programming languages, can not take "the previous formula" as a result, as the next step calculation "data input"!

Well, you're right, I am in order to lighten the work burden, how will want to direct reference,,, as long as the packaging into an exe

Then according to the formula processing, use the corresponding program code to "express", implement the corresponding computation and feedback (display) results do not become!
It is no insurmountable gap...

CodePudding user response:

reference 5 floor zhao4zhong1 reply:

encapsulated into an exe is a with B,

Well, you're right,,, but leaders like this,,,

CodePudding user response:

reference 5 floor zhao4zhong1 reply:

encapsulated into an exe is a with B,

"Packaging into an exe", can reduce the risk of leakage source (unless the NET, but can also be "confused" processing),

CodePudding user response:

Advise you don't spend and waste your limited life infinite encryption to decrypt dead loop!

CodePudding user response:

references 9 f zhao4zhong1 response:

advise you don't spend and waste your limited life infinite encryption to decrypt dead loop!

CodePudding user response:

refer to the second floor Runnerchin response:

since all use v, why don't you open the bondage of EXCEL jump?

CodePudding user response:

Can put the formula in each cell all written in the VBA FUNCTION, FUNCTION name also replaced, so don't from will look not to know what is the purpose of the formula,
This is the most direct approach,
Also if you know all the formulas used in the order, that can be written in both VBA function, need according to the shortcut key automatically update all grid data in a table,

CodePudding user response:

That you could do, VB can refer to Excel object library, through the Excel objects to access Excel table, complete your function, Excel object can be set to invisible,

CodePudding user response:

Said,

Actually the VB can access Excel table through at least two ways:
1 refer to Microsoft excel xx. X object library, namely the object library, and by using the method of object variables attribute access excel table,
2 using pluggable object, placed directly on the Windows interface Microsoft excel worksheets, namely through engineering - component - can be inserted into the object, insert a excel interface forms, visible or invisible problems in this method,

CodePudding user response:

1, create EXCEL object;
2, open the excel file (file suffix changed best);
3, write a form, all the input items in the form of input, put a button (calculated),
4, the input value written to EXCEL the corresponding cell
5, call EXCEL automatic calculation;
6, the results of cell values displayed on the interface;

CodePudding user response:

Can use the protective function of excel not achieve

CodePudding user response:

I mean, I understand, is mainly to prevent arbitrary input and modify,
Can consider to target cell, where the input is not lock, lock according to the results,

CodePudding user response:

I want to say is, you can consider to use the database! Lost in the database to how the how the ah, have need to contact me: 332606849

CodePudding user response:

A little bit more simple, you take the cell's formula with software to read it first, empty again, and then, when the input data to recalculate again, empty the formula again, write clear formula after the actual data

CodePudding user response:

I am specially developed EXCEL program,
You can the encapsulated into 100%, vs can do it,, but is not encapsulated in the EXE, using vs development directly,