Stack Overflow
Stack Overflow

Questions tagged [hssf]

HSSF provides Java APIs to read / write Microsoft Excel 2003 and before (.xls) files. This tag should be used for questions about accessing Excel 2003 files from Java applications. HSSF is managed under the Apache POI Project.

HSSF provides Java APIs to read / write Microsoft Excel 2003 and before (.xls) files. This tag should be used for questions about accessing Excel 2003 files from Java applications. HSSF is managed under the Apache POI Project.

More information on HSSF, the bug tracker and download links are available from http://poi.apache.org/spreadsheet/index.html

If you are starting with Apache POI, you may find the Busy Developer's link very useful: http://poi.apache.org/spreadsheet/quick-guide.html

117 questions
0
votes
0 answers

Set filter criteria in .xls excel file using HSSF POI jar and without using any kind of Loop

I'm able to set filter criteria but with the help of for loop. The following code travel through each row and each column of the excel sheet and do the filter operation. Is there any method that we can directly enable the specific criteria without…
user2791890
  • 11
  • 4
0
votes
0 answers

POI HSSF class missing for Tika-app-1.10

For legacy reasons I was using org.apache.poi.hssf.record.formula.UnaryPlusPtgclass in my project. but due to Tika parser's dependency resolution issues, I had to delete old POI jar files from the project. Now the build fails because of…
ha9u63a7
  • 6,233
  • 16
  • 73
  • 108
0
votes
1 answer

How I can read excel file and set value to null

I want to read a excel file and if there is any data then I want to set it to null then start writing to it. This is what I have for setting excel sheet data to null. I able to write successfully but before write I want to set the value null.…
user557657
  • 856
  • 1
  • 12
  • 35
0
votes
1 answer

Cannot get a text value from a numeric cell despite adding dateformatter

Cannot get a text value from a numeric cell. Used date formatter and it didn't work out. Converted to string as well. That too didn't work well. if(isCellEmpty(sheet.getRow(i).getCell(j))) { System.out.println("Phone Number…
Robert Dsilva
  • 81
  • 1
  • 2
  • 10
0
votes
1 answer

I get the comma seperator iin excel cell as dot in c#

I have got a very strange problem : for reading excel I use NPOI nget package and my code is HttpPostedFileBase file = Request.Files[0]; string fileName = file.FileName; Stream filestream = file.InputStream; …
Tania Marinova
  • 1,788
  • 8
  • 39
  • 67
0
votes
1 answer

How to remove user-defined style for XLS via ApachePOI?

I want remove some predefined styles for XLS - for example "Good". For XLSX there is no problem: create new CTCellStyle (unfortunatelly by reflection), setName("Good"), setBuiltinId(26) and setHidden(true) - now Excel (2016) doesn’t show "Good"…
Piotr
  • 23
  • 3
0
votes
1 answer

string automatically converted in spring

I'm working on a project in Spring using SpringMVC. I'm importing data from (.xls) files . the problem is that: I'm reading this value "945854955" as a String but saved in DB as "9.45854955E8" this value "26929" saved as "26929.0" this value…
yb3prod
  • 564
  • 2
  • 10
  • 22
0
votes
1 answer

How to get simple info about XSSFChart?

I want to get info like x, y, width, height, title of the chart. Here is my version for HSSFChart which works (It returns non-zero values): HSSFChart chart title = chart.getChartTitle(); x = chart.getChartX(); y = chart.getChartY(); width =…
SzikakaPupu
  • 3
  • 4
0
votes
1 answer

how get entire retrieved tabled data into excel in jsp

I'm using this code but only row of table data is entered into file.. .I'm using mysql database. connection is established in connection.jsp. tablename is login. using poi-2.5.1.jar file. this code is working without any error but how to get entire…
sangu sainath varma
  • 7
  • 1
  • 7
0
votes
1 answer

Cannot find class on runtime even after including the jar files in the classpath

I am trying to use the apache poi api. I have downloaded the jar libraries. This is the code that I have written. The name of the file is Main.java. /* package whatever; // don't place package name! */ import java.util.*; import java.lang.*; import…
odbhut.shei.chhele
  • 5,834
  • 16
  • 69
  • 109
0
votes
0 answers

Delete duplicate rows from excel with HSSF POI

So i have a file which comes from a third party which we edit and save with our application. We use HSSF library for that. Now that file comes with some of the duplicate rows and when we edit it, it edits on all the duplicate lines. So when we try…
arpan shah
  • 277
  • 2
  • 18
0
votes
0 answers

creating multiple pdfs from multiple excel files that support both formats in java

below is my code to convert excel to pdf, but i dont understand how do i generate multiple pdf from multiple excel sheets. String files; File folder = new File(dirpath); File[] listOfFiles = folder.listFiles(); for (int i = 0; i <…
Neha Thawani
  • 1
  • 3
0
votes
1 answer

Null pointer exception while returning cell value from excel

I have the following code private void execute_TestCase() throws Exception { int iTotalTestCases = ExcelUtils.getRowCount(Constants.Sheet_TestCases); System.out.println("Total TC count" + iTotalTestCases); …
user1700354
  • 107
  • 2
  • 3
  • 15
0
votes
1 answer

HSSF How to write result in Excel by using Constant Int column number

I'm new to Java and Selenium, Selenium is quite fun, I'm working on Selenium WebDriver with TestNG Data Driven framework. by refer to this…
christo
  • 93
  • 2
  • 4
  • 11
0
votes
0 answers

POI: How to get the design color from XSSF?

I have a big cell style problem with poi and XSSF. EDIT 2015-01-06: The green cell has a design color und the blue cell a standard color. The standard color works good, but the design color only works with HSSF. How can i get the design color of a…
Smoothi
  • 283
  • 1
  • 3
  • 15
1 2 3 4 5
6
7 8