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

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 > targetting; the older binary file format (.xls) or the newer OOXML one > (.xlsx)? > > Yours > > Mark B > > > gur

Question about Filtered data in Excel

Hi I want to read the EXCEL filtered data using POI I allways read all the rows, even if the spreadsheet has any filters applied (like in Autofilter case) How can acomplish that? Thanks in advance Juan Véliz

Re: Performance Issue with POI 3.6 as compared to 2.5.1

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

Performance Issue with POI 3.6 as compared to 2.5.1

Hi, I was using POI 2.5.1 to generate .xls files until the record count crossed the 65k+ limit set by Excel 2003. At this point, I switched to POI 3.6 and to XSSFWorkbook (from the previous HSSFWorkbook) to accomodate more number of records. While I am successfuly in generating .xlsx document

ALIGN_CENTER_SELECTION question

Hi. I have a huge problem. I need to use ALIGN_CENTER_SELECTION over 2, 3.. cells but I am not allowed to merge cells And I don't have any idea how to simulate cell selection. I saw in xml file attribute "spans" in row element. Do you know how to use this align style with selected cells? Cristian

Re: Need help in updating footer of Word Document

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

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....

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

Having problems with HWPF

Hi All, I am trying to replace text in a .doc file. When I open the generated document with MSWord, it is empty. But, if I open that document with notepad, I can see the content obviously with unknown characters added. But replaced content is there. Any idea of what am I missing? Thanks for

Re: Problem using newline in XSSFRichTextString (a bug, perhaps?)

On Fri, 21 May 2010, Guilherme Mussi wrote: visually, excel represents my file without the newlines. To check - does excel not show the newlines in excel, or do you mean it shows them but you can't spot them in the xml? excel saves its own newlines like this: text before the newline So it

Could POI open Password Protected Excel Sheet....

Hi, Could anyone tell me if poi can open password protected excel file to convert it to csv, i have the password for the excel file but dont know how to use it in POI Thanks in advance.. -- View this message in context: http://old.nabble.com/Could-POI-open-Password-Protected-Excel-Sheet...