Re: I'm sure this has been asked 1000x times

2010-07-20 Thread MSB
workbooks. > > amazing > > Roger > > > > > On Jul 20, 2010, at 2:36 AM, MSB wrote: > >> >> You will not be able to copy rows from one workbook to another but you >> can >> copy cells. >> >> Setting aside the issue of styles for a mo

Re: Re: my question for write word use XWPF

2010-07-20 Thread MSB
;e:\\simple.docx"); >sampleDoc.write(out); >out.close(); > } catch (Exception e) { >e.printStackTrace(); > } > > > > > 史虎杰,shihu...@gbicc.net > 2010-07-20 > - Original Message - > From: MSB > To: user > Sent: 2010-07-19

Re: I'm sure this has been asked 1000x times

2010-07-19 Thread MSB
You will not be able to copy rows from one workbook to another but you can copy cells. Setting aside the issue of styles for a moment - although even that is fairly straightforward as there is a method available to clone a style from another workbook and the only major hurdle that leaves is preve

Re: my question for write word use XWPF

2010-07-19 Thread MSB
You forgot to mention which version of the api you are currently using. Recently, changes were made to the way footers and headers are inserted into documents to allow them to consist of more than one paragraph of text. It should be possible to create headers and/or footers for an OOXML Word docum

Re: SHow HTML text in one of the excel cell

2010-07-15 Thread MSB
Sorry to say this, but I am certain now that you will need to write code to parse the html, strip out the tags and create a cell style to apply to the cell that contains the mark-up. To convince myself of this, the final test I unbertook was to manually edit the zipped xml of an OOXML based Excel

Re: exception when inputstream is read from getClass().getClassLoader().getResourceAsStream("file.xls")

2010-07-15 Thread MSB
is case I don't get any > exception. > > The wonderign part is that it works with a tomcat & fails in one jboss > server. > Can I know When is this particular error supposed to be thrown... > > > > MSB wrote: >> >> Have you tried to open the fil

Re: exception when inputstream is read from getClass().getClassLoader().getResourceAsStream("file.xls")

2010-07-14 Thread MSB
e(uri); > inputStream = new FileInputStream(file); In this case I don't get any > exception. > > The wonderign part is that it works with a tomcat & fails in one jboss > server. > Can I know When is this particular error supposed to be thrown... > > > > MSB w

Re: exception when inputstream is read from getClass().getClassLoader().getResourceAsStream("file.xls")

2010-07-14 Thread MSB
Hello, Not to my knowledge no because the original poster of the question never submitted a further reply. Have you tried to open the file directly - creating a simplt FileInputStream attached directly to the file for example - to see whether POI responds in the same way or if it opens the file?

RE: Getting Data type

2010-07-14 Thread MSB
on and solution. > > I think the second solution of creating a dummy row is more suitable for > my application. > > Thanks and regards, > -Kalpesh > > -Original Message- > From: MSB [mailto:markbrd...@tiscali.co.uk] > Sent: Tuesday, July 13, 2010 9:26 AM >

Re: SHow HTML text in one of the excel cell

2010-07-13 Thread MSB
If you already have the html parsed and held in a cell of an Excel workbook then yes, you should be able to copy it successfully. Remember though that you will need to copy both the text AND the style. It is the automatic creation of the style by the paste operation - along with stripping off the

Re: Imp: Read this

2010-07-13 Thread MSB
Am I missing something? What has this to do with POI? Yours Mark B Bhushan Jain-3 wrote: > > Something Interesting > http://www.ibm.com/developerworks/aix/library/au-sles_encrypt/index.html > > -- View this message in context: http://old.nabble.com/Imp%3A-Read-this-tp29154048p2915867

RE: Getting Data type

2010-07-13 Thread MSB
eturns String, First Name returns String > and DOB also returns String. Actually I am expecting DOB to be Date. I > am not talking about the data type of the actual data from the second > row onwards. > > Thanks and regards, > -Kalpesh > > > -Original Message-

Re: SHow HTML text in one of the excel cell

2010-07-13 Thread MSB
Just a quick update, I have not yet had the opportunity to play with any POI code and will be unlikely to do so today as I am attending a concert tonight, straight after work. However, following a bit of experimentation, thanks to the heavy rain preventing us from digging the pond here, I found th

Re: SHow HTML text in one of the excel cell

2010-07-12 Thread MSB
Can I just check to make sure that I am clear about what you want to do, you wish to enter some HTML and have Excel parse that within a cell to present, in this case, the phrase 'My String' rendered in bold text? Well, I know that Excel does support this - if I cut you example test out of the mess

Re: Getting Data type

2010-07-12 Thread MSB
First some bad news; it is only possible to enter one of three different types of value into a cell, a number, a String or a forumla which is itslef a type of String I guess. Then you apply a format to that value to transform the cells content into a Date value a currency value, etc. Therefore, it

Re: APACHE POI WITH JAVA

2010-07-04 Thread MSB
There are other options but it does depend on what you wish to do. Take a look at the FormulaEvalutor interface - http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/FormulaEvaluator.html and the folowing page on the website - http://poi.apache.org/spreadsheet/eval.html - they will show you

Re: Inserted images don't move with cells

2010-07-02 Thread MSB
hanks for letting us know. Yours Mark B PS You are quite correct to say that images are not inserted into cells. They actually 'float' over the surface of the worksheet and the anchor determines where they appear. Guha, Rajarshi (NIH/NHGRI) [C] wrote: > > > > > On 7/2/

Re: Inserted images don't move with cells

2010-07-01 Thread MSB
This is going to get quite technical and I apologise for that but there is no other option really. Also, I am making an assumption here - that you are inserting images into cells and those images occupy all of the cell. If not, ignore the following as it is based on some experimentation we did whi

Re: Listen for a cell value change

2010-07-01 Thread MSB
/examples.php and it looks like that is what you are after. Yours Mark B Frizz wrote: > > well, yes. I want to use excel like a bridge. Excel must be update via DDE > and I want to wake up some java method at every update. Do you know some > api that can do it? > > > >

Re: Listen for a cell value change

2010-07-01 Thread MSB
a DDE > and I want to wake up some java method at every update. Do you know some > api that can do it? > > > > MSB wrote: >> >> Can I just be clear about what you are asking please? Are you saying that >> someone will have a workbook open in Excel and you w

Re: Listen for a cell value change

2010-07-01 Thread MSB
nt to call? Yours Mark B Frizz wrote: > > well, yes. I want to use excel like a bridge. Excel must be update via DDE > and I want to wake up some java method at every update. Do you know some > api that can do it? > > > > MSB wrote: >> >> Can I just be cl

Re: how to pronounce POI?

2010-07-01 Thread MSB
... and I thought they were initials - P.O.I - rather than a word, oh well, you live and learn I guess. DaveCoventry wrote: > > I always thought it rhymed with 'phooey'. > :~) > > -- View this message in context: http://old.nabble.com/how-to-pronounce-POI--tp29039838p29047152.html Sent fr

Re: Listen for a cell value change

2010-07-01 Thread MSB
Can I just be clear about what you are asking please? Are you saying that someone will have a workbook open in Excel and you want to detect if they make a change to a cell and then perform some action? If this is the case then no, you cannot do this with POI. The API can be used only to create/edi

Re: how to get value and position of check box and radio button

2010-06-28 Thread MSB
Please do not accept this as a definitive answer - wait for others to replay also - but I am pretty confident in saying that POI does not alow you to interact with controls on worksheets. The project is always welcoming of contributions so, if you fancy seeing whether or not you could add this fe

Re: Adding paragraphs to XWPFTableCell

2010-06-26 Thread MSB
active -- thanks for the gentle nudge. > > Patch submitted. > > On Wed, Jun 23, 2010 at 11:53 PM, MSB wrote: > >> >> Thanks for that. This is most liekely the sort of question that will >> arise >> again in the future. By the way (and this a very unsubtle hint

Re: Any new Word/Excel file options in 3.7?

2010-06-24 Thread MSB
You can already insert pictures into a worksheet be it in binary or OOXML format and there are examples on the POI website - http://poi.apache.org/spreadsheet/quick-guide.html#Images - and you can always take a look http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examp

Re: Read Custom format cell value

2010-06-23 Thread MSB
mber. > //Assume the content is of type number and try to get the value,if > not number then it has to be string type. > if (cell.getCellStyle().getDataFormatString().equals("@")) { > try { > retVal = isNumberOrDate(cell); > } catch (I

Re: Adding paragraphs to XWPFTableCell

2010-06-23 Thread MSB
t; >> XWPFParagraph newPara = new XWPFParagraph(cell.getCTTc().addNewP(), >> cell); >> >> newPara.createRun().setText("Some text"); >> >> >> It sure will be nice to have a createParagraph() method on a >> XWPFT

Re: Adding paragraphs to XWPFTableCell

2010-06-23 Thread MSB
Try this XWPFParagraph para = new XWPFParagraph( org.openxmlformats.schemas.wordprocessingml.x2006.main.CTP.Factory.newInstance()); That compiles and seems to run perfectly well. Of course, you will then need to add runs to the paragraph in order to add any text to it but this shoulod get yo

Re: Adding paragraphs to XWPFTableCell

2010-06-23 Thread MSB
Late last night,m it ocurred to me that I think I know how to do this - in fact I think that I already have using the Factory method of the CTP class to create an instance that is then used to initialise an XWPFParagraph object - but I need to test some code out before posting again. Will post ag

Re: Referencing multiple sheets in Apache POI Formulas

2010-06-22 Thread MSB
This code produces a workbook that can be successfully opened by both Excel and OpenOffice Calc; public static void main(String[] args) { File file = null; FileOutputStream fos = null; Workbook workbook = null; Sheet sheet1 = null; Sheet sheet2 = null;

Re: Referencing multiple sheets in Apache POI Formulas

2010-06-22 Thread MSB
Have just checked with Excel and it does allow such formulae but with one very interesting exception - when I wrote '+ c!$A$1' Excel insisted on inserting inverted commas so that it became 'c'!$A$1 jus as if the sheet name had an embedded space. Will try with POI this evening - assuming I do not g

Re: Referencing multiple sheets in Apache POI Formulas

2010-06-21 Thread MSB
Hello Marc, I have just had a look at the bug you linked to and wanted to say that is a slightly different issue. There, the problem occurs trying to reference a cell on a sheet within a different workbook, not on a sheet within the same workbook. Have you tried using either Excel of OpenOffice

Re: Read Custom format cell value

2010-06-21 Thread MSB
No joy at all I am afraid; on numerours fromts. Firstly, I did as David suggested and downloaded a more recent version of the api - one of the 3.7 beta2 nightly builds - and can report that this did not solve any of the problems. The basic FormulaEvaluator still did not work with formulae that sp

Re: Read Custom format cell value

2010-06-20 Thread MSB
In one way, I remembered correctly. There is a class called ForkedEvaluator that does allow you to work with formulae that reference cells in external workbooks and so I began to put together some test code. Unfortuantely, I found that it will only work - at least the version that I have from a re

Re: Online examples showing usage of Apache POI

2010-06-19 Thread MSB
If you are not yet comfortable with the Java language, I would set POI aisde until you are. Understand how to create objects, call their methods and handle the values they return, get to know the difference between class and instance variables/methods, how to reference archives on the classpath, h

Re: Merging Documents HWPF

2010-06-18 Thread MSB
This is going to be a bit of bad news on the one hand and an appeal for help on the other I am afraid. The problem you will face is that HWPF does not currently allow you to apply more than one treatment to a piece of text. By this, I mean that you could set the font OR you could set the colour O

Re: Can we read from .xls format and write to .xlsx format simultaneously

2010-06-18 Thread MSB
Just been over at the OpenOffice forum catching up on a few things and I discovered that version 3.2 of OpenOffice running on Ubuntu will save a spreadsheet as an xlsx format file. As JODConverter uses the OpenOffice libraries, I am betting - meaning that I do not know because I have not played wi

Re: Read Custom format cell value

2010-06-17 Thread MSB
pefully, I will have some time today to play about with a bit of code. Yours Mark B David Fisher wrote: > > 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 >

RE: Read Custom format cell value

2010-06-17 Thread MSB
if (HSSFDateUtil.isCellDateFormatted(cell)) { > retVal = dateFormat.format(cell.getDateCellValue()); > } else { > retVal = formatter.formatCellValue(cell); > } > } > } > re

Re: Cell date?

2010-06-17 Thread MSB
Glad to help, all the best for your future 'endeavours' with POI and keep in touch; if there is anything you need to know just drop a message onto the list. Yours Mark B PS It is quite fun is it not? ljnelson wrote: > > On Thu, Jun 17, 2010 at 2:41 AM, MSB wrote: > >

Re: Cell Formatting

2010-06-16 Thread MSB
Morning Luke, How are you getting on with the rest of the code for this project? With regard to formatting the cells appearance, it is really a two stage process. The first thing you need to do is to create a CellStyle object, set the data format of this object and then apply the style to the ce

Re: Cell date?

2010-06-16 Thread MSB
No need to apologise for asking a question. Once, I was told that the only stupid question is the one you do not ask and always try to abide by that. Anyway, at the risk of boring the pants off of you, there is really no such thing as a date cell in Excel. What you see as a date is actually a spe

RE: Read Custom format cell value

2010-06-16 Thread MSB
her trouble, or if I have misconstrued what you do need to achieve, just drop a message onto this list. Yours Mark B Siva_Masilamani wrote: > > Yes you are right. > > > > MSB wrote: >> >> Can I just confirm that you are referring to the values in column E >> p

RE: Read Custom format cell value

2010-06-16 Thread MSB
>> >> You should try taking a look at what the XML looks like for this cell >> content. Check the attributes 't' and 's' for that cell and also what the >> content for the cell looks like. If the cell is indeed numeric then the >> value of '

Re: I have problem using XSSF

2010-06-16 Thread MSB
he data from csv > file in the corresponding date's cell; if the data already exist in the > xlsx file then i have to sum the corresponding values of xlsx and csv and > put it in the xlsx's dated cell. > > thanks. i'll appreciate any other solution/help. > &g

Re: Can we read from .xls format and write to .xlsx format simultaneously

2010-06-16 Thread MSB
Are you asking whether POI can be used to convert the older binary (.xls) files into the OOXML based (.xlsx) files? If this is the case then the answer is a qualified no. There is no single method or group of methods that you can call to perform the conversion. What you would need to do is use PO

Re: I have problem using XFFS

2010-06-15 Thread MSB
Are you using the usermodel or the eventusermodel classes? I suspect the former if you are having such problems and would suggest that you take a look at Yegor's BigGridDemo.java demonstration code. You should not consider this to be a solution but rather a demonstration of a different approach to

Re: Read Custom format cell value

2010-06-15 Thread MSB
I think people are a little confused about this post because you have referred to DataFormat.addFormat() when I think that you really mean DataFormatter.addFormat(). The DataFormatter class is the one that you would usually use to convert the contents of a cell into a formatted String - which it l

Re: First time Queries on Apache - POI

2010-06-12 Thread MSB
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 this list - b

Re: How to convert .xls to .xlsx

2010-06-11 Thread MSB
You have a few options but quite a few limitations really. 1. POI does not have any method that you can call to convert from one file format to another. You could however, use the api to open a workbook, extract it's contents and use that information to create a new workbook in the appropriate f

Re: A newbie question: how to get image position?

2010-06-10 Thread MSB
in the cell at > column number 0 and row number 51 at the offset position x 721 and y 221 > co-ordinates. > org.apache.poi.ddf.EscherClientDataRecord > org.apache.poi.ddf.EscherTextboxRecord > > > It lists 52 images for first 52 rows, and then truncated from there. There

Re: openxml4j InvalidFormatException

2010-06-10 Thread MSB
erified and the file is functional. I'm really clueless, atm. > > On Thu, Jun 10, 2010 at 1:53 AM, MSB wrote: > >> >> Is it possible that the structure of the file is being mangled somehow? >> Have >> you tried to open the file using Excel after it has been ftp

Re: openxml4j InvalidFormatException

2010-06-09 Thread MSB
Is it possible that the structure of the file is being mangled somehow? Have you tried to open the file using Excel after it has been ftp'd into the folder on your server? Yours Mark B Jorge Moya wrote: > > I'm sorry for spam, but I menat it breaks when it tries to extract the > info > from t

Re: A newbie question: how to get image position?

2010-06-09 Thread MSB
row number 51 at the offset position x 721 and y 221 > co-ordinates. > org.apache.poi.ddf.EscherClientDataRecord > org.apache.poi.ddf.EscherTextboxRecord > > > It lists 52 images for first 52 rows, and then truncated from there. There > are about 10 images just left outIs that possible r

Re: A newbie question: how to get image position?

2010-06-09 Thread MSB
le checked spreadsheet and confirm there are 65 Pictures > in that sheet. I guess something missed over there. I might be confused by > those Children, etcAny suggestion is appreciated. Thanks again for the > help. > > --Jerry > > > > >>>> MSB 6/8/20

Re: Testing for Merged cells

2010-06-09 Thread MSB
nd if so, > how to determine the number of cells involved? > > > > MSB wrote: >> >> Are you looking at the correct class? The one I referred to is the >> org.apache.poi.ss.util.CellRangeAddress class. It extends the >> CellRangeAddressBase class an

Re: Testing for Merged cells

2010-06-08 Thread MSB
e and have a question on the "isInRange" method. > Where is it defined and how can it compare the values in the array? > > > MSB wrote: >> >> I do not have the code to hand but the technique that I have used in the >> past goes like this. >> >

Re: A newbie question: how to get image position?

2010-06-08 Thread MSB
I should have known that would be too easy! This morning, I managed to write the code to recover the anchor information for images inserted into one of the older, binary, Excel workbooks; /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package

Re: setprintarea not working

2010-06-08 Thread MSB
i-3.2. > > I'm looking at the source code and it looks like the source code for > setPrintArea on poi 3.2 and poi 3.5/3.6 is quite different. > > Thanks... > > > On Mon, Jun 7, 2010 at 10:38 PM, MSB wrote: >> >> Hello, >> >> Can you post s

RE: Is there any code to convert doc2PDF using POI

2010-06-08 Thread MSB
If you are using JODConverter, the best source of code and support is the art of solving website itself in my opinion. The people there know far more about the tool than me. If you are thinking about using UNO to convert 3000 documents then I would forget that idea for one very simple reason. Try

Re: A newbie question: how to get image position?

2010-06-08 Thread MSB
This is not such a simple process if I remember correctly. As it is such a long time since I did anything like it, I cannot promise my memory is accurate but I think it wen like this; Get the drawing patriarch from the sheet - you do not say which stream you are following XSSF or HSSF so I will a

Re: Testing for Merged cells

2010-06-08 Thread MSB
I do not have the code to hand but the technique that I have used in the past goes like this. Open the worksheet. Call the getNumMergedRegions() methods to recover an integer that indicates how manymerged regions there are on the sheet. Use this value to create and dimension an array of type Cell

Re: setprintarea not working

2010-06-07 Thread MSB
Hello, Can you post some code please so that we can see what you are trying to do. You do not need to post everything, just the part where you are trying to set the print area. While you are doing that, I will have a look through the test code and play with some of my own to see if I can put toge

Re: Text Import Wizard

2010-06-02 Thread MSB
.or you could try OpenOffice. It has an api - called UNO - that allows you to write Java code to control the application; a little like a non-platform specific version of OLE/COM. Whilst it can be used to generate Excel workbooks in the older binary file format - I do not think that ability to

Re: Text Import Wizard

2010-06-02 Thread MSB
Sorry, no. POI can be used to read, edit and write files that Excel can read, it cannot be used to manipulate the application itself. If you want to do this sort of thing, you will be limited to using OLE/COM through a third party library such as JACOB or the Standard Widget Toolkit. OLE and COM

Re: XSSF samples

2010-06-01 Thread MSB
There are a number of examples submitted both by the developers and users of the api. To find them, you will need either to download the source for the api or follow this llink to look into SVN; http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/. As

RE: Is there any code to convert doc2PDF using POI

2010-05-27 Thread MSB
Thanks Leigh. I have only ever 'played' with JODConverter because I found it after I wrote the UNO code to make OpenOffice do the same things!!! Good to get the correct information for the future. Yours Mark B cfSearching wrote: > >> This is the homepage for JODConverter - >> http://www.artof

RE: Is there any code to convert doc2PDF using POI

2010-05-27 Thread MSB
This is the homepage for JODConverter - http://www.artofsolving.com/opensource/jodconverter There is lots of information there and a few code examples as well if you have a good dig around. With regards to the OpenOffice jar(s) I do not think you need to have them if you are using JOD. I cannot b

Re: Create VBA (macro) to an Excel with POI!

2010-05-27 Thread MSB
No, POI is not able to create or edit VBA macros currently. Typically, users create macros in a template workbook using Excel then open and populate that workbook using POI. POI has been designed to pass through unchanged anything it finds in an input file that it does not 'understand' and, as a r

Re: ALIGN_CENTER_SELECTION question

2010-05-27 Thread MSB
row.getCell( start_column); > cell.setCellValue( new XSSFRichTextString("Align It")); > > //make the selection > CTRowImpl ctRow = (CTRowImpl) row.getCTRow(); > List spanList = new ArrayList(); > //add object with format start_coll

Re: ALIGN_CENTER_SELECTION question

2010-05-26 Thread MSB
the selection > CTRowImpl ctRow = (CTRowImpl) row.getCTRow(); > List spanList = new ArrayList(); > //add object with format start_coll:end_coll. For example 1:3 will > span from cell 1 to cell 3, where the colum

Re: ALIGN_CENTER_SELECTION question

2010-05-26 Thread MSB
change. Yours Mark B MerlinCristi wrote: > > It will be nice to have this example. For me it was a special request from > the client and I had to find solutions. Tell me where to post the code > with comments and I will make time for this. > > Cristian > > > MSB wr

Re: ALIGN_CENTER_SELECTION question

2010-05-25 Thread MSB
te spans="1:3" >> >> Also if you call cr.getSpans() you will get the list of spans, in my case >> 1:3. But I am unable to edit this list. There is a method setSpans and it >> requires a parameter of type XMLSimpleList but I am unable to add values >> to this li

Re: ALIGN_CENTER_SELECTION question

2010-05-25 Thread MSB
Well, there is an option to center - no, pre Webster so it ought to be centre - the cells contents across a selection in the CellStyle class just as there is in Excel, but like you, I cannot see how to obviously make use of it. Currently, I am thinking about trying to use the ability to create a n

Re: Could POI open Password Protected Excel Sheet....

2010-05-25 Thread MSB
better than is POI. Yours Mark B guruk wrote: > > We are trying to handle the .xls(97-2003) Excel file format > > thanks for your time > > Guru > > > MSB wrote: >> >> Can you tell us please which version of the Excel file format you are >> t

Re: Need help in updating footer of Word Document

2010-05-24 Thread MSB
Made some real progress with this over the past few days. It has entailed a small change to the API - to the XWPFHeaderFooterPolicy class - which I hope to submit for review soon. Once I know whether the work has been accepted and included into the API, I will post examples that show how to insert

Re: Having problems with HWPF

2010-05-24 Thread MSB
HWPF is not yet able to perform search and replace operation successfully as it is an immature and very much in need of development. If you have looked back through the recent posts concerning HWPF you will know that 'we' are crying out for developers to join in and help progress this particular A

Re: Could POI open Password Protected Excel Sheet....

2010-05-24 Thread MSB
Can you tell us please which version of the Excel file format you are targetting; the older binary file format (.xls) or the newer OOXML one (.xlsx)? Yours Mark B guruk wrote: > > Hi, > > Could anyone tell me if poi can open password protected excel file to > convert it to csv, i have the pa

Re: Questions about POI lib

2010-05-23 Thread MSB
Sorry to say that I cannot answer your questions directly and what I say now may sound a little patronising but believe me, it is not meant to be. You do understand that all work undertaken to develop the API is on a voluntary basis don't you? Many people find POI, discover that it does not match

Re: html snippet in cell

2010-05-20 Thread MSB
30275721 > > "Any fool can know. The point is to understand." - Albert Einstein > > > On Thu, May 20, 2010 at 12:52 PM, David Fisher > wrote: > >> Hi Mark, >> >> I am curious what happens if you write strict XHTML to a cell in XSSF? >>

Re: Reading Shapes

2010-05-20 Thread MSB
Hello Al, Sorry to say that I do not have an answer for you but rather a couple of questions. When you say that they are all instances of HSSFTExtbox, how do you know? Have you done a getClass().getName() (shapeList.get(i).getClass().getName()) on the contents of the shapes list? Secondly, I do

Re: html snippet in cell

2010-05-20 Thread MSB
ict 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

Re: html snippet in cell

2010-05-20 Thread MSB
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 case then the answer is no and yes, confused? Had a quick google and found someone had written a macro that you may be able to build upon/develop fu

Re: Need help in updating footer of Word Document

2010-05-19 Thread MSB
I have not forgotten about this thread but have simply been too busy with 'real' work to spend any time at the PC. Tomorrow is my 'office' day and so I will have the time to play with some more code and will post again as soon as I find out anything else. Yours Mark B madhusudan.reddy wrote: >

RE: Need help in updating footer of Word Document

2010-05-17 Thread MSB
asses. Can you please provide the jar for below program? So that I can > do some R & D on this issue. > > Thanks & Regards, > Madhusudan Reddy > JAVA | HDC | Accenture > M. No: 9966601155 > > -Original Message- > From: MSB [mailto:markbrd...@tiscali.co.uk]

Re: Need help in updating footer of Word Document

2010-05-17 Thread MSB
ding a Word > Document fully. After that only I'll focus on involved in writing back. > May > be your case will help me by then. > > Yours, > Shamal > > On Mon, May 17, 2010 at 3:27 PM, MSB wrote: > >> >> Thanks, yes, we now that you can do that but the quesi

Re: Need help in updating footer of Word Document

2010-05-17 Thread MSB
ind the jars. I used POI-3.6 jar but I didn't find the required classes. >> Can you please provide the jar for below program? So that I can do some R >> & >> D on this issue. >> >> Thanks & Regards, >> Madhusudan Reddy >> JAVA | HDC | Accenture

RE: Need help in updating footer of Word Document

2010-05-17 Thread MSB
> classes. Can you please provide the jar for below program? So that I can > do some R & D on this issue. > > Thanks & Regards, > Madhusudan Reddy > JAVA | HDC | Accenture > M. No: 9966601155 > > -Original Message- > From: MSB [mailto:markbrd...@tiscali.co.u

Re: Need help in updating footer of Word Document

2010-05-16 Thread MSB
Only just begun to have a play with XWPF but it already seems much more 'solid' that HWPF as the latter is sorely in need of talented developers to help move it on (not too subtle hint there in case you missed it). However, the news on footers - and on headers for that matter - is still not too g

Re: Need help in updating footer of Word Document

2010-05-16 Thread MSB
Quick update. As it stands, HWPF will not allow you to add a new footer or header into a document nor modify the existing one(s). The HearderStories class is the one you should use to gain access to a documents headers and footers and it does include support for recovering the contents of the sam

RE: Need help in updating footer of Word Document

2010-05-15 Thread MSB
ointers > around that. > > Thanks > Madhu > ____ > From: MSB [markbrd...@tiscali.co.uk] > Sent: Saturday, May 15, 2010 11:56 AM > To: user@poi.apache.org > Subject: Re: Need help in updating footer of Word Document > > Can you t

Re: Need help in updating footer of Word Document

2010-05-14 Thread MSB
Can you tell us please which version of the file format you are targetting, the legacy binary one with HWPF or the newer OOXML one with XWPF? Yours Mark B madhusudan.reddy wrote: > > Hi, > > We are using ApachePOI for creating word documents dynamically using java > in our application. We ar

RE: Problems setting currency format

2010-05-11 Thread MSB
spent too much time on trying to get just the format itself, > Mark, I think I'm going to follow your advice, get the complete style of > the first cell in the column but set the correct rotation and color. > > Thank you very much. > > Sincerely, > > Konstantin. >

RE: Problems setting currency format

2010-05-11 Thread MSB
template. Yours Mark B Szostak, Jonathan wrote: > > I don't want to insult your intelligence, but is the column wide enough to > display numbers over 10,000? > > -Original Message- > From: MSB [mailto:markbrd...@tiscali.co.uk] > Sent: Tuesday, May 11, 2010 1:54 AM

Re: Problems setting currency format

2010-05-10 Thread MSB
If you are copying the format for the cell from another cell that you have already created in your template, is it not simply a matter of doing that, getting the format applied to the template cell and then applying it to the cell you are inserting? That code would look something like this; I am

Re: Get value by adress

2010-05-08 Thread MSB
Have a look at the CellReference class - http://poi.apache.org/apidocs/org/apache/poi/ss/util/CellReference.html - that might be what you are looking for. Yours Mark B Bugzilla from coll...@laboiteaprog.com wrote: > > hi > > is there a way to get cell content by its adresse ? > > exemple i

Re: Convert XLS into CSV

2010-05-08 Thread MSB
Thanks Karel but Luke and I have been doing a bit of work on this - http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java. Lately, there is a pluggable version of the same where you simply create a customised subclass of a handler to convert the Excel in

Re: POI XSSF API how do I lock specific Excel sheet features?

2010-05-05 Thread MSB
? > > > - Original Message - > From: "MSB" > To: > Sent: Wednesday, May 05, 2010 4:09 PM > Subject: Re: POI XSSF API how do I lock specific Excel sheet features? > > >> >> Please do not take this as the definitive example of locking us

Re: POI XSSF API how do I lock specific Excel sheet features?

2010-05-04 Thread MSB
Please do not take this as the definitive example of locking using XSSF. That was simply a small piece of code that I was playing around with because at that time no one seemed to know just whatthe sequence of method calls had to be in order to protect the contents of an Excel workbook built using

  1   2   3   4   5   6   7   >