How to create and save Excel file to DAM using java

-

i trying create 1 excel sheet , save dam.i able create excel in dam, no data there in excel. using following codes create it.

 

string filename = "updatedmetadata.xls";

    fileoutputstream fos = new fileoutputstream(filename);

    writableworkbook workbook = workbook.createworkbook(new file(filename));

    writablesheet writablesheet = workbook.createsheet("updated metadata", 0);

    label label = null;

    label = new label(0, 0, "header1");

    writablesheet.addcell(label);

    label = new label(0, 1, "header2");

    writablesheet.addcell(label);

    label = new label(0, 2, "header3");

    writablesheet.addcell(label);

    label = new label(0, 3, "header4");

    writablesheet.addcell(label);

    label = new label(0, 4, "header5");

    writablesheet.addcell(label);

    label = new label(0, 5, "header6");

    writablesheet.addcell(label);

    label = new label(0, 6, "header7");

    writablesheet.addcell(label);

    label = new label(0, 7, "header8");

    writablesheet.addcell(label);

    label = new label(1, 0, "col val");

    writablesheet.addcell(label);

    label = new label(1, 1, "col val");

    writablesheet.addcell(label);

    label = new label(1, 2, "col val");

    writablesheet.addcell(label);

    label = new label(1, 3, "col val");

    writablesheet.addcell(label);

    label = new label(1, 4, "col val");

    writablesheet.addcell(label);

    label = new label(1, 5, "col val");

    writablesheet.addcell(label);

    label = new label(1, 6, "col val");

    writablesheet.addcell(label);

    label = new label(1, 7, "col val");

    writablesheet.addcell(label);

    label = new label(2, 0, "col val");

    writablesheet.addcell(label);

    label = new label(2, 1, "col val");

    writablesheet.addcell(label);

    label = new label(2, 2, "col val");

    writablesheet.addcell(label);

    label = new label(2, 3, "col val");

    writablesheet.addcell(label);

    label = new label(2, 4, "col val");

    writablesheet.addcell(label);

    label = new label(2, 5, "col val");

    writablesheet.addcell(label);

    label = new label(2, 6, "col val");

    writablesheet.addcell(label);

    label = new label(2, 7, "col val");

    writablesheet.addcell(label);

    workbook.write();

    workbook.close();

    resourceresolver resourceresolver = request.getresourceresolver();

    assetmanager manager = resourceresolver.adaptto(assetmanager.class);

    inputstream = this.getclass().getresourceasstream("/content/dam/company/filefolder/" + filename);

    asset asset = manager.createasset("/content/dam/company/filefolder/" + filename, is, "application/vnd.ms-excel", true);

 

file creating in path "/content/dam/company/filefolder/"

file name "updatedmetadata.xls"

 

 

thanks in advance

mahesh narayanan

i found myself. sharing code in future else can use it.

 

string filename = "updatedmetadata.xls";

  file excelfile = new file(filename);

  writableworkbook workbook = workbook.createworkbook(excelfile);

  writablesheet writablesheet = workbook.createsheet("updated metadata", 0);

 

    label label = null;

    label = new label(0, 0, "header1");

    writablesheet.addcell(label);

    label = new label(0, 1, "header2");

    writablesheet.addcell(label);

    label = new label(0, 2, "header3");

    writablesheet.addcell(label);

    label = new label(0, 3, "header4");

    writablesheet.addcell(label);

    label = new label(0, 4, "header5");

    writablesheet.addcell(label);

    label = new label(0, 5, "header6");

    writablesheet.addcell(label);

    label = new label(0, 6, "header7");

    writablesheet.addcell(label);

    label = new label(0, 7, "header8");

    writablesheet.addcell(label);

    label = new label(1, 0, "col val");

    writablesheet.addcell(label);

    label = new label(1, 1, "col val");

    writablesheet.addcell(label);

    label = new label(1, 2, "col val");

    writablesheet.addcell(label);

    label = new label(1, 3, "col val");

    writablesheet.addcell(label);

    label = new label(1, 4, "col val");

    writablesheet.addcell(label);

    label = new label(1, 5, "col val");

    writablesheet.addcell(label);

    label = new label(1, 6, "col val");

    writablesheet.addcell(label);

    label = new label(1, 7, "col val");

    writablesheet.addcell(label);

    label = new label(2, 0, "col val");

    writablesheet.addcell(label);

    label = new label(2, 1, "col val");

    writablesheet.addcell(label);

    label = new label(2, 2, "col val");

    writablesheet.addcell(label);

    label = new label(2, 3, "col val");

    writablesheet.addcell(label);

    label = new label(2, 4, "col val");

    writablesheet.addcell(label);

    label = new label(2, 5, "col val");

    writablesheet.addcell(label);

    label = new label(2, 6, "col val");

    writablesheet.addcell(label);

    label = new label(2, 7, "col val");

    writablesheet.addcell(label);

    workbook.write();

    workbook.close();

    resourceresolver resourceresolver = request.getresourceresolver();

    assetmanager manager = resourceresolver.adaptto(assetmanager.class);

    inputstream stream = new fileinputstream(excelfile);

    asset asset = manager.createasset("/content/dam/company/filefolder/" + filename, is, "application/vnd.ms-excel", true);



More discussions in JavaScript


adobe

Comments

Post a Comment

Popular posts from this blog

Why is os_ViewContainer running?

-
when open illustrator (cc) opens window os_viewcontainer cannot view or close. shows in taskbar second window illustrator when mousing on ai icon. have tried select no luck. have tried clear using red x, no luck. close when close illustrator. wondering why there , if should concerned. oh, running windows 10. hi ccsachs,   as per query when launch illustrator opens " os_viewcontainer "   i request please share screenshots along below-mentioned details:   exact version of illustrator  graphic card using , when updated last time how performs in safe mode? ( https://support.microsoft.com/en-in/help/12376/windows-10-start-your-pc-in-safe-mode ) if works fine in safe mode please share antivirus using?   regards srishti More discussions in Illustrator adobe
Read more

Animate - problem with duplicating scripts after loop

-
hi all,   i have problem simple button script @ first frame. fine when timeline playing first time. after when timeline loops , stop again @ 0 frame button script fireing 2 times, when loops third time fireing 3 times etc...   here script:   this.stop(); exportroot.mc_cta.cursor = "pointer";   this.mc_cta.on("click", clickfunc.bind(this));   function clickfunc() {     console.log("clicked");     eb.useractioncounter("clicked");     exportroot.gotoandplay(1); }   anybody ideas? wrong?   thanks! kris use:   this.stop(); exportroot.mc_cta.cursor = "pointer";   if(!this.alreadyexecuted){ this.alreadyexecuted=true; this.mc_cta.on("click", clickfunc.bind(this));   function clickfunc() { console.log("clicked"); eb.useractioncounter("clicked"); exportroot.gotoandplay(1); } } More discussions in Adobe Animate CC - General adobe
Read more

Illustrator CS6 Ocurrío un error E/S en el archivo.

-
este error me me sale cada ves que guardo un archivo que ya estado trabajando varias veces, sale cuando ya esta finalizando el proceso de guardar, ya probe cambiar nombre del archivo, ubicación de guardado, convertí curvas las fuentes y sigue saliendo el mismo error, no se que mas hacer, si alguien le ha sucedido y sabe como solucionarlo por favor ayuda. versión exacta (acerca de illustrator) de illustrator? versión sistema operativo?   guardas en el disco duro principal del ordenador o en otro disco, memoria pendrive,...? ese disco que clase de disco, modelo, antiguedad, espacio libre,...? More discussions in Foro en español adobe
Read more