Forum Discussion

Cekay's avatar
Cekay
Contributor
4 years ago

Use different format cells while create Excel file

Hello I have a simple script to create a test data and put that into an Excel file and that is working so far but the import of these files doesn't work because the format is not correct. 1. Some o...
Scripting
  • TNeuschwanger's avatar
    TNeuschwanger
    4 years ago

    Hello Cekay, 

     

    The data type of the Label object is String.  You are attempting to force an integer to a string and the date type police have said that is a violation.  🙂

     

    I have taken the liberty to rewrite the offending code into something a little more groovyish...

     

    //for(int i=0;i<merchant.size();i++){
//Label label = new Label(i, 1, merchant[i]); // i = column=0=A, row=1
//sheet.addCell(label)
//log.info merchant[i]
//}

merchant.eachWithIndex { val, indx ->
   log.info val.getClass();
   if (val instanceof Integer) {
      Number number = new Number(indx, 1, val);
      sheet.addCell(number);
   };
   if (val instanceof String) {
      Label label = new Label(indx, 1, val);
      sheet.addCell(label);
   ;
};

     

     

    What you use in the .addCell() method is data type dependent.  If you need other data types other than a string or number, you will have to google for other examples (I just looked for solution only to your issue).

     

    Regards,

    Todd

Cekay's avatar
Cekay
Contributor

Yeah CSVs and Json files are easy. I do that all the time. But unfortunately this special test needs a xls.

Or is there a way to create the file as csv and convert afterwards to xls? (xlsx is also not allowed) :X

nmrao's avatar
nmrao
Champion Level 3
4 years ago
Are you using any excel functionality?
Otherwise csv is simple text file to handle as pointed and doing.

One can open csv file in Excel and save as required extension such as .xls /.xlsx if required. But again one should not land into issue while reading. And avoid manual process of save as excel if possible.