Create Excel with Java format text

When I download Excel, I get cells with format Numbers I need format text en all Cells.
try {
            XSSFSheet sheet = workbook.createSheet(eyelash);

            XSSFFont font = workbook.createFont();
            font.setColor(HSSFColor.WHITE.index);
            XSSFCellStyle style = workbook.createCellStyle();
            style.setFont(font);
            style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
            style.setFillForegroundColor(HSSFColor.RED.index);


            String[] header = { "name","surname"},
                    "Ceco", "Volumen" };
            XSSFRow rowhead = sheet.createRow((short) 0);
            XSSFCell cell;
            int cellnum = 0;

            for (int i = 0; i < header.length; i++) {
                cell = rowhead.createCell(cellnum);
                cell.setCellValue(header[i]);
                cell.setCellStyle(style);
                cell.setCellType(XSSFCell.CELL_TYPE_STRING);
                cellnum++;
            }

            if (data) {
                int myRowData = 1;
                XSSFRow row = sheet.createRow((short) myRowData);
                ArrayList<GasNomination> list = mlService.selectAllGasNomination();

                for (int i = 0; i < list.size(); i++) {

                    row.createCell(0).setCellValue(list.get(i).name());
                    row.createCell(1).setCellValue(list.get(i).surname());

                    myRowData++;
                    row = sheet.createRow((short) myRowData);
                }
            }

        } catch (Exception ex) {

        }
I tried cell.setCellType(XSSFCell.CELL_TYPE_STRING); But when I open my Excel I see formatcell type numeric ...

Комментарии

Отправить комментарий

Популярные сообщения из этого блога

Unable to construct Application instance [duplicate]

This question already has an answer here: Unable to construct javafx.application.Application instance 1 answer I am trying to launch in my public class an application defined in another class, earning the "Unable to construct Application instance"-Exception.The example (below) is quite minimalistic. What am I missing?---Clues would be very much appreciated. This question is different than the question Unable to construct javafx.application.Application instance as I would like to have the definition of an application and its launch in separate classes. import javafx.application.Application; import javafx.scene.Scene; import javafx.scene.control.Button; import javafx.stage.Stage; public class Main {     public static void main(String[] args) {         Application.launch(OKButton.class, args);     } } class OKButton extends Application {     @Override     public void start(Stage stage) {       ...
Далее...

What is considered 'insulting a Muslim'? And is it a sin? If so, is it a minor or major scene?

Assalamu 'Alaikum, My question is kinda lengthy here. So, the important question is regarding a situation. So, there was this guy who bought a wrong book, since it had the same name but the book had a different number on it. Everybody was laughing, not as insult though, just because the situation was funny when he realised he was doing the wrong sums from the wrong book. So, when everybody was commenting on it, someone said, obviously as a joke, "can't you read numbers?" and laughed it off. The guy who bought the wrong book obviously didn't mind and now, he probably doesn't even remember about that remark since everybody was talking. Now, it is not even a valid insult because it has nothing to do with him not being able to read numbers. He didn't specify the book number and that's how he got the wrong book. The insult is kinda like jokingly calling Albert Einstein stupid because he forgot his pen or something. And the person who "insulted...
Далее...