how to copy rows from excel to dhtmlxgid?

Suite and Optimus Suite 5
#1

is it possible? plz tell me how? it’s urgent!!!

#2

you can use clipboard to copy cells or paste them.
Please look at this sample:
dhtmlx.com/docs/products/dht … ction.html

#3

I did try this. It’s kinda working but now the issue is that excel data in clipboard gets copied in 1st column not in selected block of column. why?

Here’s my grid xml:

@model dynamic
@{
Response.ContentType = “text/xml”;
Layout = null;
}

S.# SRN Class 
</column>
<column  id="Type"  width="20" sort="str"  type="combo" filter="true"  
source="../DynamicData/JV_ASSET/Type.xml"  align="left" >
  Type
  
</column>

<column  id="TareWt" width="10"  sort="str" type="edn"  align="left"  >Tare Wt.</column>
<column  id="MfgInfo" width="20"  sort="str" type="ed"  align="left"  >Mfg. Info</column>



<settings>
  <colwidth>%</colwidth>
</settings>

@foreach (var rec in Model.Rows)
{

   <row id="@(rec.UIdx)" >
    <userdata name="LID">@rec.LID</userdata>
    <userdata name="SID">@rec.SID</userdata>
    
    <cell />
    	
    <cell>@rec.SRN</cell> 
    <cell>@rec.Class</cell>
    <cell>@rec.Type</cell>
    <cell>@rec.TareWt</cell>
    <cell>@rec.MfgInfo</cell> 
    
   </row>

}

And here’s js script:

        var dp_qtySubGrid = new dataProcessor("/JV_ASSET/SaveSubList");
        dp_qtySubGrid.setTransactionMode("POST", false);
        dp_qtySubGrid.enableDataNames(true);
        dp_qtySubGrid.setDataColumns([false, true, true, true, true, true]);
        dp_qtySubGrid.init(qtySubGrid);
        qtySubGrid.attachEvent("onBeforeSelect", function () {
            return false;
        });

        qtySubGrid.enableBlockSelection();

        qtySubGrid.enableKeyboardSupport(true);

        qtySubGrid.attachEvent("onKeyPress", function onKeyPressed(code, ctrl, shift) {
            if (code == 67 && ctrl) {//Ctrl+C
                if (!qtySubGrid._selectionArea)
                    return alert("You need to select a block area in grid first");
                qtySubGrid.setCSVDelimiter("\t");
                qtySubGrid.copyBlockToClipboard();
            }
            if (code == 86 && ctrl) {//Ctrl+V
                qtySubGrid.pasteBlockFromClipboard();
            }

…

Note that 2nd and 3rd columns in the grid above are combo type!

copy-paste-from-excel.png1366×768 158 KB

#4

Access denied to clipboard under Linux (Ubuntu 10.04LTS)