Hi!
I have an Excel file for which POI does not return all rows. The file is in
attachment.
I have tried with POI 3.11 and 3.15beta2 with same results.
Program I use:
FileInputStream fis = null;
try {
File file = new
File("/home/gregor/tmp/smyk/LIVE4/POI_TEST.xls");
Gregor,
Rows and Cell are shown in Excel, even when not there (meaning
Row==Null or Cell==Null).
Your need to create a row first and the populate it with cells.
Best regards
On Wed, 2016-08-17 at 12:40 +0200, Gregor Kovač wrote:
> Hi!
> > I have an Excel file for which POI does not return all ro
Hi!
Can you please give me a corrected program that I sent in first e-mail?
Best regards,
Kovi
2016-08-17 12:47 GMT+02:00 Andreas Reichel :
> Gregor,
>
> Rows and Cell are shown in Excel, even when not there (meaning
> Row==Null or Cell==Null).
> Your need to create a row first and the popu
Your program is correct! 19th row is in 20th line :)
Line 20 has no row. Sheet.getRow(19)==null! Rows and Cell can be
physically empty!
try {
File file = new
File("/home/gregor/tmp/smyk/LIVE4/POI_TEST.xls");
fis = new
FileInputStream(file);
Workbook work
Hi!
I know that rows are 0 based, but I didn't know that there can actually be
physically missing rows. Thanks for that. :)
Best regards,
Kovi
2016-08-17 13:13 GMT+02:00 Andreas Reichel :
> Your program is correct! 19th row is in 20th line :)
> Line 20 has no row. Sheet.getRow(19)==null! Ro
Thank Microsoft for that, I claim to have had nothing to do with that.
:)
Cheers!
On Wed, 2016-08-17 at 13:17 +0200, Gregor Kovač wrote:
> Hi!
>
> > I know that rows are 0 based, but I didn't know that there can
actually be
> physically missing rows. Thanks for that. :)
>
> Best regards,
> K
Hello
I need a little help. When I got xls file created with formula in email
since I open for edit I only see a 4 value at the place of formulas.
Is this the excel function that formulas is not computed in protected mode?
Mester József
--
On 16.08.2016 10:12, Guillaume Lucazeau wrote:
> I have created a very small bundle here:
> https://github.com/glucazeau/test-poi-sling
> If you're willing to test, you should find everything to install Sling and
> deploy the bundle in the README. If not, just tell me and I'll provide
> missing inf
Hi,
Sorry but it is not clear to me what exactly you are trying to do here.
Maybe you have some code-samples or sample-files that help explain what you
are trying to achieve?
Dominik.
On Wed, Aug 17, 2016 at 1:22 PM, Mester József wrote:
> Hello
>
> I need a little help. When I got xls file cr
Thank you. But realized it ia Excel settings problem.
2016.08.17. 22:45 ezt írta ("Dominik Stadler" ):
> Hi,
>
> Sorry but it is not clear to me what exactly you are trying to do here.
> Maybe you have some code-samples or sample-files that help explain what you
> are trying to achieve?
>
> Domi
10 matches
Mail list logo
