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 <savanraiyani1...@gmail.com> wrote: > 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 > >
