ansaurus

Question

Drag and drop a html table into another application

Answer 1

A:

If you don't need formatting, simply copy it to the clipboard as tab-delimited text. This way it'll paste as a table in Excel, and presumable most other table-compatible applications.

Chris 2009-11-09 05:12:39

I do need the formatting that html offers so delimited tables aren't an option.

JohnMcCon 2009-11-09 05:49:32

Answer 2

+1 A:

ObjectListView supports copying and dragging rows from a ListView to other applications, in both text and HTML versions. To do that, it does something like this:

DataObject dataObject = new DataObject();
this.CreateTextFormats(dataObject);
Clipboard.SetDataObject(dataObject);

To do drag and drop, the code is virtually the same:

DataObject dataObject = new DataObject();
this.CreateTextFormats(dataObject);
DragDropEffects effect = this.DoDragDrop(dataObject, DragDropEffects.All);

CreateTextFormats() is not complicated:

public void CreateTextFormats(DataObject do) {
    string textVersion;
    string htmlVersion;
    // Do the work of making the tab-separated text version and the HTML code
    do.SetData(textVersion);
    do.SetText(ConvertToHtmlFragment(htmlVersion), TextDataFormat.Html);
}

Getting the HTML format right took longer:

/// <summary>
/// Convert the fragment of HTML into the Clipboards HTML format.
/// </summary>
/// <remarks>The HTML format is found here http://msdn2.microsoft.com/en-us/library/aa767917.aspx
/// </remarks>
/// <param name="fragment">The HTML to put onto the clipboard. It must be valid HTML!</param>
/// <returns>A string that can be put onto the clipboard and will be recognized as HTML</returns>
private string ConvertToHtmlFragment(string fragment) {
    // Minimal implementation of HTML clipboard format
    string source = "http://www.codeproject.com/KB/list/ObjectListView.aspx";

    const String MARKER_BLOCK =
        "Version:1.0\r\n" +
        "StartHTML:{0,8}\r\n" +
        "EndHTML:{1,8}\r\n" +
        "StartFragment:{2,8}\r\n" +
        "EndFragment:{3,8}\r\n" +
        "StartSelection:{2,8}\r\n" +
        "EndSelection:{3,8}\r\n" +
        "SourceURL:{4}\r\n" +
        "{5}";

    int prefixLength = String.Format(MARKER_BLOCK, 0, 0, 0, 0, source, "").Length;

    const String DEFAULT_HTML_BODY =
        "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">" +
        "<HTML><HEAD></HEAD><BODY><!--StartFragment-->{0}<!--EndFragment--></BODY></HTML>";

    string html = String.Format(DEFAULT_HTML_BODY, fragment);
    int startFragment = prefixLength + html.IndexOf(fragment);
    int endFragment = startFragment + fragment.Length;

    return String.Format(MARKER_BLOCK, prefixLength, prefixLength + html.Length, startFragment, endFragment, source, html);
}

Grammarian 2009-11-10 04:59:51

Exactly what I needed, thanks.

JohnMcCon 2009-11-10 14:53:22

ansaurus

tags:

views:

answers:

Drag and drop a html table into another application

related questions