Jan 09
// ACTION SCRIPT FOR YOUR FLEX APP
function doCopy(dg)
{
var font = dg.getStyle('fontFamily');
var size = dg.getStyle('fontSize');
var hcolor ;
if (dg.getStyle("headerColor") != undefined)
hcolor = [dg.getStyle("headerColor")];
else
hcolor = dg.getStyle("headerColors");
var str:String = '<html><body><table width="'+dg.width+'"><thead><tr width="'+dg.width+'" style="background-color:#' +Number((hcolor[0])).toString(16)+'">';
for (var i=0;i<dg.__columns.length;i++) {
var colors = dg.getStyle("themeColor");
var style = 'style="font-family:'+font+';font-size:'+size+'pt;"';
if (dg.__columns[i].headerText != undefined) {
str+="<th "+style+">"+dg.__columns[i].headerText+"</th>";
}
else {
str+= "<th "+style+">"+dg.__columns[i].columnName+"</th>";
}
}
str += "</tr></thead><tbody>";
var colors = dg.getStyle("alternatingRowColors");
for (var j=0;j<dg.length;j++) {
str+="<tr width=\""+Math.ceil(dg.width)+"\" style='background-color:#" +Number((colors[j%colors.length])).toString(16)+"'>";
var style = 'style="font-family:'+font+';font-size:'+size+'pt;"';
for (var i=0;i<dg.__columns.length;i++) {
if (dg.getItemAt(j) != undefined && dg.getItemAt(j) != null)
if (dg.__columns[i].labelFunction != undefined)
str += "<td width=\""+Math.ceil(dg.__columns[i].width)+"\" "+style+">"+ dg.__columns[i].labelFunction(dg.getItemAt(j),dg.__columns[i].columnName)+"</td>";
else
str += "<td width=\""+Math.ceil(dg.__columns[i].width)+"\" "+style+">"+ dg.getItemAt(j)[dg.__columns[i].columnName]+"</td>";
}
str += "</tr>";
}
str+="</tbody></table></body></html>";
System.setClipboard(str);
}
function handleOnKeyUp()
{
if (Key.isDown(Key.CONTROL) &&Key.getCode() ==67) {
mx.managers.CursorManager.setBusyCursor();
doCopy(grid); // exchange 'grid' with the id of your datagrid you want copied
mx.managers.CursorManager.removeBusyCursor();
}
}
// only register interest if you want ctrl-c to process a copy of a datagrid.
// it's also ctrl + c (on key up, not down)
var obj:Object;
function registerKeyInterest()
{
if (obj == undefined) {
obj = new Object();
obj.onKeyUp = mx.utils.Delegate.create(this,handleOnKeyUp);
}
Key.addListener(obj);
}
function removeKeyInterest()
{
Key.removeListener(obj);
}
function copyAndOpen(grid)
{
doCopy(grid);
getUrl("javascript:openExcel();");
}
// JAVASCRIPT for your HTML PAGE
<SCRIPT Language="JavaScript1.2">
var excel = null;
function openExcel()
{
try {
if (excel == null) {
excel = new ActiveXObject("Excel.Application");
}
var workbook = excel.Workbooks.Add();
workbook.Activate();
var worksheet = workbook.Worksheets("Sheet1");
worksheet.Activate();
worksheet.Paste();
excel.visible=true;
}
catch(exception) {
window.alert("Now you may Paste into an Excel SpreadSheet");
}
}
</SCRIPT>
Tags »Excel2003|export|Flex/Flash 
