Tagged Questions

0
votes
3answers
27 views

Read Excel Numeric cell values as they are in Java

When I am reading excel numeric cell values, i am getting the output with decimals. eg: 79 is reading as 79.0, 0.00 reading as 0.0. The code for my application I have written is: int type = ...
1
vote
0answers
17 views

Dynamic Data to Excel from a JSP page residing in multiple tables under multiple div

I have a JSP Page containing multiple div's and multiple tables in those multiple div's . I am using AJAX call to render data to those tables i.e. data in those tables are rendered dynamically . Now I ...
-1
votes
1answer
23 views

Apache poi - customize text cell

how can I set in apache poi library customize text to cell? E.g.: I have got one cell, but text it's longest than cell, so, I like format text as in excel - adjust the text size cell. Thank you.
-4
votes
1answer
18 views

Translate Text from an Excel in Java [closed]

i hava a simple problem and my head tells me it is very easy: I read some Datas out of a Database and get technical Texts. Now i cant show my customers the technical things and i made a xls which ...
0
votes
2answers
26 views

Converting java file to excel spread sheet

First of all thanks for the previous help. What I want to do is the following. Is to collect information through a small program that can capture in Java and writes it to a file which I have done. ...
1
vote
1answer
27 views

Reading Column values from Excel as string return as decimal?

I have a requirement to read Excel file particular column values. I unable to read the cell values as they are. My code is import java.io.File; import java.io.FileInputStream; import ...
0
votes
2answers
28 views

XLS - Conditional Formatting - Java POI Example

:) Finally after the research I found the solution to my problem, which is not yet satisfied I would like to use conditional formatting to show a line with a yellow color if column B and C to the ...
0
votes
0answers
17 views

createobject(“Excel.Application”)with java is it possible

) Haw can I creat an instance of Excel.Application with Java like this set oXLApp= createobject("Excel.Application") every documentation show VBA and C++
0
votes
1answer
39 views

Conditional format on Excel file

Is that possible to do some conditional format on Excel file with JXL or Apache POI or something else? API java Like Macro VBA for example? ' Mise en forme couleur pour différence For i = 3 To fin ...
0
votes
0answers
21 views

Why can't Jexcel find my column?

I've been using JExcel for a while now and it seems to be being awkward over finding and returning cell contents. The method I wrote has two section: Read column headers until you find a keyword, ...
0
votes
1answer
24 views

How to group the values which are in excel to a HashMap

i have the following excel: Method Name Status Code getLoggedinUserDetails 400 createRequisition 400 excelMDM 400 and i am able to print the values as they are in excel using ...
0
votes
0answers
18 views

sava as pdf a file xls with java program automaticly like Microsoft Excel

I'm totally stuck on the problem of "save as a PDF file xls" with a java program .. I know there are SEVERAL solutions as iText API, appach.poi, but I want an automatic thing (I'm not forcing browse ...
-1
votes
1answer
28 views

Read Excel spreadsheet xml file[Java]

I have Excel spreadsheet xml file(generated from excel via save as Excel XML Spreadsheet 2003) and I need to extract data from it in java. I found similar topic: How to load old Microsoft Office XML ...
0
votes
0answers
45 views

POI Apache - Excel - number of page

I'm using POI Apache for create *.xls. I need write to file about few pages and when I begin write new page, I need write something, but it isn't directly top. It's few rows. How can I do it? It is ...
-3
votes
0answers
14 views

How to evaluate Correl function using Apache POI [closed]

I need to evaluate a cell which contains Correl function. Is there a way to achieve it using Apache POI? I have .xlsx spreadsheets.

1 2 3 4 5 … 64
15 30 50 per page