Error Export To Excel Header?

[Former Member]

Hi @,

I am using Export to excle by Binary Cache in my application which is generating the Excle but it is not formatted properly and there is no filter coming. Instead the headre is coming as an XPATH expression like /Pay/Amout /Pay/Name etc and also it is not in order but sorted order.

How can I remove these Header expression and get in in my order?

Regards,

[Former Member]

Hi,

Go through the following Blog

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4591] [original link is broken] [original link is broken] [original link is broken];

and also thread which will help you

[]

Regards

Raghu

[former_member192434]

Hi Amit,

Try to create excel formating explicitly by using following code.

java.io.File f = new java.io.File("output.xls");

WritableWorkbook workbook = Workbook.createWorkbook(f);

WritableFont red = new WritableFont(WritableFont.ARIAL,

WritableFont.DEFAULT_POINT_SIZE,

WritableFont.BOLD,

false,

UnderlineStyle.SINGLE,

Colour.DARK_BLUE);

WritableCellFormat redFormat = new WritableCellFormat(red);

WritableFont blue = new WritableFont(WritableFont.ARIAL,

WritableFont.DEFAULT_POINT_SIZE,

WritableFont.NO_BOLD,

false,

UnderlineStyle.NO_UNDERLINE,

Colour.BLACK);

WritableCellFormat blueFormat = new WritableCellFormat(blue);

WritableSheet sheet = workbook.createSheet("First Sheet", 0);

// String ab=wdContext.nodeFlight_List().getNodeInfo().getAttribute("Airline").getName();

jxl.write.Label label = new jxl.write.Label(0, 0, "Id", redFormat);

sheet.addCell(label);

label = new jxl.write.Label(1,0,"No",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(2,0,"Arrival city",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(3,0,"Depart",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(4,0,"Depart. city",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(5,0,"Curr.",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(6, 0,"Airline",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(7,0,"Airport",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(8,0,"ISO",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(9,0,"Apt",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(10,0,"Airfare",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(11,0,"Arrival Date",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(12,0,"Arrival",redFormat);

sheet.addCell(label);

label = new jxl.write.Label(13,0,"Date",redFormat);

sheet.addCell(label);

Thanks

Anup

[Former Member]

Hi Anup,

But this is based upon third party API if I am correct . I am not using it I am using direct Binary Cache.

Regards