地址
- 创建并初始化
<div id="maingrid" style="position: static; width: 100%; height: 100%; box-sizing: border-box ">
<div id="grid" style="position: relative; width: 1200px; height: 600px; "> </div>
</div>
<script type="text/javascript">
var domgrid = document.getElementById("grid");
var input = document.getElementById("maininput");
var grid = new DataExcel();
grid.Width = domgrid.Width;
grid.Height = domgrid.Height;
grid.InitDom(domgrid);
grid.InitEdit(input);
grid.Refresh();
grid.Paint();
grid.On(Events.FocusedCellChanged, FocusedCellChanged);
function FocusedCellChanged(args)
{
console.log("事件触发测试:" + args);
}
</script>
2、行，列，单元格 插入，删除操作
<script type="text/javascript">
function HideRow()
{
try
{
if (grid.SelectCells != null)
{
let min = grid.SelectCells.MinRow();
let max = grid.SelectCells.MaxRow();
for (var i = min; i <= max; i++)
{
let row = grid.GetRow(i);
row.Visible = false;
}
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function HideColumn()
{
try
{
if (grid.SelectCells != null)
{
let min = grid.SelectCells.MinColumn();
let max = grid.SelectCells.MaxColumn();
for (var i = min; i <= max; i++)
{
let column = grid.GetColumn(i);
column.Visible = false;
}
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function ShowRow()
{
try
{
if (grid.SelectCells != null)
{
let min = grid.SelectCells.MinRow();
let max = grid.SelectCells.MaxRow();
for (var i = min; i <= max; i++)
{
let row = grid.GetRow(i);
row.Visible = true;
}
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function ShowColumn()
{
try
{
if (grid.SelectCells != null)
{
let min = grid.SelectCells.MinColumn();
let max = grid.SelectCells.MaxColumn();
for (var i = min; i <= max; i++)
{
let column = grid.GetColumn(i);
column.Visible = true;
}
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function FrozenRow()
{
try
{
if (grid.FocusedCell != null)
{
grid.FrozenRow = grid.FocusedCell.Row.Index;
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function FrozenColumn()
{
try
{
if (grid.FocusedCell != null)
{
grid.FrozenColumn = grid.FocusedCell.Column.Index;
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function FrozenCell()
{
try
{
if (grid.FocusedCell != null)
{
grid.FrozenColumn = grid.FocusedCell.Column.Index;
grid.FrozenRow = grid.FocusedCell.Row.Index;
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function InsertRow()
{
try
{
if (grid.SelectCells != null)
{
let min = grid.SelectCells.MinRow();
let max = grid.SelectCells.MaxRow();
for (var i = min; i <= max; i++)
{
grid.InsertRow(i);
}
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function InsertColumn()
{
if (grid.SelectCells != null)
{
let min = grid.SelectCells.MinColumn();
let max = grid.SelectCells.MaxColumn();
for (var i = min; i <= max; i++)
{
grid.InsertColumn(i);
}
grid.Refresh();
grid.RePaint();
}
}
function DeleteRow()
{
try
{
if (grid.SelectCells != null)
{
let min = grid.SelectCells.MinRow();
let max = grid.SelectCells.MaxRow();
for (var i = min; i <= max; i++)
{
grid.DeleteRow(i);
}
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function DeleteColumn()
{
if (grid.SelectCells != null)
{
let min = grid.SelectCells.MinColumn();
let max = grid.SelectCells.MaxColumn();
for (var i = min; i <= max; i++)
{
grid.DeleteColumn(i);
}
grid.Refresh();
grid.RePaint();
}
}
function DeleteCellRow()
{
try
{
if (grid.SelectCells != null)
{
grid.DeleteCellRow(grid.SelectCells);
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function InsertCellRow()
{
try
{
if (grid.SelectCells != null)
{
grid.InsertCellRow(grid.SelectCells);
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function DeleteCellColumn()
{
try
{
if (grid.SelectCells != null)
{
grid.DeleteCellColumn(grid.SelectCells);
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function InsertCellColumn()
{
try
{
if (grid.SelectCells != null)
{
grid.InsertCellColumn(grid.SelectCells);
grid.Refresh();
grid.RePaint();
}
} catch (e)
{
console.log(e);
}
}
function Merge()
{
if (grid.SelectCells != null)
{
let mergecell = grid.Merge(grid.SelectCells);
console.log(mergecell);
grid.FocusedCell = mergecell;
grid.SetSelectCells(mergecell.BeginCell, mergecell.EndCell);
console.log(grid.SelectCells);
grid.Refresh();
grid.RePaint();
}
}
function UnMerge()
{
if (grid.SelectCells != null)
{
grid.UnMerge(grid.SelectCells);
grid.RePaint();
}
}
function Paste()
{
if (grid.SelectCells != null)
{
grid.Paste();
grid.Refresh();
grid.RePaint();
}
}
function PasteStyle()
{
if (grid.SelectCells != null)
{
grid.PasteStyle();
grid.Refresh();
grid.RePaint();
}
}
function Copy()
{
if (grid.SelectCells != null)
{
grid.Copy();
grid.Refresh();
grid.RePaint();
}
}
function Cut()
{
if (grid.SelectCells != null)
{
grid.Copy();
grid.Refresh();
grid.RePaint();
}
}
function MultLine()
{
let list = grid.GetSelectCells();
for (let i in list)
{
let cell = list[i];
cell.AutoMultiline = !cell.AutoMultiline;
}
grid.Refresh();
grid.RePaint();
}
function ShowRowHeader()
{
grid.ShowRowHeader = !grid.ShowRowHeader;
if (grid.Charts != null)
{
grid.Charts.Refresh();
}
grid.Refresh();
grid.RePaint();
}
function ShowColumnHeader()
{
grid.ShowColumnHeader = !grid.ShowColumnHeader;
if (grid.Charts != null)
{
grid.Charts.Refresh();
}
grid.Refresh();
grid.RePaint();
}
function LockHeader()
{
//grid.LockColumnHeader = !grid.LockColumnHeader;
//grid.LockRowHeader = !grid.LockRowHeader;
if (grid.Charts != null)
{
grid.Charts.Refresh();
}
grid.Refresh();
grid.RePaint();
}
function VScrollVisible()
{
grid.VScroll.Visible = !grid.VScroll.Visible;
grid.Refresh();
grid.RePaint();
}
function HScrollVisible()
{
grid.HScroll.Visible = !grid.HScroll.Visible;
grid.Refresh();
grid.RePaint();
}
function ShowBorder()
{
grid.ShowBorder = !grid.ShowBorder;
grid.Refresh();
grid.RePaint();
}
function ShowSelectBorder()
{
grid.ShowSelectBorder = !grid.ShowSelectBorder;
grid.Refresh();
grid.RePaint();
}
function DefaultColumnWidth()
{
grid.DefaultColumnWidth = 20;
grid.Refresh();
grid.RePaint();
}
function TestBackImage()
{
var code = prompt("输入图片链接:", "../Image/test/96434.png");
grid.FocusedCell.BackImage = code;
grid.Refresh();
grid.RePaint();
}
function GridBackImage()
{
var code = prompt("输入图片链接:", "../Image/test/96434.png");
grid.BackImage = code;
grid.Refresh();
grid.RePaint();
}
function GridBackImageLayoutNone()
{
grid.BackImageImageLayout = ImageLayout.None;
grid.Refresh();
grid.RePaint();
}
function GridBackImageLayoutClip()
{
grid.BackImageImageLayout = ImageLayout.Clip;
grid.Refresh();
grid.RePaint();
}
function GridBackImageLayoutStretch()
{
grid.BackImageImageLayout = ImageLayout.Stretch;
grid.Refresh();
grid.RePaint();
}
function GridBackImageLayoutZoom()
{
grid.BackImageImageLayout = ImageLayout.Zoom;
grid.Refresh();
grid.RePaint();
}
function GridBackImageLayoutZoomClip()
{
grid.BackImageImageLayout = ImageLayout.ZoomClip;
grid.Refresh();
grid.RePaint();
}
///
function ImageLayoutNone()
{
grid.FocusedCell.BackImageImageLayout = ImageLayout.None;
grid.Refresh();
grid.RePaint();
}
function ImageLayoutClip()
{
grid.FocusedCell.BackImageImageLayout = ImageLayout.Clip;
grid.Refresh();
grid.RePaint();
}
function ImageLayoutStretch()
{
grid.FocusedCell.BackImageImageLayout = ImageLayout.Stretch;
grid.Refresh();
grid.RePaint();
}
function ImageLayoutZoom()
{
grid.FocusedCell.BackImageImageLayout = ImageLayout.Zoom;
grid.Refresh();
grid.RePaint();
}
function ImageLayoutZoomClip()
{
grid.FocusedCell.BackImageImageLayout = ImageLayout.ZoomClip;
grid.Refresh();
grid.RePaint();
}
/* <img src="../Image/test/96434.png" />*/
</script>
