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  
Cell.getRichStringCellValue() method.
Can you please suggest the way to pull styled data from excel if any?
Thanks for your reply.

On 2019/10/08 13:07:37, Axel Howind <mailxze...@gmail.com> wrote: 
> 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 2019/10/08 11:40:54, savan raiyani <savanraiyani1...@gmail.com> wrote: 
> > 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 tags in excel then I am getting styled data. Is 
> > this a only way to fetch Rich text data from excel?
> > 
> > Thanks in advance.
> > 
> > Regards
> > Savan
> > 
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
> > For additional commands, e-mail: dev-h...@poi.apache.org
> > 
> > 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
> For additional commands, e-mail: dev-h...@poi.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to