i am trying to insert page break end of end page, but my code is not working
XWPFDocument doc = new XWPFDocument(OPCPackage.open(filePath));
int count =0;
List tables = doc.getTables();
for (XW
I am using POI 3.5. I have a validation list defined for a cell in excel.
Using my java program, can I validate if a given string exists in the list ?
Thanks,Venkatesh
Hello,
While working with Apache POI ( XSSFWorkbook / HSSFWorkbook )
Also I have set sheet.autoSizeColumn(i);
I am using sheet.protectSheet(""), after applying this the excel columns or a
rows cannot be resized in terms of their width.
Please let me know how to solve this problem.
T
Basically my requirement is I need to create few read-only columns and at the
same allow user to resize the columns/rows to allow usability of excel.
I have pasted my code below:
package com.ventyx.ltk.report;
import
Hello,
I need to provide Validation and enable formula support for few columns in the
excel sheet.
Sample data in a excel
col1 col2 col3
6apple 5
1> When user types in say col2, I need to automatically update the col3 with
the length of the data that wi
Appreciate any suggestions/help on this.
-Original Message-
From: Mamatha Kodigehalli Venkatesh [mailto:mamatha.venkat...@ness.com]
Sent: Friday, February 04, 2011 3:29 PM
To: POI Users List
Subject: RE: Apache POI -Protected sheet disables the Row/Column resize
Basically my requirement
I tried lockFormatColumns() and
enableLocking() methods on the XSSFSheet object, after setting the cellstyle as
the code that I had posted last, but I still I find that unlocked columns
cannot be resized.
-Mamatha
-Original Message-
From: Mark Beardsley [mailto:markbrd...@tiscali.co.uk
Hello Mark,
Microsoft excel also does not allow to resize the columns if the workbook is
password protected.
I was wondering if there is any way in POI just makes the column alone
read-only without making the sheet protected.
Thanks
Mamatha
-Original Message-
From: Mark B
It does not allow resizing of any columns those that may be read only and also
those that are not, since we are protecting the sheet.
Even I think it is better to accept excel behavior.
Thanks again Mark
Mamatha
-Original Message-
From: Mark Beardsley [mailto:markbrd...@tiscali.co.uk]
S
Hello,
I was able to use BigGridDemo for creating .xlsx using XSSF
I want HSSF support to get the sheet Ref as the HSSFSheet does not have the
support of sheet.getPackagePart().getPartName().getName();
XSSFSheet sheet = wb.createSheet("Repository");
String sheetRef = sheet.getPackagePart().ge
Any Comments/suggestion for my question below.
-Original Message-
From: Mamatha Kodigehalli Venkatesh [mailto:mamatha.venkat...@ness.com]
Sent: Friday, March 04, 2011 2:45 PM
To: POI Users List
Subject: Support for HSSF(.xls) in BigGridDemo
Hello,
I was able to use BigGridDemo for
Hello,
I have been looking HSSFDataValidation and was able to run the sample below.
My requirement is I need to apply this formula for Entire column to achieve the
need like
When user enters data in col2 (B) of greater than the number specified in col1
(A) and then show the ErrorBox.
BigGridDemo
On Mon, 14 Mar 2011, Mamatha Kodigehalli Venkatesh wrote:
> I was able to use BigGridDemo for creating .xlsx using XSSF
>
> I want HSSF support to get the sheet Ref as the HSSFSheet does not have
> the support of sheet.getPackagePart().getPartName().getName();
BigGridDemo
-Original Message-
From: Mamatha Kodigehalli Venkatesh [mailto:mamatha.venkat...@ness.com]
Sent: Monday, March 14, 2011 6:12 PM
To: POI Users List
Subject: Formula for Entire Column using DataValidation
Hello,
I have been looking HSSFDataValidation and was able to run the sample
workbook.write(fos);
} catch (Exception e) {
System.out.println(e);
}
}
Thanks
Mamatha
-Original Message-
From: Mamatha Kodigehalli Venkatesh [mailto:mamatha.venkat...@ness.com]
Sent: Tuesday, March 15, 2011 1:41 PM
To: POI Users List
Subject: Any Quick help. F
15 matches
Mail list logo
