Swapnil Sanghai

I am unable to set the background color for excel(.xlsx) cell using apache poi.
Please suggest which is useful method.

Below is the code used to set the background color -

summarySheet = workBook.createSheet("Sample"); sheetRow = summarySheet.createRow(0); headerStyle = workBook.createCellStyle(); headerStyle.setFillBackgroundColor(IndexedColors.YELLOW.getIndex()); dataCell = sheetRow.createCell(intCounter); dataCell.setCellValue("TESTNAME"); dataCell.setCellStyle(headerStyle);

Hi All,

I tried below method to auto size the column width in xlsx file using apache poi

sheetName.autoSizeColumn(columnIndex);

This is not working for me as the column width is not getting changed.

Please help me on this.

I understood it, but here i want to use POI only.
Can you please tell me how can i resolve it.
I am trying to get answers from different sites but its not working.

Thanks.

Hi i used below code to create file,

public class Example { public static void main(String[] args){ File newFile = new File("D:\\Test.xls"); FileOutputStream fos = null; if (!newFile.exists()){ try { newFile.createNewFile(); } catch (IOException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } }else{ newFile.delete(); } try { fos = new FileOutputStream(newFile); } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { fos.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

File is getting created successfully, but when i open it manually just to see i am getting pop saying "the file format and extension of 'Test.xls' does not match".

Please refer attached image.

Paul Clapham wrote:

Swapnil Sanghai wrote:@ Paul Clapham - Apart from this I wanted to know other way to handle this situation.

Okay, you could also use a setter method in the User class and pass the Target reference in that way. I will leave you to modify my example to do that.

Thanks Paul.

@ Paul Clapham - Apart from this I wanted to know other way to handle this situation.

Campbell Ritchie wrote:Do you mean pass them as method arguments or as constructor arguments?

Yes somewhat like that but not as method arguments or constructor arguments. I should be able to access reference of the object created in multiple classes but initialization will be done once.

Please find below detailed description,
I have created two classes say Class ABC and Class XYZ.

Both the classes are from same package say Package Sample.

I have created object of Class ABC in that class itself and now I want to use/pass recently created object reference of the Class ABC to Class XYZ.

Please let me know all possible ways.

Also please let me know if you need more detailed description on this.

How can I pass object created in one class to the other class.(Both classes are in same package)

I am not able to see content of the javascript in html file when i include javascript file into the HTML file using src attribute in the tag <Script>

Can anyone please let me know if we can read the excel with the help of ADODB.

Can anyone let me know how to read data from excel file without JDBC connection.