World Of Program

Tuesday 28 August 2012

Show opened Excel Sheet in Datagridview Excel Add-In C#

Microsoft.Office.Interop.Excel.Application xlApp;
       Microsoft.Office.Interop.Excel.Workbook activeWorkBook = (Microsoft.Office.Interop.Excel.Workbook)Globals.ThisAddIn.Application.ActiveWorkbook;
            Microsoft.Office.Interop.Excel.Sheets sheets = activeWorkBook.Worksheets;
            Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.get_Item(1);
            Microsoft.Office.Interop.Excel.Range xlRange = worksheet.UsedRange;
            Array myValues = (Array)xlRange.Cells.Value2;

            //DataTable dt = new DataTable();
            //DataRow rw = dt.NewRow();
            //DataTable dt = new DataTable();
            System.Data.DataTable dt = new System.Data.DataTable();
            DataRow dr;
            System.Data.DataTable dtreturn = new System.Data.DataTable();
            Microsoft.Office.Interop.Excel.Application oExcel;
            Microsoft.Office.Interop.Excel.Workbook oWorkBook;
            Microsoft.Office.Interop.Excel.Worksheet oWorkSheet;
            try
            {
                int r;
                int c;
                int intRows;
                int intCols;

                Microsoft.Office.Interop.Excel.Range excelCell = worksheet.UsedRange;
                Object[,] values = (Object[,])excelCell.Value2;
                intRows = values.GetLength(0);

                if (intRows != 0)
                {
                    intCols = values.GetLength(1);
                    if (intCols != 0)
                    {
                        for (c = 1; c <= intCols; c++)
                        {
                            dt.Columns.Add(new DataColumn((String)values[1, c]));
                        }
                        for (r = 2; r <= intRows; r++)
                        {
                            dr = dt.NewRow();
                            for (c = 1; c <= intCols; c++)
                            {
                                dr[(String)values[1, c]] = values[r, c];
                            }
                            dt.Rows.Add(dr);
                        }
                    }
                }
                grid.DataSource = dt.AsDataView();

                dtreturn = dt;
                dt = null;
                oWorkSheet = null;
                activeWorkBook.Close(Missing.Value, Missing.Value, Missing.Value);
                oWorkBook = null;

                oExcel = null;

                //for (int i = 0; i < grid.Columns.Count; i++)
                //{
                //    combomsg.Items.Add(grid.Columns[i].HeaderText);
                //    combonum.Items.Add(grid.Columns[i].HeaderText);
                //}

            }
            catch (Exception ex)
            {

            }

Wednesday 8 August 2012

Highlight Specific Text On Page

First add this script in ur javascript file

highlight v3

Highlights arbitrary terms.

<http://johannburkard.de/blog/programming/javascript/highlight-javascript-text-higlighting-jquery-plugin.html>

MIT license.

Johann Burkard

<http://johannburkard.de>

<mailto:jb@eaio.com>

jQuery.fn.highlight = function (pat) {

function innerHighlight(node, pat) {

var skip = 0;

if (node.nodeType == 3) {

var pos = node.data.toUpperCase().indexOf(pat);

if (pos >= 0) {

var spannode = document.createElement('span');

spannode.className = 'highlight';

var middlebit = node.splitText(pos);

var endbit = middlebit.splitText(pat.length);

var middleclone = middlebit.cloneNode(true);

spannode.appendChild(middleclone);

middlebit.parentNode.replaceChild(spannode, middlebit);

skip = 1;

}

else if (node.nodeType == 1 && node.childNodes && !/(script|style)/i.test(node.tagName)) {

for (var i = 0; i < node.childNodes.length; ++i) {

i += innerHighlight(node.childNodes[i], pat);

}

return skip;

}

return this.each(function () {

innerHighlight(this, pat.toUpperCase());

});

};

jQuery.fn.removeHighlight = function () {

return this.find("span.highlight").each(function () {

this.parentNode.firstChild.nodeName;

with (this.parentNode) {

replaceChild(this.firstChild, this);

normalize();

}

}).end();

};

Then Add this Script in Head Tag and add TextBox ID in third line..

Dnt delete ClientID, write down it with ur textboxid..

e.g : var value = document.getElementById('<%#urtxtboxid.ClientID%>').value;

function mark() {

var value = document.getElementById('<%#TextBox7.ClientID%>').value;

$('#GridView1').highlight(value);

}

</script>

Then Call Mark() Method from through javascript as ur wish... like 'onmouseover=mark();' OR onblur="mark();" etc......

ENJOY Coding..........by Maf...