> I have used the BigGridDemo scenerio for creating more than 65K rows per
> sheet, but I wanted to write merged cells (I know what are the cells to be
> merged). I was not able to over come this problem can some one please
> suggest me what is the tag to be used and how to mention merged cells as
> Could you please help me in setting the print quality (to 600dpi) for page
> setup for an xls file using POI.
Have a look at org.apache.poi.ss.usermodel.PrintSetup.setHResolution and
setVResolution.
Regards,
Dave
>
> Thanks
> Rakesh
>
> --
> View this message in context:
> http://apache-p
> Let me correct my math errors.
How embarrassing. Getting old.
>> Let's see.
>>
>> 1 point = 20 twips
>> 72 points = 1 inch
>>
>> Font metric for the "0" zero character is 556/1000 x 10 points = 5.56 pts
>> per character.
>>
>
> 5.56 x 20 = 112 twips per default character.
111.2 twips per
Let me correct my math errors.
> Let's see.
>
> 1 point = 20 twips
> 72 points = 1 inch
>
> Font metric for the "0" zero character is 556/1000 x 10 points = 5.56 pts per
> character.
>
5.56 x 20 = 112 twips per default character.
> 1 character = 256 width units
>
> How many twips per width
Hi,
> I feel like I have got to be missing something obvious - all I want to do is
> set column width in twips, same as you can do with the rows, rather than in
> whatever the heck 1/256th of a character width is. It turns out that
>
> public void setColumnWidth( HSSFSheet sheet, int colIdx, dou
Given this -
http://www.computerworld.com/s/article/9214521/Hackers_exploit_Flash_zero_day_Adobe_confirms?source=CTWNLE_nlt_security_2011-03-15&utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+computerworld%2Fs%2Ffeed%2Ftopic%2F85+%28Computerworld+Malware+and+Vulnerabilities+News%29
I d
Hi Mirco,
POI 3.0.2 is very old. I would very much recommend that you update to either
POI 3.7 or 3.8 beta 1.
Also look into the recent thread "Reading superscript from data-cell" to
understand how to read the RichText and appreciate the difficulty of your task.
Also take a look at the list ar
Hi Mirco,
> in a for like this
>
>
>
>
> for (int i = startRow; i <= endRow; i++) {
>
> HSSFRow r = sheet.getRow(i);
>
> System.out.println(r. getHeightInPoints());
>
> }
>
>
>
> I’ve printed t
Hi,
Please describe the jars and structure of your app's WEB-INF/lib
I know Tomcat. If 5.5.X then what is in tomcat/common/lib and if Tomcat 6.0.X
what is in tomcat/lib?
When the ooxml-libs are used whether or not you have the correct XML parser or
not becomes important.
We've run POI in a we
> To clarify, I would like to manipulate text at the word level in an arbitrary
> docx file and preserve formatting/styling. The resulting docx file should
> still be editable, essentially preserved apart from the word manipulations.
> In terms of word manipulations, I have constructed several al
>> Please see the big warning in the quick guide:
>> http://poi.apache.org/spreadsheet/quick-guide.html#Autofit
>>
>> (Auto sizing columns requires font calculations to work out the text size,
>> and the requires that java initialise a graphics environment of sorts)
>>
>> Nick
>>
> Thanks N
> Hi David,
>
> thanks for responding!!
>
> I am using version 3.7.
>
> the JRE fonts are in:
>
>
> J6.0/lib/fonts
>
> -rw-r--r-- 1 SYSCHAR SYSTEMS 4041 Aug 30 2006 fonts.dir
> -rw-r--r-- 1 SYSCHAR SYSTEMS 242700 Aug 30 2006
> LucidaTypewriterRegular.tt
> f
> -rw-r--r-- 1 S
Hi Steve,
What version of Java and which version of Apache POI?
Where are the JRE fonts in relation to your JAVA_HOME?
Hopefully here: /jre/lib/fonts
Have you set "-Djava.awt.headless=true"?
Regards,
Dave
> I'm trying to use Apache POI to create a spreadsheet, which i will then email
> to
>
> Dear All,
>
> i am using the BigGridDemo example for export to excel and i continuously
> getting following error
>
> Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Illegal xml
> character. Line 36197, column 199.
>
> Yes i alread replaced following chars
> < to (
>> to )
> &
> I'm using POI to write Excel files from a java program. Everything works
> well.
> I was just wondering if it is possible to dynamically append data to a file
> wile
> the file is opened with Excel. I'd like to do that to let the user visualize
> the
> new data as the data is appended to the
> thanks for the quick reply, My application is web application, its deployed
> in unix box ,It creates excel on click of a link, I generate using poi and
> send it to response output stream for download.
> I was assuming the excel which I generate, I can give it to openoffice
> api which wi
> I am using poi to generate excel , now my clients want to have pdf also,
> please suggest me if there is any way to convert poi generated excel to
> PDF ?pelase advice me.
There are ways, but nothing is straight-forward. It depends on the environment
and time-line that your clients require
Hi Thomas,
> Is it possible to set the exportName without using
> workbook.write(fileOutputStream)?
>
> My Problem is that even if I set
>
> "resp.setHeader("Content-Disposition", "filename=" + "MyExample.xls");"
Are you in a servlet? You should be. Serving a binary file from jsp is not
recom
> I have several imports in my code from the org.apache.poi.ss.usermodel
> classes, but
> import org.apache.poi.ss.usermodel.WorkbookFactory; is not being recognized.
>
> My path is set to poi-3.8-beta1-20101028
>
> Anyone have an idea?
It is in the ooxml jar - See
https://issues.apache.org/bug
Jon,
Yes, please share it.
An ant task like this would fit in well with our apps testing framework.
I think it would make an ExcelAnt contribution to Apache POI. If you think so,
then you could open up a bugzilla and attach.
Sounds exciting.
Happy New Year,
Dave
On Dec 31, 2010, at 3:07 PM,
Hi Aniket,
>> Also I found another formula : =*COUNTIF(T2,"*"&"Geography"&"*") *which
>> should return 1 is returning 0.
>> T2 contains "*Target Geography in all*".
>>
> Again the above formula does not return any error but simply wrong value.
>>
>And also if I skip evaluation excel calcula
Hi Aniket,
Please take a look at http://poi.apache.org/howtobuild.html
The POI build requires Apache Ant. There is a build.xml with all the details
including downloading dependent jars.
JUnit is required if you want to run Unit tests which will make sure none of
your changes have broken someth
>
> Ramin
>
>
> On 15 December 2010 16:40, David Fisher wrote:
>> Hi Ramin,
>>
>> If you have some solutions to your trouble that you would like to contribute
>> to Apache POI, please see http://poi.apache.org/guidelines.html
>>
>> Keep in mind
Hi Ramin,
If you have some solutions to your trouble that you would like to contribute to
Apache POI, please see http://poi.apache.org/guidelines.html
Keep in mind that Apache POI and all contributions are made under the Apache
Software License - http://www.apache.org/licenses/
Regards,
Dave
Johan,
> Ok
> My code (which generated the files) is correct isn't it?
I think so.
> I'm using excel 2007 and OpenOffice 3.2
Do you have Excel 2010?
Whether this is an Apache POI or a Microsoft Excel bug I think you should
create a bugzilla report.
https://issues.apache.org/bugzilla/enter_bu
Johan,
> Don't know what you mean - it's a textbox and 2 images in each file.
> Have a look at the resulting files instead then...
>
> XLS is ok:
> http://apache-poi.1045710.n5.nabble.com/file/n3301618/workbook.xls
> workbook.xls
> XLSX is not ok:
> http://apache-poi.1045710.n5.nabble.com/file/n
Hi Marcel,
Please have a look at http://poi.apache.org/guidelines.html in the "Submitting
Patches" section.
Thanks and Regards,
Dave
On Dec 8, 2010, at 2:46 PM, Marcel May wrote:
>
>
> Oops, the patch got swallowed.
>
> On Dec 9, 2010, at 2:33 AM, Marcel May wrote:
>
>> I can confirm this
You cannot mix code from a GPL project back into an ASF project. A GPL project
may use an ASL v2 project.
Why is zkspreadsheet GPL?
Regards,
Dave
On Dec 2, 2010, at 4:41 PM, Henri Chen wrote:
> Take a look of this Ajax + Java solution.
>
> project page: http://code.google.com/p/zkspreadsheet/
Hi Jon -
> I am using POI 3.6.
A lot of bug fixes and improvements with formula evaluation between 3.6 and 3.7.
>
> I have a .xls file in which I am evaluating some cells that have formulas and
> macros in them. When I get to evaluate a cell with formulas in it, instead
> of
> getting a num
Hi -
If you are in unix then the typical way to set these environment variables for
Tomcat is in the setenv.sh script found in the /bin directory and called by the
catalina.sh script.
We use Apache Tomcat 6.0.29 and Java SE 1.6.0_18.
Here are some of the settings from out setenv.sh:
# You wan
> Regards
> Ramin
> http://joffice.eu
>
>
> 2010/12/1 David Fisher :
>> Hi Ramin,
>>
>> You point us to a site that only offers an exe to download. No information
>> about license, or anything else. What about us non-windows people?
>>
>> Rega
Hi Ramin,
You point us to a site that only offers an exe to download. No information
about license, or anything else. What about us non-windows people?
Regards,
Dave
On Dec 1, 2010, at 8:13 AM, Ramin Assisi wrote:
> Hi Gabriel,
> look at http://joffice.eu. You will find what are looking for.
>
That is essentially it.
Here is an example:
public class InlineServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse
response) throws IOException {
try {
response.setContentType("application/vnd.ms-excel");
// exp
Try setting your column widths after the indPerson loop.
If that fails then please tell us more about the program that takes Excel
files, it might be good to know what technology was used.
Regards,
Dave
On Nov 24, 2010, at 1:25 PM, Paal Larsen wrote:
>
> I have two programs (not made by me),
Hi -
On http://poi.apache.org click on the Bug Database link to go to ASF Bugzilla.
https://issues.apache.org/bugzilla/buglist.cgi?product=POI
Regards,
Dave
On Nov 19, 2010, at 8:11 AM, Gabriel Molina wrote:
> Hello!
>
> It seems that there is a bug when using user defined styles to style a
>
Aspose is a commercial / non-open source product. Support costs money. Well
over $1,000.
http://www.aspose.com/corporate/purchase/end-user-license-agreement.aspx
Apache POI is open source, we are volunteers, and we are here to help assuming
that you ask questions in a clear way and willingly wa
Permissions?
On Nov 8, 2010, at 12:07 PM, epezhman wrote:
>
> I fixed it like this : I changed this
>
> file = new File("C:\\Users\\ePezhman\\Desktop\\try\\beta.doc");
>
> to this
>
> file = new File("beta.doc");
>
> I moved the beta.doc from desktop to the project folder, and now it's
> wor
Dave,
You are quite welcome. Thanks.
Best Regards,
Dave
On Nov 5, 2010, at 2:23 AM, David Law wrote:
> Andrey,
>
> I don't think they have to make-believe they are clever.
>
> Working mostly in their spare time, they have put together
> an amazing piece of software which is used and appreciat
(1) The developers of Apache POI contribute on a volunteer basis - POI is not
their main job. You are not paying us to wake up in the middle of the night.
(2) This week most of the active ones are in Atlanta for Apachecon NA 2010.
Thay are NOT in your time zone.
(3) I count 9 emails from you o
Hi,
Images are in a different part of the file.
I suggest that you take the .docx file make a copy with your filesystem and
cahnge the suffix to .zip. You can then unzip the file and inspect the various
parts of the OOXML.
If you do this you will better understand where those images are.
Rega
.
> Sorry for the spam.
> Robin
>
> -Original Message-
> From: David Fisher [mailto:dfis...@jmlafferty.com]
> Sent: Wednesday, November 03, 2010 11:56 AM
> To: POI Users List
> Subject: Re: Detecting 1904 date windowing in a given file
>
> Hi Robin,
>
> T
Hi Robin,
This is a good question, but please you do not need to repeat your post. We've
seen your post. Several of the POI committers are at Apachecon. We have
discussed this a little. We may have an answer in the next day or two. Please
be patient.
Regards,
Dave
On Nov 3, 2010, at 7:29 AM,
Hi,
> hi i am converting a code which uses poi 2.0 for 'export to excel.xls'
> (entirely hssf based) to one which can 'Export to either .Xls or .xlsx
> format ' using poi 3.6. i have made some of the necessary changes by
> replacing the HSSf.usermodel methods with SS.usermodel methods but there ar
Sorry, but POI does not provide direct printing support. Printing is a very
large issue. For example, you could be printing to a bitmapped printer,
postscript or a pcl language printer.
Generically, you are looking for is a way to transform a Word Document into a
particular printing format.
Wo
Hi Manuel,
You can calculate in the same Workbook from different Worksheets.
You cannot calculate fresh values from another Workbook, but you can use the
cached result saved in your workbook.
Here is an example that grabs all the named cells with numeric data from a
workbook:
Workbook
http://poi.apache.org/changes.html
On Oct 6, 2010, at 3:45 PM, Zachary Mitchell wrote:
> Is there any ongoing development on the POI library
> in the area of HWPF, particularly in the area of Stream lining
> fonts/text/image insertion?
---
Hi David,
> But, right or wrong; I was really just trying to ask the question:
> "shouldn't poi be trying to get the same result as Excel too?"
Now we are getting deep because for IEEE 754 it all depends. For example, POI
runs on Java and not all hardware even on the same OS produces the same
Hi,
> I saw in the list archives that in 2002 someone was thinking about writing
> something for POI for spreadsheets to allow recalculation of formulas in a
> sheet/workbook. Did that ever get done? I am having trouble finding
> evidence one way or the other.
Yes, you can do that. See http://p
Apache POI is an open source project. None of the developers who contribute to
POI do so full time. There is no Oracle/Sun (OpenOffice) or Microsoft (Office)
contributing resources to the project at this time.
Rather than reading an old quote from a five year old forum entry that is not
from th
Zachary,
If you look at the source you will find the difference.
https://svn.apache.org/viewvc/poi/trunk/src/scratchpad/src/org/apache/poi/hwpf/usermodel/Picture.java?view=markup
Line 318 private void fillImageContent()
322 // HACK: Detect compressed images. In reality there s
Hi Ryan,
Back in May we had some discussions about performance in the POI-Dev list.
Bryce Alcock analyzed the situation and had a conversation with the XMLBeans
about the issue. It has to do with some inefficient code within the XMLBeans.
http://www.mail-archive.com/d...@xmlbeans.apache.org/msg
We have no problems preserving a Macro contained within an XLS. We have no
problems with signed macros.
Please post some code so that we can have an idea what you are doing. For
example, you need to modify your macro containing file and not copy it within
POI.
Regards,
Dave
On Sep 28, 2010, a
Hi Pablo,
I have not confirmed it, but I think that xlsm support is added with POI
3.7beta3. Apache POI 3.7beta3 is being released right now.
Please give it a try with this situation. If it fails with that then please
submit a bugzilla and attach an example.
Regards,
Dave
On Sep 24, 2010, at
You might give trunk a try, or wait until tomorrow when it is likely that POI
3.7beta3 will be released. (Voting is in process, no one has objected and
enough positive votes so far. The link is on the thread -
http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/19169)
If that fails to solve
>> BUT: powerpoint still shows the old data when I open the ppt. I have to
>> refresh manually within powerpoint to get the new figures displayed. Is
>> there any possibility to trigger the update automatically / programatically?
>
> As I understand it, an embedded document is made up of two pa
JRUBY had a similar issue - perhaps this thread will help you sort things out.
http://jira.codehaus.org/browse/JRUBY-3576
Or this report. http://openradar.appspot.com/8307054
But it is "not a bug it is feature."
http://bugs.sun.com/view_bug.do?bug_id=4163515
I think you will need to explicitly
Hi Jim,
Cell names should work fine, but you may want to use Apache POI 3.7b2 as there
have been bug fixes.
http://poi.apache.org/spreadsheet/quick-guide.html#NamedRanges
Named cells are really convenient. Here is a code fragment that fills a HashMap
with numeric values from all the named cell
led without
> any errors, but when I try to activate the applet using IE6, I still get
> java.lang.NoClassDefFoundError: org/apache/poi/xssf/usermodel/XSSFWorkbook
>
> Thomas
>
>
>
> From:
> David Fisher
> To:
> "POI Users List"
> Date:
>
Hi Thomas,
> 1) I just downloaded poi-bin-3.6-20091214.zip to my Windows XP PC.
>
> 2) I unzipped the file into C:\Program Files\Java\ so there is now a
> poi-3.6 folder
>
> 3) I added the following two entries to my CLASSPATH:
You always need this first.
C:\Program Files\Java\poi-3.6\
Hi Matt,
> Possible this is the older version of the BIFF8 format?
I think that is likely.
> Metadata in the spreadsheet indicates it was created by Crystal Decisions.
> It contains an Author: tag "Crystal Decisions" and a Comments: tag "Powered
> by Crystal". Also contains 7 custom propert
Hi Roger,
> I'm also coming at this from a "Groovy" (language) perspective.. so possibly
> a DSL layer to make simple/crud stuff very easy.
I very much encourage you to start by asking for comments and advice on the POI
Dev list.
A discussion about the goals of the API would be helpful. Here a
The initial intent of the project was to create a very low level API for
writing XLS.
Rather than creating very high level interfaces most contributors have been
focused on extending coverage to more Office document formats.
If you take a look the documentation that Microsoft now provides it i
e to Create Workbook" +
> e.getMessage());
> }
>
> but still enters WorkbookFactory and kills the program.
>
> I have poi-ooxml-3.6-20091214.jar, poi-3.6-20091214.jar as part of the
> project.
>
> I am working out of NetBeans 6.9.
>
> Any othe
You will want to use try / catch and print the exception.
http://www.exampledepot.com/egs/Java%20Language/TryCatch.html
I suspect that you are missing the ooxml jar and other dependencies.
http://poi.apache.org/overview.html#components
Regards,
Dave
On Jul 8, 2010, at 11:55 AM, Dan C wrote:
>
You are likely running into memory constraints. You will need to look into your
Glassfish and watch for garbage collection and also look into the memory
allocation for classes. I suggest using jconsole or jvisualvm if your Glassfish
admin has enabled JMX.
OOXML is a heavy lift both in the numbe
It is also a pun on the Polynesian food - Poi -
http://en.wikipedia.org/wiki/Poi_(food) - which requires a lot of pounding to
prepare.
What I just learned from http://en.wikipedia.org/wiki/Poi is that Poi is a
Tibetan word for Tibet.
Regards,
Dave
On Jun 30, 2010, at 5:18 PM, Stoicescu, Adria
Hi Parag,
> java.lang.NoClassDefFoundError:
This is almost always s problem with your java classpath,
Regards,
Dave
On Jun 23, 2010, at 9:19 PM, Parag Kalra wrote:
> Hi All,
>
> I downloaded ApachePOI and Placed my dummy excel sheet into the folder after
> extraction. Then I got a code to pa
Zachary,
POI 3.7beta1 is mostly a very large number of bug fixes along with enhancements
to the API for Outlook - HSMF.
Here is the change log: http://poi.apache.org/changes.html
Regards,
Dave
On Jun 23, 2010, at 7:01 PM, Zachary Mitchell wrote:
> Are there any particular changes to the mani
I think you will get a quicker response on the POI Developer list. Look for the
thread "Performance Question with CTSheetDataImpl.java"
About all I can say now as I am under a deadline.
Dave
On Jun 17, 2010, at 5:26 PM, Zoran Avtarovski wrote:
> Sorry about the delayed response but I’ve been a
I think that there has been some improvement here since 3.6. It makes sense to
try the nightly build or the prospective 3.7Beta1
Regards,
Dave
On Jun 17, 2010, at 12:16 PM, MSB wrote:
>
> I think that this could be a bit of a problem and the give away is that error
> message - 'not implemented
ust need to
> find a way around (or update the process).
>
> Thanks guys.
>
> On Tue, Jun 15, 2010 at 10:26 AM, David Fisher wrote:
>
>> You are welcome. I was working on a reply last Friday when work took me
>> elsewhere.
>>
>> You got to the correct place. Here
xtract .xls files?).
>>
>> My local environment has less .jars than on the server, it's windows xp,
>> and I'm testing the app using an ant build. (or by running a simple java
>> .class)
>>
>> Hope this helps. I really appreciate all the help I've
> Hi
>
> I wanted to assign Cell formatting for a particular field which is supposed
> to handle numeric values.
>
> For example :
>
> In the column D , I have a filed called Total. This entire column i wanted
> format as "Number" with 2 decimal places.
>
> Can some body help me on this with
> Hello Parag,
>
> 1, Yes you can. It will be best to write code that targets the classes in
> the SS usermodel package as this will allow you to seamlessly process both
> file types. There are a few examples of how to do this - and if you are at
> all unclear of course, just post a question to th
User list -
http://tomcat.apache.org/lists.html#tomcat-users
Regards,
Dave
On Jun 11, 2010, at 10:00 AM, Jorge Moya wrote:
> I've tried removing the extra .jars and it still won't work. I just don't
> get it.
>
> On Thu, Jun 10, 2010 at 1:43 PM, David Fishe
On Jun 10, 2010, at 2:03 PM, Will Coleda wrote:
> On Thu, Jun 10, 2010 at 4:12 PM, Will Coleda wrote:
>> I'm running into a performance issue using the ss usermodel to modify
>> an existing XLSX file - I'm poking at potentially using XSLT to do the
>> conversion I need - I have code that can gra
OI
> and tomcat (intern), and I'm trying to update the webapp.
>
> Thanks in advance.
>
> On Thu, Jun 10, 2010 at 1:01 PM, David Fisher wrote:
>
>> Hi,
>>
>> Here a few things that I would check.
>>
>>
>> POI jars:C:\Tomcat\webapps\websr
Dave
> On Thu, Jun 10, 2010 at 11:25 AM, David Fisher wrote:
>
>>> Yes, this file was created using Excel 2007. The file was originally an
>>> .xls, and I migrated it to .xlsx (however, I have tried uploading both
>> new
>>> and modified .xls files an
Exception reading the excel document");
>
>} catch (InvalidFormatException e) {
> // Catch created for Workbook.create method. Unspecified.
>
> e.printStackTrace();
> }
>}
>
> Any thoughts?
>
> On Thu, Jun 10, 2010 at 10:09 AM, Dav
.
>>>
>>> On Wed, Jun 9, 2010 at 10:43 AM, Jorge Moya wrote:
>>>
>>>> What do you mean, exactly? I'm uploading the files through an FTP
>> server,
>>>> and after upload I execute the validation of my app which proceed to
>
I can provide the following information, although not much help beyond that.
Your trouble is in org/apache/poi/ddf/EscherContainerRecord.java
public int fillFields(byte[] data, int pOffset, EscherRecordFactory
recordFactory) {
int bytesRemaining = readHeader(data, pOffset);
i
Yes, that is the correct track. There have been improvements in the last 10
days.
(1) Get hold of the latest night build.
(2) Find the email thread titled: "Performance Question with
CTSheetDataImpl.java" in the archives.
The short version is that Bryce Alcock analyzed where bad performance oc
Hi,
You should write the uploaded file to your temporary file and then read it in.
OOXML files are zip files and are not accessed non-serailly. The user might
stop transfer or the network connection might break.
Regards,
Dave
On Jun 8, 2010, at 9:37 AM, Jorge Moya wrote:
> Ok guys, I'm tryin
Tulio,
On Jun 4, 2010, at 4:07 PM, Nick Burch wrote:
> On Fri, 4 Jun 2010, Túlio Severiano wrote:
>> I am using this example. But it does not display the background or text
>> formatting. Any help?
>>
>> http://poi.apache.org/slideshow/how-to-shapes.html#Render
>
> I suspect that these are bit
Hi Walid,
> Excel POI had been working great for us, the printing with an excel
> template etc...until we implemented a reverse proxy pattern to prohibit
> users from directly accessing our app, and sending back to a global
> logon page first.
This is likely to have to do with how your proxy is c
Autosizing requires font information. Check to assure that the fonts installed
on centOS / Java match those on your WIndows box. You'll likely find the CentOS
box is missing fonts.
Regards,
Dave
On May 28, 2010, at 11:52 PM, calintz wrote:
>
> Hi all,
>
> I'm currently using poi-3.6 to gener
This issue was just discussed on the dev list and Yegor submitted a patch that
gives a tremendous improvement when a spreadsheet's cells are written in order.
http://mail-archives.apache.org/mod_mbox/poi-dev/201005.mbox/%3c4bfa158a.2020...@dinom.ru%3e
Here is Bryce's performance test from this m
The poi-ooxml-schemas jar is a cut-down version of ooxml-schemas-1.0.jar - the
full schemas are about 13 MB.
So, you will need to do one or more of three actions.
(1) Replace poi-ooxml-schemas in your classpath with ooxml-schemas-1.0.jar.
You can get this from the maven repository:
groupId:
ilherme Petterle Silveira Mussi
>>
>> Conrad Caine Media Applications GmbH
>>
>> Mobile: +55 53 91257012
>> Office: +55 53 30275721
>>
>> "Any fool can know. The point is to understand." - Albert Einstein
>>
>>
>> On Thu, May 20
Hi Mark,
I am curious what happens if you write strict XHTML to a cell in XSSF?
Regards,
Dave
On May 20, 2010, at 8:50 AM, MSB wrote:
>
> So, let me get this clear, you are NOT asking how to use POI but a more
> general question about Excel - how to place HTML into a cell?
>
> If this is the
Please do not hijack threads.
Please start by asking a single question in a new thread.
For example you ask about fonts, please tell us what you see and where those
fonts are installed on your system.
Thanks,
Regards,
Dave
On May 19, 2010, at 12:46 AM, Zachary Mitchell wrote:
> If I am to go
I'm joining Mark in his comments.
> No apology is necessary but I do need to warn you that HWPF is still an
> immature API that is very much in need of support from developers - that is
> a less than subtle hint by the way.
Anyone with the HWPF "itch", please, please, please step up and show us y
>>
>> Try swtiching to org.apache.poi.hssf.util.CellRangeAddress
>>
>> Regards,
>> Dave
>>
>> On May 7, 2010, at 4:43 PM, Erwin Kalvelagen wrote:
>>
>>> I was using org.apache.poi.hssf.util.RangeAddress extensively with an older
>>> version of POI. This seems not there anymore in the current v
Try swtiching to org.apache.poi.hssf.util.CellRangeAddress
Regards,
Dave
On May 7, 2010, at 4:43 PM, Erwin Kalvelagen wrote:
> I was using org.apache.poi.hssf.util.RangeAddress extensively with an older
> version of POI. This seems not there anymore in the current version (3.6).
> Did
> this
There can be many reasons.
More information about what is different along with the code used to produce
it. Of course the smallest example possible is most helpful.
Regards,
Dave
On May 6, 2010, at 11:44 AM, Hepzibah Rajulah wrote:
> Reports which worked with 3.2-FINAL does not render the sam
Hi -
I have noticed that some people are repeating questions and/or hijacking
threads to try to get an answer. This makes it difficult for others to get
answers.
The Apache Software Foundation has a long list of tips for email contributors.
I think that some users may need to take a look.
htt
;ll need to give it a try.
Regards,
Dave
Begin forwarded message:
> From: Josh Micich
> Date: May 3, 2010 4:30:59 PM PDT
> To: David Fisher
> Cc: Jacob Feldman , w...@apache.org
> Subject: Re: how POI reads encrypted workbooks
>
> Hello Jacob,
>
> I remembe
This won't get your questions answered more quickly.
On Apr 26, 2010, at 6:44 PM, Zachary Mitchell, BCIS wrote:
>
> - Original Message - From: "Zachary Mitchell, BCIS"
>
> To: "POI Users List"
> Sent: Tuesday, April 27, 2010 9:03 AM
> Subject: Fw: Three Quest about POI Excel sheet edi
Hi,
> David does mention how to obtain the complete archive somewhere and once I
> find it, I will post the link.
All the details of loading build requirements including the "heavy" and full
ooxml-schemas is in the build.xml available with the source download.
Here is the direct link to the jar
Hi Ramon,
For OOXML you will need more jar files. See the maven artifacts listed towards
the bottom of http://poi.apache.org/overview.html
Regards,
Dave
On Apr 21, 2010, at 4:40 PM, Ramon F Herrera wrote:
>
> This is the error message:
>
>
1 - 100 of 237 matches
Mail list logo
