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

TNeuschwanger's avatar
TNeuschwanger
Champion Level 1

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
4 years ago

nmrao  It has to be xls because the importer we have to test doesn't accept anything else. To write everything in a csv and manually save it as xls was my first approach. But I'd like to avoid that.

 

TNeuschwanger 

I tried Number number = new Number before but I also got errormessages for that. Your codes works 😃

 

 Thank you so much (to both of you) for your time and help

 

 

For everyone who needs something similar for other objects:

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)
   }
   if (val instanceof NullObject) {
      Blank blank = new Blank(indx, 1, val)
      sheet.addCell(blank)
   }
   if (val instanceof BigDecimal) {
      Number number = new Number(indx, 1, val)
      sheet.addCell(number)
   }
   if (val instanceof Date) {
      DateTime dateTime  = new DateTime(indx, 1, val)
      sheet.addCell(dateTime)
   }
}