Tagged Questions

0
votes
0answers
15 views

Finding Cell Location in Excel with Apache POI

I have cell objects that I am writing to from an array of information. What I am trying to do is have it that the program will handle any size of array so the cells are being filled in dynamically i ...
0
votes
2answers
20 views

write to excel in java with Java Excel library -can't open file

I use jxl to write in the following way: WritableWorkbook workbook = Workbook.createWorkbook(new File("output.xls")); WritableSheet sheet = workbook.createSheet("First Sheet", 0); Label label = new ...
-6
votes
1answer
39 views

how can i import an excel file into sqlite android dababase [duplicate]

I have a big excel file containing 4 style sheets. How do I import this file in the SQLite table onCreate method? if there was a way to do a bulk import for the entire file into the table then that ...
-4
votes
1answer
19 views

Extract cell information in excel to place as a table or database on a website using JAVA [closed]

I would like to know how to extract information from an excel cell or ideally a set of cells in several rows and columns and be able to use this information to create a nice looking table or enter the ...
0
votes
1answer
33 views

Writing to excel file with apache poi in android project

I have problem whit getting my project to work i will paste the java files and error log hopefully someone can give me a hint. The app crash when button R.id.bskickaTidSc3 in TidSc3.java is clicked. ...
0
votes
0answers
14 views

Data format management framework

The application I'm working on outputs data in a number of different contexts. HTML, PDF, Excel, JavaScript, and SQL primarily. Most of these have their own way of specifying a display format for a ...
-2
votes
0answers
62 views

Fresh start of browser with parameterization in selenium webdriver [closed]

Sorry if you don't understand headline. My question is we use three notations in selenium webdriver. @beforeclass @afterclass @test i want to parameterize my test case by giving different ...
0
votes
2answers
33 views

Unable to set author and title using Apache POI

I am able to get and set the author and title name but unable to see it in output file. When i see details by clicking right and of my output file , it has old author and title name. please help me.. ...
-1
votes
0answers
26 views

Does POI support array?

I need to use array in Java to store cell values read from excel file. I'm using POI 3.9. Does POI support array? if it does, how to use it? and if it doesn't, is there any alternative way to index ...
0
votes
0answers
29 views

workBook.write(fileoutputstream); writes empty excel file

I am trying to write a excel workbook to a file. Using Apache POI. I debug and found out my workbook have data . Once i write this workbook to FileOutputStream, it successfully writes without any ...
0
votes
2answers
34 views

Excel file manipulation: .NET vs java [closed]

We need to read/write excel files, I was wondering what is the best language between java and C# (and framework or library) to manage excel files. Are there any pros/cons? Thanks.
5
votes
4answers
3k views

Exception when writing to the xlsx document several times using apache poi 3.7

I am getting the following exception while trying to write an .xlsx file using Apache POI: org.apache.xmlbeans.impl.values.XmlValueDisconnectedException It seems the problem is using the method write ...
6
votes
3answers
5k views

Converting JSON to XLS/CSV in Java

Does anyone have any sample Java code to convert a JSON document to XLS/CSV file? I have tried to search on Google but to no avail.
2
votes
0answers
4k views

JXL Number Format and Cell Type

I am using JXL to write an Excel file. The customer wants a certain column to display numbers with one decimal place. They also want the cell types to be "Number". When I use the following (test) ...
4
votes
3answers
1k views

determine version of microsoft office with java

I wrote a program that creates a set of data that is outputted to an excel spreadsheet. I was originally using the jexcel library to write the data to the file, but I'd like to update the program so ...

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