Home > Net >  C # _ reading excel is converted into a bin file and displayed in a Hex file editor interface
C # _ reading excel is converted into a bin file and displayed in a Hex file editor interface

Time:10-16

I recently on a whim, want to use c # to do a tool for the Bin file to Excel, have a exe tools are available, and others do but not convenient,
The following figure,
Function 1: read the excel, and specify the column data data can be read out, the following figure, according to the format of the
Feature 2: the editor display interface can be directly edit the specified address data, the content of the manual editing, according to the background color yellow,
3: can keep the data content for the bin file,

I has successful cases for function 3,
But for function 1 (read the Excel table), explores the Oledb way, error will be prompted to external form type, online said to link string: Jet for Ace, to 4.0 to 12.0, to Excel at 12.0, 8.0, and so on and so on, are tried, no, I don't know whether related to company document encryption system,
. Try to add back the Microsoft Office. Interop. Excel references, _Workbook way can read the specified element content,

Want to ask is function (as shown in figure 2 hex editor display interface), I don't know what is control? How to implement such a display and editable effect?
I'm STVP burn unit load interface, the following figure 2 and also see the same effect,
Please the great god show the younger brother, thank you very much!
Any ideas are welcome to communicate, thank you!



CodePudding user response:

Using NPOI function 1, don't mind, basic can fix
Function 2, WPF, you can use a two layer of the StackPanel implementation, if WinForm, it is written in ListView inside a 16-bit word definition control
Function 3, 1 and 2 are realized, the function is very well written, binarywriter is done

CodePudding user response:

reference 1st floor strongerzhi response:
function 1, don't mind using NPOI, basic can fix
Function 2, WPF, you can use a two layer of the StackPanel implementation, if WinForm, it is written in ListView inside a 16-bit word definition control
Function 3, 1 and 2 are realized, the function is very well written, can get this done in binarywriter
thank you for your advice, I found the edit box can be sliding through the mouse, also support around up and down arrow keys to change, and is able to calculate the corresponding corresponding address, don't know whether there is a simple related routines can learn?
The younger brother new to c #, but very interested, are self-taught,, don't laugh, thanks again

CodePudding user response:

To recommend you a hex file editor interface routines, "wang group guide blog" from the network, thanks for sharing the brothers,
http://blog.sina.com.cn/s/blog_589d32f5010082ii.html
http://download.csdn.net/detail/zswang/346182#comment

Basic effect meet I have described, can learn,

CodePudding user response:

The original poster hello, you this will EXCEL file, please convert hex or bin file of small tools where to download? Or you can provide a copy of this conversion code for me? As to the lavatory, grateful

CodePudding user response:

Really badly, you in this line of thought into a bin file, not the oledb you use npoi,, may be washed-up, oledb version, not updated, the second, third all have no idea,,, you can share your third way?

CodePudding user response:

Why don't
application UltraEdit
If the custom, the left is a ListView, the right should be a read-only text box RichTextBox and so on
  •  Tags:  
  • C#
  • Related