Problem in getting contents of formula based cell using JXL api in JAVA

Posted by user202328 on Stack Overflow See other posts from Stack Overflow or by user202328
Published on 2009-11-04T04:55:17Z Indexed on 2010/03/13 11:35 UTC
Read the original article Hit count: 337

Filed under:

jxl

Hello,

I am facing a problem while getting contents of cell using JXL api, if I am using formula in xls sheet. Right now I am using formula - IF($L10="","",+ROUND($L10*1.375,3)) in each cell but when the cell value is blank i am getting junk charactes when i call cell.getContents() method, the code snip is as follows - >>

Workbook = Workbook.getWorkbook(p_sourceFile);

excelsheet = workbook.getSheet(0);
for (int row = 1; row < noOfRows; row++)

{ cell = excelsheet.getCell(col, row); content = cell.getContents();

System.out.println("content-" + content); //Is giving me junk character ? when the cell value is blank.

...

It will be a great help if anyone can help me !!!

Regards, Amit

Related posts about jxl

How to use jxl open file turn off gridlines and save

as seen on Stack Overflow - Search for 'Stack Overflow'
I am new to jxl, but I have what I think is a pretty simple requirement. I want to take an existing .xls file with three tabs, turn off the gridlines on all 3, and then save it again. It looks from the API like there is a function to handle gridlines setPrintGridLines(boolean b) I would love it… >>> More
how to insert an object into a cell using JXL api

as seen on Stack Overflow - Search for 'Stack Overflow'
how to insert an object into a cell using JXL api.. i have a file which is not image.. i want to insert it into a cell of Excel sheet.. how can i achieve this?? please help... >>> More
Problem in getting contents of formula based cell using JXL api in JAVA

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am facing a problem while getting contents of cell using JXL api, if I am using formula in xls sheet. Right now I am using formula - IF($L10="","",+ROUND($L10*1.375,3)) in each cell but when the cell value is blank i am getting junk charactes when i call cell.getContents() method, the code… >>> More
Import Data from Excel sheet to DB Table through OAF page

as seen on Oracle Blogs - Search for 'Oracle Blogs'
1. Create a New Workspace and Project File > New > General > Workspace Configured for Oracle Applications File Name – PrajkumarImportxlsDemo Automatically a new OA Project will also be created Project Name -- ImportxlsDemo Default Package -- prajkumar… >>> More
java generated excel sorting color mess.

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using jxl api for generating a excel sheet, in which the alternate rows are highlighted, when I sort the contents of a excel and sort manually, the cell background colors messup, usually this is because I am writing the color cell by cell, is there anyway through which i color the alternate rows… >>> More

Developer IT