Skip to main content
MaheshNarayanan
Participant
July 26, 2016
Answered

How to create and save Excel file to DAM using java

  • July 26, 2016
  • 1 reply
  • 1714 views

I am trying to create one excel sheet and save it into DAM.I am able to create excel in DAM, but no data is there in that excel. I am using following codes to 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 is = this.getClass().getResourceAsStream("/content/dam/company/fileFolder/" + filename);

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

File is creating in this Path "/content/dam/company/fileFolder/"

File name is "updatedMetadata.xls"

Thanks in advance

Mahesh Narayanan

This topic has been closed for replies.
Correct answer MaheshNarayanan

I found it myself. I am sharing the code so that in future someone 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);

1 reply

MaheshNarayanan
MaheshNarayananAuthorCorrect answer
Participant
July 27, 2016

I found it myself. I am sharing the code so that in future someone 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);

try67
Community Expert
Community Expert
July 27, 2016

Why did you post all of this to the Adobe forums? This has nothing to do with any Adobe product, as far as I can see.