You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by 陈 杨阳 <ni...@outlook.com> on 2016/08/19 01:54:15 UTC
返: The CellType of a cell which is set to String
Actually, I want to get the value in cells and change them to String in Java.(numeric -> String, string -> String, and so on).
Sometimes, I'm not sure what CellType it is. So I want to know the CellType at first, and then I can convert them to String.
As you said, I can directly use DataFormatter to convert the cell value to a printed String. The printed String is what I want. Am I correct?
> -----元のメッセージ-----
> 差出人: Javen O'Neal [mailto:javenoneal@gmail.com]
> 送信日時: 2016年8月12日 23:35
> 宛先: POI Users List <us...@poi.apache.org>
> 件名: Re: The CellType of a cell which is set to String
>
> To see how Excel actually saved the values, unzip the xlsx file and open
> sheet1.xml. You should see a couple <c> elements, with a value and type.
>
> On Aug 12, 2016 8:32 AM, wrote:
>
> The cell data format is a distinct concept from the cell value. The format only
> defines how the value should be printed, but doesn't change the underlying value.
>
> If you want to convert the cell value to a printed string, use
> https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.ht
> ml
>
> On Aug 12, 2016 2:59 AM, "niaomingjian@outlook.com" < niaomingjian@outlook.com>
> wrote:
>
> Hi
>
> In a excel,
> Firstly, I typed '1' in A1, then I changed the format of this cell to String.
> Secondly, I changed the format of A2 to Standard(the default format), then I
> typed '1' in this cell.
> Finally, I saved this excel.
>
> This is my excel file for test.
> I’m using poi 3.14.
> My source is very simple, as following:
> ================================================
> File file = new File("1.xlsx");
>
> Workbook wb = WorkbookFactory.create(file);
>
> Sheet sheet = wb.getSheetAt(0);
>
> System.out.println(sheet.getRow(0).getCell(0).getCellType());
> System.out.println(sheet.getRow(1).getCell(0).getCellType());
>
> wb.close();
> ================================================
>
> output:
> ============
> 0
> 1
> ============
>
> The result shows that A1's type is CELL_TYPE_NUMERIC, and A2's type is
> CELL_TYPE_STRING.
>
> Though I set both cells to String, the results are different.
>
> In addition, in this excel, the appearance of these two cells are also different.
> There is a green triangle at the top-right corner of A2.
>
> Could anyone explain this for me?
>
> Regards,
> Young
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional
> commands, e-mail: user-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Apach POI doc/docx parser
Posted by Dominik Stadler <do...@gmx.at>.
Hi,
it seems the document does not make it through the list for some reason,
can you report an issue at https://bz.apache.org/bugzilla/ and attach it
there. This way we also have a better trail of work on the problem.
Dominik.
On Mon, Oct 7, 2019 at 6:33 AM Teresa Kim
<te...@linguamatics.com.invalid> wrote:
> Hi Dominik
>
>
> Sure I attached the symbol_test.doc document in the previous email.
>
> I think I cannot attach the document in email?
>
> Is there anyway I can share the document?
>
>
> Thanks
>
> T.
>
> On 06/10/2019 16:29, Dominik Stadler wrote:
> > Hi,
> >
> > can you share an example document which shows the behavior?
> >
> > Thanks... Dominik.
> >
> >
> > On Sun, Oct 6, 2019 at 6:48 AM Teresa Kim
> > <te...@linguamatics.com.invalid> wrote:
> >
> >> Hi
> >>
> >>
> >> I have documents (either 'doc' or 'docx') that have a special character
> >> for 'greater than equal' and using codes in 'WordToHtmlConverter', I see
> >> those characters are converted into '('.
> >>
> >> I tried with the latest apache poi release 4.1.0.
> >>
> >>
> >> My java code is:
> >>
> >>
> >> public class TestWordtoHtmlConverter {
> >>
> >> public static void main(String[] args ) {
> >> try {
> >> HWPFDocumentCore wordDocument = WordToHtmlUtils.loadDoc(new
> >> FileInputStream(args[0]));
> >>
> >> WordToHtmlConverter wordToHtmlConverter = new
> WordToHtmlConverter(
> >>
> DocumentBuilderFactory.newInstance().newDocumentBuilder()
> >> .newDocument());
> >>
> >> wordToHtmlConverter.processDocument(wordDocument);
> >> Document htmlDocument = wordToHtmlConverter.getDocument();
> >> ByteArrayOutputStream out = new ByteArrayOutputStream();
> >> DOMSource domSource = new DOMSource(htmlDocument);
> >> StreamResult streamResult = new StreamResult(out);
> >>
> >> TransformerFactory tf = TransformerFactory.newInstance();
> >> Transformer serializer = tf.newTransformer();
> >> serializer.setOutputProperty(OutputKeys.ENCODING, "UTF-8");
> >> serializer.setOutputProperty(OutputKeys.INDENT, "yes");
> >> serializer.setOutputProperty(OutputKeys.METHOD, "html");
> >> serializer.transform(domSource, streamResult);
> >> out.close();
> >>
> >> String result = new String(out.toByteArray());
> >> System.out.println(result);
> >> } catch (Exception e) {
> >> }
> >>
> >> Is there anyway I can correctly identify these symbols?
> >>
> >>
> >> In the sample document, I am interested in getting 'bad one'.
> >>
> >>
> >> Thanks
> >>
> >> T.
> >>
> >>
> >>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> >> For additional commands, e-mail: user-help@poi.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
Re: Apach POI doc/docx parser
Posted by Teresa Kim <te...@linguamatics.com.INVALID>.
Hi Dominik
Sure I attached the symbol_test.doc document in the previous email.
I think I cannot attach the document in email?
Is there anyway I can share the document?
Thanks
T.
On 06/10/2019 16:29, Dominik Stadler wrote:
> Hi,
>
> can you share an example document which shows the behavior?
>
> Thanks... Dominik.
>
>
> On Sun, Oct 6, 2019 at 6:48 AM Teresa Kim
> <te...@linguamatics.com.invalid> wrote:
>
>> Hi
>>
>>
>> I have documents (either 'doc' or 'docx') that have a special character
>> for 'greater than equal' and using codes in 'WordToHtmlConverter', I see
>> those characters are converted into '('.
>>
>> I tried with the latest apache poi release 4.1.0.
>>
>>
>> My java code is:
>>
>>
>> public class TestWordtoHtmlConverter {
>>
>> public static void main(String[] args ) {
>> try {
>> HWPFDocumentCore wordDocument = WordToHtmlUtils.loadDoc(new
>> FileInputStream(args[0]));
>>
>> WordToHtmlConverter wordToHtmlConverter = new WordToHtmlConverter(
>> DocumentBuilderFactory.newInstance().newDocumentBuilder()
>> .newDocument());
>>
>> wordToHtmlConverter.processDocument(wordDocument);
>> Document htmlDocument = wordToHtmlConverter.getDocument();
>> ByteArrayOutputStream out = new ByteArrayOutputStream();
>> DOMSource domSource = new DOMSource(htmlDocument);
>> StreamResult streamResult = new StreamResult(out);
>>
>> TransformerFactory tf = TransformerFactory.newInstance();
>> Transformer serializer = tf.newTransformer();
>> serializer.setOutputProperty(OutputKeys.ENCODING, "UTF-8");
>> serializer.setOutputProperty(OutputKeys.INDENT, "yes");
>> serializer.setOutputProperty(OutputKeys.METHOD, "html");
>> serializer.transform(domSource, streamResult);
>> out.close();
>>
>> String result = new String(out.toByteArray());
>> System.out.println(result);
>> } catch (Exception e) {
>> }
>>
>> Is there anyway I can correctly identify these symbols?
>>
>>
>> In the sample document, I am interested in getting 'bad one'.
>>
>>
>> Thanks
>>
>> T.
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Apach POI doc/docx parser
Posted by Dominik Stadler <do...@gmx.at>.
Hi,
can you share an example document which shows the behavior?
Thanks... Dominik.
On Sun, Oct 6, 2019 at 6:48 AM Teresa Kim
<te...@linguamatics.com.invalid> wrote:
> Hi
>
>
> I have documents (either 'doc' or 'docx') that have a special character
> for 'greater than equal' and using codes in 'WordToHtmlConverter', I see
> those characters are converted into '('.
>
> I tried with the latest apache poi release 4.1.0.
>
>
> My java code is:
>
>
> public class TestWordtoHtmlConverter {
>
> public static void main(String[] args ) {
> try {
> HWPFDocumentCore wordDocument = WordToHtmlUtils.loadDoc(new
> FileInputStream(args[0]));
>
> WordToHtmlConverter wordToHtmlConverter = new WordToHtmlConverter(
> DocumentBuilderFactory.newInstance().newDocumentBuilder()
> .newDocument());
>
> wordToHtmlConverter.processDocument(wordDocument);
> Document htmlDocument = wordToHtmlConverter.getDocument();
> ByteArrayOutputStream out = new ByteArrayOutputStream();
> DOMSource domSource = new DOMSource(htmlDocument);
> StreamResult streamResult = new StreamResult(out);
>
> TransformerFactory tf = TransformerFactory.newInstance();
> Transformer serializer = tf.newTransformer();
> serializer.setOutputProperty(OutputKeys.ENCODING, "UTF-8");
> serializer.setOutputProperty(OutputKeys.INDENT, "yes");
> serializer.setOutputProperty(OutputKeys.METHOD, "html");
> serializer.transform(domSource, streamResult);
> out.close();
>
> String result = new String(out.toByteArray());
> System.out.println(result);
> } catch (Exception e) {
> }
>
> Is there anyway I can correctly identify these symbols?
>
>
> In the sample document, I am interested in getting 'bad one'.
>
>
> Thanks
>
> T.
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
Apach POI doc/docx parser
Posted by Teresa Kim <te...@linguamatics.com.INVALID>.
Hi
I have documents (either 'doc' or 'docx') that have a special character
for 'greater than equal' and using codes in 'WordToHtmlConverter', I see
those characters are converted into '('.
I tried with the latest apache poi release 4.1.0.
My java code is:
public class TestWordtoHtmlConverter {
public static void main(String[] args ) {
try {
HWPFDocumentCore wordDocument = WordToHtmlUtils.loadDoc(new FileInputStream(args[0]));
WordToHtmlConverter wordToHtmlConverter = new WordToHtmlConverter(
DocumentBuilderFactory.newInstance().newDocumentBuilder()
.newDocument());
wordToHtmlConverter.processDocument(wordDocument);
Document htmlDocument = wordToHtmlConverter.getDocument();
ByteArrayOutputStream out = new ByteArrayOutputStream();
DOMSource domSource = new DOMSource(htmlDocument);
StreamResult streamResult = new StreamResult(out);
TransformerFactory tf = TransformerFactory.newInstance();
Transformer serializer = tf.newTransformer();
serializer.setOutputProperty(OutputKeys.ENCODING, "UTF-8");
serializer.setOutputProperty(OutputKeys.INDENT, "yes");
serializer.setOutputProperty(OutputKeys.METHOD, "html");
serializer.transform(domSource, streamResult);
out.close();
String result = new String(out.toByteArray());
System.out.println(result);
} catch (Exception e) {
}
Is there anyway I can correctly identify these symbols?
In the sample document, I am interested in getting 'bad one'.
Thanks
T.
Re: 返: The CellType of a cell which is set to String
Posted by Javen O'Neal <ja...@gmail.com>.
I had some time and wrote the unit test and patch.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60025
On Fri, Aug 19, 2016 at 8:31 AM, Javen O'Neal <ja...@gmail.com> wrote:
> https://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/usermodel/DataFormatter.java?revision=1753122&view=markup#l897
>
> Looks like it isn't being uppercased. String.valueOf(false) -> "false"
>
> Do you want to open a bug at https://bz.apache.org/bugzilla and submit
> a patch with a unit test?
>
> On Fri, Aug 19, 2016 at 12:01 AM, Young <ni...@outlook.com> wrote:
>> If I use the default format of the cell(Standard) and type 'FALSE' in this cell, then I get the value 'false' in the cell by using formatCellValue method.
>> Actually, I hope that I can get the value 'FALSE', not lowercase 'false'.
>>
>> Could I achieve this by using DataFormatter?
>>
>> On 2016-08-19 10:48 (+0800), "Javen O'Neal" <ja...@gmail.com> wrote:
>>> Yes. DataFormatter does what you want: get the string representation of the
>>> cell contents (numeric, date, string, boolean, blank, error, formula)
>>>
>>> On Aug 18, 2016 18:54, "陈 杨阳" <ni...@outlook.com> wrote:
>>>
>>> > Actually, I want to get the value in cells and change them to String in
>>> > Java.(numeric -> String, string -> String, and so on).
>>> > Sometimes, I'm not sure what CellType it is. So I want to know the
>>> > CellType at first, and then I can convert them to String.
>>> >
>>> > As you said, I can directly use DataFormatter to convert the cell value to
>>> > a printed String. The printed String is what I want. Am I correct?
>>> >
>>> > > -----元のメッセージ-----
>>> > > 差出人: Javen O'Neal [mailto:javenoneal@gmail.com]
>>> > > 送信日時: 2016年8月12日 23:35
>>> > > 宛先: POI Users List <us...@poi.apache.org>
>>> > > 件名: Re: The CellType of a cell which is set to String
>>> > >
>>> > > To see how Excel actually saved the values, unzip the xlsx file and open
>>> > > sheet1.xml. You should see a couple <c> elements, with a value and type.
>>> > >
>>> > > On Aug 12, 2016 8:32 AM, wrote:
>>> > >
>>> > > The cell data format is a distinct concept from the cell value. The
>>> > format only
>>> > > defines how the value should be printed, but doesn't change the
>>> > underlying value.
>>> > >
>>> > > If you want to convert the cell value to a printed string, use
>>> > > https://poi.apache.org/apidocs/org/apache/poi/ss/
>>> > usermodel/DataFormatter.ht
>>> > > ml
>>> > >
>>> > > On Aug 12, 2016 2:59 AM, "niaomingjian@outlook.com" <
>>> > niaomingjian@outlook.com>
>>> > > wrote:
>>> > >
>>> > > Hi
>>> > >
>>> > > In a excel,
>>> > > Firstly, I typed '1' in A1, then I changed the format of this cell to
>>> > String.
>>> > > Secondly, I changed the format of A2 to Standard(the default format),
>>> > then I
>>> > > typed '1' in this cell.
>>> > > Finally, I saved this excel.
>>> > >
>>> > > This is my excel file for test.
>>> > > I’m using poi 3.14.
>>> > > My source is very simple, as following:
>>> > > ================================================
>>> > > File file = new File("1.xlsx");
>>> > >
>>> > > Workbook wb = WorkbookFactory.create(file);
>>> > >
>>> > > Sheet sheet = wb.getSheetAt(0);
>>> > >
>>> > > System.out.println(sheet.getRow(0).getCell(0).getCellType());
>>> > > System.out.println(sheet.getRow(1).getCell(0).getCellType());
>>> > >
>>> > > wb.close();
>>> > > ================================================
>>> > >
>>> > > output:
>>> > > ============
>>> > > 0
>>> > > 1
>>> > > ============
>>> > >
>>> > > The result shows that A1's type is CELL_TYPE_NUMERIC, and A2's type is
>>> > > CELL_TYPE_STRING.
>>> > >
>>> > > Though I set both cells to String, the results are different.
>>> > >
>>> > > In addition, in this excel, the appearance of these two cells are also
>>> > different.
>>> > > There is a green triangle at the top-right corner of A2.
>>> > >
>>> > > Could anyone explain this for me?
>>> > >
>>> > > Regards,
>>> > > Young
>>> > >
>>> > >
>>> > > ---------------------------------------------------------------------
>>> > > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional
>>> > > commands, e-mail: user-help@poi.apache.org
>>> >
>>> > ---------------------------------------------------------------------
>>> > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>>> > For additional commands, e-mail: user-help@poi.apache.org
>>> >
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: 返: The CellType of a cell which is set to String
Posted by Javen O'Neal <ja...@gmail.com>.
https://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/usermodel/DataFormatter.java?revision=1753122&view=markup#l897
Looks like it isn't being uppercased. String.valueOf(false) -> "false"
Do you want to open a bug at https://bz.apache.org/bugzilla and submit
a patch with a unit test?
On Fri, Aug 19, 2016 at 12:01 AM, Young <ni...@outlook.com> wrote:
> If I use the default format of the cell(Standard) and type 'FALSE' in this cell, then I get the value 'false' in the cell by using formatCellValue method.
> Actually, I hope that I can get the value 'FALSE', not lowercase 'false'.
>
> Could I achieve this by using DataFormatter?
>
> On 2016-08-19 10:48 (+0800), "Javen O'Neal" <ja...@gmail.com> wrote:
>> Yes. DataFormatter does what you want: get the string representation of the
>> cell contents (numeric, date, string, boolean, blank, error, formula)
>>
>> On Aug 18, 2016 18:54, "陈 杨阳" <ni...@outlook.com> wrote:
>>
>> > Actually, I want to get the value in cells and change them to String in
>> > Java.(numeric -> String, string -> String, and so on).
>> > Sometimes, I'm not sure what CellType it is. So I want to know the
>> > CellType at first, and then I can convert them to String.
>> >
>> > As you said, I can directly use DataFormatter to convert the cell value to
>> > a printed String. The printed String is what I want. Am I correct?
>> >
>> > > -----元のメッセージ-----
>> > > 差出人: Javen O'Neal [mailto:javenoneal@gmail.com]
>> > > 送信日時: 2016年8月12日 23:35
>> > > 宛先: POI Users List <us...@poi.apache.org>
>> > > 件名: Re: The CellType of a cell which is set to String
>> > >
>> > > To see how Excel actually saved the values, unzip the xlsx file and open
>> > > sheet1.xml. You should see a couple <c> elements, with a value and type.
>> > >
>> > > On Aug 12, 2016 8:32 AM, wrote:
>> > >
>> > > The cell data format is a distinct concept from the cell value. The
>> > format only
>> > > defines how the value should be printed, but doesn't change the
>> > underlying value.
>> > >
>> > > If you want to convert the cell value to a printed string, use
>> > > https://poi.apache.org/apidocs/org/apache/poi/ss/
>> > usermodel/DataFormatter.ht
>> > > ml
>> > >
>> > > On Aug 12, 2016 2:59 AM, "niaomingjian@outlook.com" <
>> > niaomingjian@outlook.com>
>> > > wrote:
>> > >
>> > > Hi
>> > >
>> > > In a excel,
>> > > Firstly, I typed '1' in A1, then I changed the format of this cell to
>> > String.
>> > > Secondly, I changed the format of A2 to Standard(the default format),
>> > then I
>> > > typed '1' in this cell.
>> > > Finally, I saved this excel.
>> > >
>> > > This is my excel file for test.
>> > > I’m using poi 3.14.
>> > > My source is very simple, as following:
>> > > ================================================
>> > > File file = new File("1.xlsx");
>> > >
>> > > Workbook wb = WorkbookFactory.create(file);
>> > >
>> > > Sheet sheet = wb.getSheetAt(0);
>> > >
>> > > System.out.println(sheet.getRow(0).getCell(0).getCellType());
>> > > System.out.println(sheet.getRow(1).getCell(0).getCellType());
>> > >
>> > > wb.close();
>> > > ================================================
>> > >
>> > > output:
>> > > ============
>> > > 0
>> > > 1
>> > > ============
>> > >
>> > > The result shows that A1's type is CELL_TYPE_NUMERIC, and A2's type is
>> > > CELL_TYPE_STRING.
>> > >
>> > > Though I set both cells to String, the results are different.
>> > >
>> > > In addition, in this excel, the appearance of these two cells are also
>> > different.
>> > > There is a green triangle at the top-right corner of A2.
>> > >
>> > > Could anyone explain this for me?
>> > >
>> > > Regards,
>> > > Young
>> > >
>> > >
>> > > ---------------------------------------------------------------------
>> > > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional
>> > > commands, e-mail: user-help@poi.apache.org
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> > For additional commands, e-mail: user-help@poi.apache.org
>> >
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: 返: The CellType of a cell which is set to String
Posted by Young <ni...@outlook.com>.
If I use the default format of the cell(Standard) and type 'FALSE' in this cell, then I get the value 'false' in the cell by using formatCellValue method.
Actually, I hope that I can get the value 'FALSE', not lowercase 'false'.
Could I achieve this by using DataFormatter?
On 2016-08-19 10:48 (+0800), "Javen O'Neal" <ja...@gmail.com> wrote:
> Yes. DataFormatter does what you want: get the string representation of the
> cell contents (numeric, date, string, boolean, blank, error, formula)
>
> On Aug 18, 2016 18:54, "\u9648 \u6768\u9633" <ni...@outlook.com> wrote:
>
> > Actually, I want to get the value in cells and change them to String in
> > Java.(numeric -> String, string -> String, and so on).
> > Sometimes, I'm not sure what CellType it is. So I want to know the
> > CellType at first, and then I can convert them to String.
> >
> > As you said, I can directly use DataFormatter to convert the cell value to
> > a printed String. The printed String is what I want. Am I correct?
> >
> > > -----\u5143\u306e\u30e1\u30c3\u30bb\u30fc\u30b8-----
> > > \u5dee\u51fa\u4eba: Javen O'Neal [mailto:javenoneal@gmail.com]
> > > \u9001\u4fe1\u65e5\u6642: 2016\u5e748\u670812\u65e5 23:35
> > > \u5b9b\u5148: POI Users List <us...@poi.apache.org>
> > > \u4ef6\u540d: Re: The CellType of a cell which is set to String
> > >
> > > To see how Excel actually saved the values, unzip the xlsx file and open
> > > sheet1.xml. You should see a couple <c> elements, with a value and type.
> > >
> > > On Aug 12, 2016 8:32 AM, wrote:
> > >
> > > The cell data format is a distinct concept from the cell value. The
> > format only
> > > defines how the value should be printed, but doesn't change the
> > underlying value.
> > >
> > > If you want to convert the cell value to a printed string, use
> > > https://poi.apache.org/apidocs/org/apache/poi/ss/
> > usermodel/DataFormatter.ht
> > > ml
> > >
> > > On Aug 12, 2016 2:59 AM, "niaomingjian@outlook.com" <
> > niaomingjian@outlook.com>
> > > wrote:
> > >
> > > Hi
> > >
> > > In a excel,
> > > Firstly, I typed '1' in A1, then I changed the format of this cell to
> > String.
> > > Secondly, I changed the format of A2 to Standard(the default format),
> > then I
> > > typed '1' in this cell.
> > > Finally, I saved this excel.
> > >
> > > This is my excel file for test.
> > > I\u2019m using poi 3.14.
> > > My source is very simple, as following:
> > > ================================================
> > > File file = new File("1.xlsx");
> > >
> > > Workbook wb = WorkbookFactory.create(file);
> > >
> > > Sheet sheet = wb.getSheetAt(0);
> > >
> > > System.out.println(sheet.getRow(0).getCell(0).getCellType());
> > > System.out.println(sheet.getRow(1).getCell(0).getCellType());
> > >
> > > wb.close();
> > > ================================================
> > >
> > > output:
> > > ============
> > > 0
> > > 1
> > > ============
> > >
> > > The result shows that A1's type is CELL_TYPE_NUMERIC, and A2's type is
> > > CELL_TYPE_STRING.
> > >
> > > Though I set both cells to String, the results are different.
> > >
> > > In addition, in this excel, the appearance of these two cells are also
> > different.
> > > There is a green triangle at the top-right corner of A2.
> > >
> > > Could anyone explain this for me?
> > >
> > > Regards,
> > > Young
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional
> > > commands, e-mail: user-help@poi.apache.org
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> > For additional commands, e-mail: user-help@poi.apache.org
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: 返: The CellType of a cell which is set to String
Posted by Javen O'Neal <ja...@gmail.com>.
Yes. DataFormatter does what you want: get the string representation of the
cell contents (numeric, date, string, boolean, blank, error, formula)
On Aug 18, 2016 18:54, "陈 杨阳" <ni...@outlook.com> wrote:
> Actually, I want to get the value in cells and change them to String in
> Java.(numeric -> String, string -> String, and so on).
> Sometimes, I'm not sure what CellType it is. So I want to know the
> CellType at first, and then I can convert them to String.
>
> As you said, I can directly use DataFormatter to convert the cell value to
> a printed String. The printed String is what I want. Am I correct?
>
> > -----元のメッセージ-----
> > 差出人: Javen O'Neal [mailto:javenoneal@gmail.com]
> > 送信日時: 2016年8月12日 23:35
> > 宛先: POI Users List <us...@poi.apache.org>
> > 件名: Re: The CellType of a cell which is set to String
> >
> > To see how Excel actually saved the values, unzip the xlsx file and open
> > sheet1.xml. You should see a couple <c> elements, with a value and type.
> >
> > On Aug 12, 2016 8:32 AM, wrote:
> >
> > The cell data format is a distinct concept from the cell value. The
> format only
> > defines how the value should be printed, but doesn't change the
> underlying value.
> >
> > If you want to convert the cell value to a printed string, use
> > https://poi.apache.org/apidocs/org/apache/poi/ss/
> usermodel/DataFormatter.ht
> > ml
> >
> > On Aug 12, 2016 2:59 AM, "niaomingjian@outlook.com" <
> niaomingjian@outlook.com>
> > wrote:
> >
> > Hi
> >
> > In a excel,
> > Firstly, I typed '1' in A1, then I changed the format of this cell to
> String.
> > Secondly, I changed the format of A2 to Standard(the default format),
> then I
> > typed '1' in this cell.
> > Finally, I saved this excel.
> >
> > This is my excel file for test.
> > I’m using poi 3.14.
> > My source is very simple, as following:
> > ================================================
> > File file = new File("1.xlsx");
> >
> > Workbook wb = WorkbookFactory.create(file);
> >
> > Sheet sheet = wb.getSheetAt(0);
> >
> > System.out.println(sheet.getRow(0).getCell(0).getCellType());
> > System.out.println(sheet.getRow(1).getCell(0).getCellType());
> >
> > wb.close();
> > ================================================
> >
> > output:
> > ============
> > 0
> > 1
> > ============
> >
> > The result shows that A1's type is CELL_TYPE_NUMERIC, and A2's type is
> > CELL_TYPE_STRING.
> >
> > Though I set both cells to String, the results are different.
> >
> > In addition, in this excel, the appearance of these two cells are also
> different.
> > There is a green triangle at the top-right corner of A2.
> >
> > Could anyone explain this for me?
> >
> > Regards,
> > Young
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional
> > commands, e-mail: user-help@poi.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>