WinForms Control for Textfile converting like in excel or open office?

Question

Hi,

for a Windows application I need to read in fixed block files which need to be splitted in fields. I would like to this like in excel or openoffice where I have a preview of the file and can graphically define where the line should be splitted.

Does anyone know some control for .net which supports this, or any sample code where this is demonstrated? Or even some hints how to do it?

Thanks, Michael!

Image of the Excel wizard

I've found a MFC-Control on CodeProject. Column Separator Control I will try to rewrite it to C#.

Answer 1

Well it might help if you expand a little more, maybe with an example?

If I understand the question right a DataGridView sounds worth looking into. It's basically a table that you bind to a datasource. There are quite a lot of examples on the MSDN site using them.

Re-reading if you are interested in displaying the actual text, and then setting a position to split the text, you could maybe just display the contents in a text box? Then you'd have to deal with the cursor position and keep a record of where it was last placed.

Answer 2

I know the dialog in Excel you're talking about, but I've never seen a similar control. I think you'll have to implement your own control for that.

Answer 3

The only thing I have found is the required control for MFC on CodeProject (see question). It seems I need to rewrite the control for C#/.net.

Answer 4

We have written our own control for that in C#. If anyone is interested in that control please contact me. Maybe we will release it then.