Re: Extract Rich Text Field from excel

2019-10-21 Thread Axel Howind
Hi, I am still not sure what your actual problem is. I suggest you create a small sample program and ask on stackoverflow.com. Just two things: - if you set a font, italics or color for the cell as a whole in Excel, that doesn't change the text contained a RichTextString. That information is

Re: Extract Rich Text Field from excel

2019-10-21 Thread Dominik Stadler
Hi, Apache POI does not support this as far as I know, as you found Excel does not store it this way and so it would be very complicated to do this here. Dominik On Mon, Oct 21, 2019, 09:15 savan raiyani wrote: > yes, I am using Cell.getRichStringCellValue() method to get styled value > from

Re: Extract Rich Text Field from excel

2019-10-21 Thread savan raiyani
yes, I am using Cell.getRichStringCellValue() method to get styled value from excel but my only concern is I have to add my data with HTML tags. If I use styling functionality provided by excel(bold.italic,hyperlink,etc) I am getting a plain string(without any styling) through

Re: Extract Rich Text Field from excel

2019-10-09 Thread savan raiyani
Here just small correction to my previous reply,my apologies. To reproduce excel data you can simply apply styling(bold,italic,hyperlink ,etc) to any cell data of excel I am using Cell.getRichStringCellValue() to get that styled data but unfortunately getting plain string. On 2019/10/08

Re: Extract Rich Text Field from excel

2019-10-08 Thread savan raiyani
To reproduce excel data you can simply apply styling(bold,italic,hyperlink ,etc) to any cell data of excel I am using Cell.getStringCellValue() to get that styled data but unfortunately getting plain string. On 2019/10/08 12:55:34, Jörn Franke wrote: > Can you provide a code snippet on how

Re: Extract Rich Text Field from excel

2019-10-08 Thread Axel Howind
Hi, you have to use [Cell.getRichStringCellValue()](https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/Cell.html#getRichStringCellValue--). But I think questions like this rather belong in the [POI user list](https://lists.apache.org/list.html?u...@poi.apache.org). Axel On

Re: Extract Rich Text Field from excel

2019-10-08 Thread Jörn Franke
Can you provide a code snippet on how you get the RichtextString? Maybe also a link (not attachment) to a formatted Excel to reproduce the problem? It will facilitate troubleshooting significantly. > Am 08.10.2019 um 21:06 schrieb savan raiyani : > > Hi, > > I am trying to fetch Rich text

Extract Rich Text Field from excel

2019-10-08 Thread savan raiyani
Hi, I am trying to fetch Rich text data from excel(data with applied styling like bold,italic,hyperlink etc.) and storing it as a RichTextString object but I am getting plain String object. Do we have any way to keep and store styling of data and send it upfront? If I enter data with HTML