is there a method to print the sheet ?
View this message in context http //www.nabble.com/printing-sheet-%28hssf%29-tf2970244.html#a8311273
Sent from the POI - User mailing list archive aThis is more of a request/suggestion than a bug report...
The same files that caused the "Worksheet/WORKSHEET " issue a month or
two ago (excel files generated by Crystal Reports) also have a bad haI am generating a spareadsheet by reading off a template excel spreadsheet
that has macro 's and form elements like buttons labels etc and then adding
data to the spreasdheet with POI. This was workiDear experts
I am using POI EventModel to read Excel file. All things works fiine but I
could not get the value with formula cell.
Is there any advice?
I 'm wondering.. Am i doing something stupid here or is my poi build
It looks very basic the behavior is unexpected the lib is over 2 years
old now and I havI have a spreadsheet with cells that have values like "? " and "? ". I guess these are unicode but I 'm not certain. When I read these values with "HSSFCell.getStringCellValue() " it seems to corrupt
I tried alpha 2 and alpha 3 releases of POI but on both of them I get
the following error when trying to generate large Excel reports
I 'm using poi-2.5.1-final and ran into an issue with POI. Our app gives
users the ability to download spreadsheets and some spreadsheets have ~6000
rows with 10 columns. Also at any time many users coI have a custom file that is spit out by a vendor program that I need to modify. Viewing this file in a HEX viewer the first 512 bytes of the header match the specs for a OLE2CDF file but it 's totalHello
I am using the org.apache.poi.hwpf.extractor.WordExtractor class to
extract the text from MS Word documents. The problem is that the output
includes not only the text of interest but also sAndrew C. Oliver <acoliver <at > apache.org > writes
> I 'm sorry autosizing has not yet been implemented. Its a contribution
Since I can 't see what year this post Hi there
I am a newbie to this list.
For my open-source project I wrote a search solution using lucene
that can extract text content from binary files.
For MS-Office files I use POI.
The POI basicI haven 't used POI in a long time and I need to throw something
together pretty quickly to read specific data out of a somewhat
In the spreadsheet I 'm going to need to readI am having trouble storing a text value field with leading zeros when
using HSSF to write cells in an Excel 2002 sheet.
For example I am trying to store 00000004578 in the cell using
cell row.cHi All
I 'm glad to announce that the long-awaited support for excel comments in POI is implemented.
The request to implement it has been in po-dev since June 2002 (see Bug 10215) and finally this fea
hi to all... I am new of the forum...
I am trying to extract the autoshapes from a slide for then to paint them in
the code that I used ...
for (int a 0 a <VectorAutoShape.size() aHi
I have problem when try to apply date format in existing xls file. The program
works correctly when creating new file but when I read existing file and adding
data format is not applied.
hi.... I am writing an application java that taken in input a file .ppt it
allows to display it in a window similar to that used in PowerPoint. Until
now I have developed these points
- TextBox (IDear experts
I am using Formula Evaluator package to evaluate some Excel functions. When
I enter the correct formula syntax it works fine. But when I enter
incorrect formula syntax it does not throIn MS OLE documents there is a set of meta data tags like "AUTHOR " "TITLE "
When in the Win32 environment I can right click on an OLE file and look at
the summary tag and read these attriHi
I have several PPT presentations that cause an
ArrayIndexOutOfBoundsException to be thrown.
Before I open a bug in bugzilla I wanted to know whether this is
already a known issue and whetherHi
Is it a known problem that master sheets are not parsed well? I see for
example that bullets from master sheets are not identified whereas
bullets specifically requested from the user do.
Am I have the following test program that generates an XLS file with two
columns. If I try to import this XLS into Microsoft Access 2003 (File >
Get External Data > Import) only the first column shows
Je serai absent(e) du 22/12/2006 au 03/01/2007.
Je suis en vacances jusqu 'au mardi 2 janvier 2007 en cas de besoin merci
de contacter C?dric Minois.
I 'm off to 2nd january 2007 where necessary pGreetings
org.apache.poi.poifs.filesystem.POIFSFileSystem throws an error at
org.apache.poi.poifs.storage.HeaderBlockReader when it tries to read an
Excel file with xml in it. The header doesn 't hav
I using poi since last 2 years but still today i am unable to find the way
through wich i can read an XLS file that is of file type HTML/HTM.
Any one khnows ? Please help me.
when applying a format for a cell using the HSSF package of POI I come across
some behaviour which I cannot understand
consider the following to create a style for a number having 2 decimal
I am successfully opening a word document that is a Mail Merge document.
I can successfully locate all the merge fields and replace them with
data from a datasource
Now I would like to create a new
Simple question - how can I set optimum height for a excel file row ? In
HSSFRow class I didn 't find any method to do this.
row.setHeight((short)0) seems to do nothing
any news about bug #40143
<http //issues.apache.org/bugzilla/show_bug.cgi?id 40143 >? I 'm
experiencing the same problem described in some files. The font size
returned is wrong sometimes|