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