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